Posts Tagged: SQL
Save dynamic query output in a variable in sql server
In this article we are going to learn save dynamic query output in a variable. For that first i need to create a table. So you can find script of creating table. Table Name : InvoiceLocations CREATE TABLE [dbo].[InvoiceLocations]( [Id]… Continue Reading →
What is output when we write null = null in where clause
What is output when we write null = null in where clause
How to find column name within all tables in sql server
Problem I was trying write a procedure with some logic and in that scenario have to find out that how many table contain column-name like “sales” in my database. In my view there is two solution for this may be… Continue Reading →
How to Write a Stored Procedure in SQL Server
In this article we learn what a Stored Procedure is and how to make a Stored Procedure in SQL Server.