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.

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.

 2,480 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.

 3,802 total views,  7 views today