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
*********************************

một số SP của hè 2017 Rating: 4.5 Diposkan Oleh: http://pdunoteit.blogspot.com/