Assume that you have a table which contains alphabetic, numeric, alphanumeric string, and special characters and you are asked to fetch only alphanumeric string from… Read More »How to fetch alphanumeric string from table
20,684 total views, 5 views today
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
4,980 total views
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
2,831 total views
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
7,133 total views, 4 views today
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,795 total views
Get the information about Datatype in SQL Server
1,828 total views, 1 views today
How to create a custom shortcuts for stored procedures in SQL Server ?
1,190 total views