SQL Server – NEWID () vs. NEWSEQUENTIALID ()

NEWID () NEWID () creates a unique value of type uniqueidentifier. NEWID () can be referenced in the queries. Example: NEWSEQUENTIALID () NEWSEQUENTIALID () creates a GUID that is greater than any GUID previously generated by this function on a specified computer since Windows was started. After restarting Windows, the

» Read more

SQL Server – Import Export Wizard – Enable Identity Insert

I had requirement to move the data from source table with his identity column to destination table that have also identity column. Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. Identity column does not allow any

» Read more

dbForge SQL Complete – SQL Server Management Studio – Visual Studio

SQL Complete is a tool available freely (and advanced professional version) which acts as a plugin to SQL Server Management Studio and Visual Studio, and provides powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. That increases development productivity to quite an extent. For more detail

» Read more
1 9 10 11 12 13 31