SQL

Many times you may need to show numeric data with a fixed length. If you cast an int to a string datatype you often get a bunch of trailing...

The below Split function is Table-valued function which would help us splitting comma-separated (or any other delimiter value) string to in...

You must have seen below error while renaming or deleting database.  The database could not be exclusively locked to perform the operatio...

Sometime time you may need to restart SQL server from command prompt. Below command is used to stop and start SQL Server:  Net Stop mss...

I have been facing an issue while importing some data from SQL to CSV file. In one of my SQL fields user entered Enter Key or Line feed, be...