STUFF command in SQL Server

This command is used to replace a string with another string within a text. This command can sometimes be a savior. You can see the shape of this command along…

Read more »

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…

Read more »

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…

Read more »

Setting default value for an existing column

This can be done using ALERT TABLE command. Here is the easiest way to do it. ALTER TABLE my-table ADD DEFAULT(‘my-default-value’) FOR my-column  

Read more »

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…

Read more »

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…

Read more »

Check if a column exists in table

Some times we come across a scenario where we need to know if a specific columns exists in table or not. There are variety of ways to find existence of…

Read more »
STRING_AGG

STRING_AGG – A New function in SQL Server 2017

STRING_AGG is an interesting aggregated function. It concatenates the values of string expressions and places separator values between them. And what more? The separator is not added at the end of string. Yeah!

Read more »

Bitwise Operators in SQL Server

Bitwise operators in SQL Server are very much like logical operators but they perform bit manipulations between two expressions of any of the data types of the integer data type…

Read more »
New String functions in SQL Server 2017

New String functions in SQL Server 2017

Microsoft added some new T-SQL functions in SQL Server 2017. These new functions can make your work easy and increase readability of your T-SQL Code. I will be discussing 3 newly added String functions in SQL Server 2017.

Read more »