MSSQL – split value in single column into multiple rows
Problem i have a supplier table that stores supplier email, and the column can store 1 or more email address separated by carriage return character. …
Tag: database
MSSQL – Restore a database backup to new database (new name) from TSQL
1. make sure you have exclusive access to the database, means the database is not being used or there are pending transaction USE master GO …