Category Archives: SQL Server

SQL server Multiple rows to one comma separated value

This is the select statement in Sql server which will select the multiple rows of a column into a single column and single row as a comma separated values. SELECT  ID ,STUFF((SELECT ‘, ‘ + CAST(Name AS VARCHAR(10)) [text()] FROM … Continue reading

Posted in SQL Server | Leave a comment

Sql Sever Split String function with special character support

The following the is the SQL server table valued function which will return the result as table. The input to the function is string delimited with the comma (for that matter any character which is is not part of the … Continue reading

Posted in SQL Server | Leave a comment

Reset SQL Server password

To reset the password, we need to set SQL server mode as Single use mode. To do that open a command prompt as an administrator Type the following commands without the quotes (“ “) “net stop mssqlserver” and press enter. … Continue reading

Posted in SQL Server | Leave a comment