Author: SQL Server Pro

Check if a column exists in table

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 a column in table...

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!

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 category. Bitwise operators convert...

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.

How to downgrade SQL Server 2017 database to SQL Server 2005/2008/2012/2014/2016

It’s not possible to downgrade a database on SQL Server. However, there are several workarounds which you can use to migrate or downgrade SQL Server 2017 database to lower version of SQL Server database. One of the most popular (and easiest) method for doing this is ‘Script entire database and all database object’.

SQL Server 2017 Editions

SQL Server 2017 (Code Name Helsinki), which is yet to be released officially, will come with many new Database Engine features, enhancements, and performance improvements. These includes Resumable online index rebuild, IDENTITY_CACHE option, adaptive...