14 thg 7, 2017
một số SP của hè 2017
USE [TN_DB]
GO
/****** Object: StoredProcedure [dbo].[spBaiThiTam_Update] Script Date: 07/14/2017 15:35:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--==============================================
-- Author: AutoNetCoder @ 2014
-- Create date: 05/12/2014 9:23:41 CH
-- Project: TN_DB
-- Description: Auto code by AutoNetCoder
-- Website: http://.www.softviet.net
--==============================================
ALTER PROCEDURE [dbo].[spBaiThiTam_Update]
@MaSV char(10),
@MaMon varchar(50),
@PaTL varchar(50)
As
BEGIN
Update [BaithiTam] Set
[PaTL] = @PaTL
Where (@MaSV = MaSV) AND (MaMon = @MaMon)
END
/*
exec spBaiThiTam_Update
@PaTL = '-1,-2,-3,-4,-5',
@MaMon = 'KTS_CNTT ',
@MaSV ='711001'
*/
**************
USE [TN_DB]
GO
/****** Object: StoredProcedure [dbo].[spGetMultichoiseById] Script Date: 07/14/2017 15:31:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetMultichoiseById]
@Id int
--@check int output
AS
BEGIN
Select Stt_Mon, CauHoi, PA1, PA2,PA3,PA4
from MultiChoise
where (Stt_Mon = @Id) AND MaMon ='Anh_ESPA8Computing '
END
/*
exec spGetMultichoiseById
@Id= 4
*/
**********************
USE [TN_DB]
GO
/****** Object: StoredProcedure [dbo].[spUpdateEmployee] Script Date: 07/14/2017 15:33:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--==============================================
-- Author: AutoNetCoder @ 2014
-- Create date: 05/12/2014 9:23:41 CH
-- Project: TN_DB
-- Description: Auto code by AutoNetCoder
-- Website: http://.www.softviet.net
--==============================================
ALTER PROCEDURE [dbo].[spUpdateEmployee]
@Id int,
@Name nvarchar(50),
@Gender char(10),
@Salary int
AS
BEGIN
Update tblEmployee Set
Name = @Name,
Gender = @Gender,
Salary = @Salary
Where (Id = @Id)
END
/*
exec spUpdateEmployee
@Id= '4'
@Name ='duyan',
@Gender 'man',
@Salary '10'
*/
*********************88
USE [TN_DB]
GO
/****** Object: StoredProcedure [dbo].[spInsertEmployee] Script Date: 07/14/2017 15:34:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertEmployee]
@Name nvarchar(50),
@Gender nvarchar(10),
@Salary int
--@check int output
AS
BEGIN
insert into tblEmployee
values (@Name,@Gender,@Salary)
END
/*
exec spInsertEmployee
@Name ='sds',
@Gender ='dsfdf',
@Salary ='5622'
*/
*******************************
USE [TN_DB]
GO
/****** Object: StoredProcedure [dbo].[spGetEmployeeById] Script Date: 07/14/2017 15:34:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetEmployeeById]
@Id int
--@check int output
AS
BEGIN
Select Id, Name, Gender, Salary
from tblEmployee
where Id = @Id
END
/*
exec spGetEmployeeById
@Id= 4
*/
***********************
USE [TN_DB]
GO
/****** Object: Table [dbo].[tblEmployee] Script Date: 07/14/2017 15:38:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblEmployee](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[Gender] [nvarchar](50) NULL,
[Salary] [int] NULL
) ON [PRIMARY]
GO
*********************************