Database

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.

<br />
Create procedure sp_Fetchrecords<br />
@tbname sysname=NULL<br />
AS<br />
Select * from @tbname<br />
go<br />

Create procedure sp_Fetchrecords
@tbname sysname=NULL
AS
SET NOCOUNT ON
IF @tbname IS NOT NULL 
BEGIN
	DECLARE @cmd NVARCHAR(4000)
	SET @cmd = 'Select * from '+@tbname
	EXEC(@cmd)
END
go

amistry_petlad wrote:

explain me why we have to execute the set command in procedure

CREATE TABLE #T (x DECIMAL(8,3)); 
INSERT INTO #T (x) SELECT 3.400; 
INSERT INTO #T (x) SELECT 45.670; 

SELECT x, CAST(x as float), CONVERT(float, x) FROM #T; 

DROP TABLE #T;