Database

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

nelsonpaixao wrote:

The login to the application is wrote not in C# but SQL store procedures. I press a buttom that triggers a SP that manages the login. my connection strings have both no password and user.