A while before few weeks, I discussed about an error of replication “The row was not found at the Subscriber when applying the replicated command”. We had a tricks to get discrepancies for error table and resolved issue. Let me put another method (Actu...

During working with one logic, i got chance to work with PIVOT operation. Sometime we need do require rowdata as column in our custom logic, then we can use some temp table and then populate agreegate data in temp table. But With PIVOT w......

BCP is one of the fastest methods to export data to various formats like csv,txt,etc and doing this in a command mode is faster than doing it via SSMS.
Let us create this simple tablecreate table test(id int, name varchar(50))
insert into test(id,name)...

The SQL Server Management Studio (SSMS) is a very powerful IDE and one of the most used tools by any SQL Server professional. This part of the tutorial explains the anatomy of the available editors, associated colour coding, it's toolbars and menus. We also touch upon revolutionary features like Intellisense, Error List, multi-monitor support and query regions...

There are utilities, tools and graphical designers available within SSMS which are useful to audiences of multiple levels and allow one to perform basic SQL Server development without writing a single line of T-SQL code. Some such designers are the table designer, Scripting engine, Query Designer and Template Explorer. This is a L100 tutorial....

Often developers use Import wizard from SSMS or SSIS to import data from a text file into a table. You may or may not import it successfully based on the nature of the data.
Create a text file named test.txt with the following data
id|name|address1|rame...

1) Transaction log are not recorded for table variables so they are transactional neutral or you can say that they are out of scope of transaction mechanism. Whereas temp tables participate in transactions just like normal tables
2) Table variables c......