Bala Singam

Disclaimer : This tutorial is meant for beginners and for anyone who find it useful. The main purpose of this post to keep everything i find useful for future reference for myself and for others.

Yesterday I been requested by one of our client to write a database back up script so that they can schedule it as SQL Server job. As usual i google it and found plenty of solutions but I was looking for something simple and workable. Found it here

This is one line T-SQL code to back up any given database however I added 2 extra line code to have the date on the back up file name.

declare @filename as varchar(100)
SET @fileName = 'd:\' + 'Skanda' + '_' + CONVERT(VARCHAR(20),GETDATE(),112)</code> + '.BAK'
BACKUP DATABASE Skanda TO DISK = @fileName

The a backup file with following format will created Skanda_20100214.BAK

Disclaimer : This tutorial is meant for beginners and for anyone who find it useful. The main purpose of this post to keep everything i find useful for future reference for myself and for others.

Converting between data types in .Net made easy by System.Convert class , for example to convert double to int all you need is these codes

double d=3.27;
int i=System.Convert.ToInt32(d);

The System.Convert class has the following methods:

* ToBoolean
* ToByte
* ToChar
* ToDateTime
* ToDecimal
* ToDouble
* ToInt16
* ToInt32
* ToInt64
* ToSingle
* ToString
* and some more….

A nice video – from developer to developer