SSMS keyboard shortcuts
As a SQL Server developer you must know some keyboard shortcuts while working on SQL Server Management Studio, although it is not necessary to know… Read More »SSMS keyboard shortcuts
1,270 total views, 3 views today
Home » SQL SERVER »
SQL Tricks & Tips
SQL Server trips and tricks concepts, that helps us to work with SQL Server in a easiest way.
PARSENAME Function
PARSENAME function is a SQL Server Metadata function which returns the specified part of an object name. The parts of an object that can be… Read More »PARSENAME Function
1,373 total views
How to get Ordinal Number in SQL
If any number that is written like as 1st, 2nd, 3rd and so on.. is called an ordinal number, and it is read as 1st(… Read More »How to get Ordinal Number in SQL
2,859 total views, 2 views today
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
16,716 total views, 18 views today
Print Christmas tree in SQL Server
Lets see how to print a Xmas or Christmas Tree in SQL Server. The best way of implementing a Xmas tree pattern you can use a… Read More »Print Christmas tree in SQL Server
989 total views
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
2,336 total views, 1 views today
SQL Code Snippets
SQL code snippet is a template which contains the basic structure of a Transact-SQL statement or block, so that you can quickly write queries without… Read More »SQL Code Snippets
2,729 total views
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
1,458 total views, 2 views today
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
1,841 total views, 1 views today
Get the information about Datatype in SQL Server
Get the information about Datatype in SQL Server
951 total views, 1 views today
Enable Dark theme in SQL Server Management studio
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.
15,839 total views, 10 views today
SQL Server Download links
Following are the links to download SQL Server 2019 and Database sample files
622 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.
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
Displaying Emoji in SQL Server
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.
2,643 total views, 7 views today
How to create a custom shortcuts in SQL Server
How to create a custom shortcuts for stored procedures in SQL Server ?
486 total views
Displaying line numbers in Query Editor Window
we can enable line numbers to be displayed in Sql Server Query Editor Window.
658 total views
SQL sp_help
SQL Sp_help is part of database engine stored procedures ,which returns information about a database object or a data type.
2,705 total views, 5 views today