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
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
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
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 Template Explorer
1,595 total views
Get the information about Datatype in SQL Server
1,757 total views
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.
28,542 total views, 4 views today
Following are the links to download SQL Server 2019 and Database sample files
1,404 total views
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
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.
6,213 total views, 1 views today
How to create a custom shortcuts for stored procedures in SQL Server ?
1,129 total views
we can enable line numbers to be displayed in Sql Server Query Editor Window.
1,772 total views
SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.
6,412 total views