Author: SQL Server Pro

Difference between INSERT INTO and SELECT INTO

Difference between INSERT INTO and SELECT INTO

INSERT INTO and SELECT INTO are different because they do different things. Three main differences are: INSERT INTO is used when the table exists. SELECT INTO works when table does not exists. In other...

Setting default value for an existing column

Setting default value for an existing column

This can be done using ALERT TABLE command. Here is the easiest way to do it.

 

Difference between varchar and nvarchar data types?

Difference between varchar and nvarchar data types?

There is a major difference between these two data types. An nvarchar column can store any Unicode data but a varchar column is restricted to an 8-bit codepage. Some people think that varchar should...

dbForge – SQL Server Schema Comparison and Sync Tool

dbForge – SQL Server Schema Comparison and Sync Tool

dbForge Schema Compare for SQL Server is a reliable tool that saves your time and effort when comparing and synchronizing databases on SQL Server. The tool allows working with live SQL Server databases, snapshots,...

Free SQL Comparison Tool

Free SQL Comparison Tool

There are variety of commercial SQL comparison tools available. However, most of them are expensive and many times you don’t need all the professional functions they have. So, why not try a free SQL...