SQL Server trips and tricks concepts, that helps us to work with SQL Server in a easiest way.
How to get dark theme for SQL Server Management studio?
By default it is hidden in SQL Server management studio, you can quickly check by following below steps.
Following are the links to download SQL Server 2019 and Database sample files
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.
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.
In SQL Server we can create a database, table and write T-SQL query using emoji.
Here we will create a table and then insert few records into table.
How to create a custom shortcuts for stored procedures in SQL Server ?
we can enable line numbers to be displayed in Sql Server Query Editor Window.
SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.
