Skip to content
Home » SQL SERVER » SQL Tricks & Tips

SQL Tricks & Tips

SQL Server trips and tricks concepts, that helps us to work with SQL Server in a easiest way.

Check if column Exists or not in SQL Server Table

There are various in-built system catalog views, or metadata functions that you can use to check the existence of column in SQL Server tables. To… Read More »Check if column Exists or not in SQL Server Table

 46,321 total views,  4 views today

Change the color of Automatic Matching of Syntax Pairs in SQL Server Management Studio

Automatic matching of syntax pairs is a feature of SQL Server Management Studio which gives you immediate feedback on whether syntax elements that must be… Read More »Change the color of Automatic Matching of Syntax Pairs in SQL Server Management Studio

 6,587 total views,  1 views today

SQL Server Saving Changes is not permitted error

You might have faced an error as shown below, when you make some changes in table from design mode in SQL server management studio (SSMS).… Read More »SQL Server Saving Changes is not permitted error

 3,712 total views

Change the column name and data type of result set of stored procedure

SQL Server 2012 has released a new feature WITH RESULT SETS, which allows column names and their data types to be changed in the result set… Read More »Change the column name and data type of result set of stored procedure

 4,516 total views

SQL Server Verbose Truncation Warnings

SQL Server Verbose Truncation Warnings 

Sometimes we receives data truncation error in SQL Server such as “String or binary data would be truncated” and it does not specify exact source of error in terms of  Database name, table  name , column name and truncated values.

 4,563 total views

How to display currency symbol in SQL Sever

How to Display currency symbol in SQL Sever?

Sometimes we are required to display a currency symbol along with the amount in query result set, It becomes challenge to displaying a currency symbol with amount.

 8,317 total views