--存储过程
use WX
go
-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE AddUser
-- Add the parameters for the stored procedure here
( @loginName nchar(20),
@passWord nchar(128),
@empId int=null )
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
declare @id int
select @id = dbo.GetNewID()
-- Insert statements for procedure here
insert table_user (id, loginName, password, empid) values (@id, @loginName, @password, @empId)
END
GO
--自定义函数
use WX
go
-- ================================================
-- Template generated from Template Explorer using:
-- Create Scalar Function (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
CREATE FUNCTION GetNewID
(
-- Add the parameters for the function here
)
RETURNS int
AS
BEGIN
declare @newId int;
select @newId = MAX(id)+1 from dbo.Table_User
return @newId
END
GO
存储过程调用自定义函数
最新推荐文章于 2022-03-18 22:37:29 发布