A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances. A Tool can do the things as below: 1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...

A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances. A Tool can do the things as below: 1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

I was just browsing the history of Microsoft Business intelligence when I learned that "Microsoft entered the market of OLAP tech w/ SQL server 7.0 (1998) after acquiring the technology from Panorama Software"...

I was just browsing the history of Microsoft Business intelligence when I learned that "Microsoft entered the market of OLAP tech w/ SQL server 7.0 (1998) after acquiring the technology from Panorama Software"...

create table #temp ( a varchar(10) ) insert into #temp values(' a ') select COUNT(*) from #temp where a=' a' select COUNT(*) from #temp where a='a' first query will return 1 2nd will return 0 as sql ...

create table #temp ( a varchar(10) ) insert into #temp values(' a ') select COUNT(*) from #temp where a=' a' select COUNT(*) from #temp where a='a' first query will return 1 2nd will return 0 as sql ...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...

There's no way to return a resultset and set variables using a single SELECT statement. But there's one way to do it using a MERGE statement. It's quite simple, you first declare a variable table which will be used to store some data. You then use a...