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.