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 generate an insert script that includes all stored rows in sql server

In this article we learn how to generate an insert script that includes all stored rows in sql server.