Tag Archives | T-SQL

SQL SERVER – Concat Strings in SQL Server using T-SQL

Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. Here are some samples:

Read full story Comments { 0 }

T-SQL features in SQL Server 2012 – CREATE SEQUENCE

T-SQL features in SQL Server 2012 – CREATE SEQUENCE

Read full story Comments { 0 }

Features of SQL Server 2012

Features of SQL Server 2012

Read full story Comments { 0 }

How to Backup SQL Database Using SQL Server Management Studio

How to Backup SQL Database Using SQL Server Management Studio

Read full story Comments { 0 }

Backup and Restore Your SQL Server Database from the Command Line

Backup and Restore Your SQL Server Database from the Command Line

Read full story Comments { 0 }

How to change the SQL sa password from a command prompt

How to change the SQL sa password from a command prompt

Read full story Comments { 0 }

Determing SQL Server Table Size within a Database

A common problem that I have recently encountered was trying to identity which table within a database was the biggest one (in record size), therefore, taking up the most physical storage space. I found and modify this store procedure to work with MSSQL 2000, MSSQL 2005, and MSSQL 2008  that will perform all needed data […]

Read full story Comments { 0 }

Subtract Days From Date Fields in Microsoft SQL

Subtract Days From Date Fields in Microsoft SQL

Read full story Comments { 0 }