T-SQL
Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns.
It was interesting that value of the column was variable and something dynamic needed to be written. Following is quick script which separates one [...]
Continue reading about T-SQL Script to Divide One Column Data into Two Columns
We are in thought of only DBA’s can take backup using T-SQL, But anyone can take backup and restore backup very easily with the help of T-SQL. we can backup an entire database, transaction log, or one or more file or filegroups with the help of T-SQL.
Continue reading about Backup SQL Server database using T-SQL
