Assume you have a table containing alphabetic, numeric, alphanumeric strings, and special characters, and you need to retrieve only the alphanumeric strings from that data.… Read More »How to fetch alphanumeric string from table
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
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
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
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
How to create a custom shortcuts for stored procedures in SQL Server ?
