Browsing Category
T-SQL
Best tip to compare and deploy SQL Server schemas
https://www.youtube.com/watch?v=jfvpr3fSTgI
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…
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 within SQL Server. In this short article, I will list out some…
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 two integer values to…
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.