Database

Select Cast(Cast(GetDate() as int) as datetime) As Today
	,Cast(Cast(DateAdd(dd, -7, 
		DateAdd(dd, - DatePart(dw, Getdate()) + 1,
		GetDate())) as int) as datetime) As LastWeekStart
	,Cast(Cast(DateAdd(dd, -1,
		DateAdd(dd, - DatePart(dw, Getdate()) + 1, 
		GetDate())) as int) as datetime) As LastWeekEnd

select
Convert(varchar,DateAdd(dd, -(Datepart(dw, <code>Getdate()</code>) +6), <code>GETDATE()</code>), 101) 
    As PreviousWeekStart
,Convert(varchar,DateAdd(dd, -Datepart(dw, <code>Getdate()</code>), <code>GETDATE()</code>),101) 
    As PreviousWeekEnd

Select Question
,Sum(Case When Response = 'Excellent' Then 1 Else 0 End) as Excellent
,Sum(Case When Response = 'Good' Then 1 else 0 End) as Good
,Sum(Case When Response = 'Average' Then 1 Else 0 End) as Average
,Sum(Case When Response = 'Poor' Then 1 Else 0 End) as Poor
From
(Select Code, Q1, Q2, Q3
From <code>#t</code>) p 
	Unpivot
	(Response For Question In
		(Q1, Q2, Q3)) as unpvt
Group By Question

DELETE FROM TABLE_1 WHERE ID IN (SELECT ID FROM TABLE_2)

DELETE FROM Table_1
FROM         Table_2 AS t2 INNER JOIN
                      Table_1 as t1 ON t1.ID = t2.ID

Create Proc usp_DeleteFromTables
@Id int
As

Delete From Table1
Where Id = @Id

Delete From Table2
Where Id = @Id

Exec usp_DeleteFromTables 2

IF @@ERROR <> 0 
  PRINT 'Insert into MyTable failed'

Raiserror('Message', 16, 1)

DECLARE @cmd NVARCHAR(100);
SET @cmd = N'C:\BackUp_MyDatabase_'+REPLACE( CONVERT(NVARCHAR,GETDATE(), 121) ,':','.')  +'.bak'
BACKUP DATABASE [MyDatabase] TO DISK =  @cmd
GO

CREATE PROCEDURE spx_Student_Delete (@rollno INT)
AS 
delete from student where rollno=@rollno;
GO

EXECUTE spx_Student_Delete 12