STUFF Function in SQL Server
STUFF function is used to replace a string with another string within a text. This function can be very helpful in some situation. Here you can see the syntax of this function along with...
Category: T-SQL
How to check if a table exists in SQL Server database
There are several methods to check if a table exists in SQL Server database. Using INFORMATION_SCHEMA.TABLES Query like below can be used to check if a Table exists in the selected mssql database.
|
1 2 3 4 |
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'YouTableName') BEGIN PRINT 'Table Exists' END |
...
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
This can be done using ALERT TABLE command. Here is the easiest way to do it.
|
1 2 |
ALTER TABLE my-table ADD DEFAULT('my-default-value') FOR my-column |
Disposing of “commotion” from database organization contents utilizing SQL Compare venture choices
A database examination instrument like SQL Compare expels a considerable measure of the agony behind the errand of contrasting SQL Server database mappings, producing a synchronization content, and after that conveying the progressions from...
Best tip to compare and deploy SQL Server schemas
Look at SQL Server mapping changes from dev, to test, to generation Look at SQL Server database mappings, huge and little, with cutting edge separating of database objects. You can investigate what’s changed...