News Regarding Post bind csid (#) does non gibe session csid (#)

Problem "bind csid (#) does non stand upwards for session csid (#)" After farther investigation together with analysis, hither t...

Read More

SQL Server - How to Bulk Insert data into a table with Identity Column?

If you need to bulk insert data (in an application or a sql query) into some table with identity column,there is a simple solution: Create V...

Read More

T-SQL Batch Seperator - GO [number]

As you know 'GO' is a T-SQL batch seperator command and it is not T-SQL statement.It is a command recognized by the 'sqlcmd'...

Read More

How to generate autonumber (identity) value in existing table in single Update statement

Suppose you have some table and you want to populate some column with AutoNumber (Identity) value . For this task we can use SET @variable =...

Read More

What are the major differences between Temporary Table and Variable Table

First of all, there is no universal rule for when and where to use temp table or variable table. But using table variables for small to medi...

Read More

NULL value in Dynamic SQL becames Empty String

Recently,I encountered a strange (for me) situation. Consider that you need to use some string parameter in Dynamic SQL query using EXEC(@St...

Read More

CRecordset::Open() - Invalid cursor state

When you call a stored procedure in C++ (MFC) through CRecordset and the stored procedure does NOT return any result set,you will get the fo...

Read More