Command to take backup of a single table in SQL Server

select * into NewTableName from SourceTable

How to give Read Only Permission to a user to SQL Jobs

use msdb

EXECUTE sp_addrolemember

@rolename = 'SQLAgentReaderRole',

@membername = 'Domain\UserName’

Difference between Varchar and Nvarchar in Sql Server

Nvarchar Supports all Unicode character’s where as Varchar Doesn’t.

Sql Server Stored Procedures Samples

Stored Procedures Samples
Procedure for delete	Create PROCEDURE sp_deluserdet(@uname nvarchar(50),@pwd nvarchar(50)) AS begin delete users where username=@uname and password=@pwd end
Procedure for Select	create PROCEDURE sp_finduserdet(@uname nvarchar(50),@pwd nvarchar(50) output) AS begin select @pwd=pwd from users where username=@uname end
Procedure for Update	creatte PROCEDURE sp_upduserdet(@uname nvarchar(50),@pwd nvarchar(50)) AS begin update users set password=@pwd where username=@uname end
Procedure for Insert	create PROCEDURE sp_insuserdet(@uname nvarchar(50),@pwd nvarchar(50)) AS begin insert into users values(@uname,@pwd) end