存储过程调用自定义函数

--存储过程
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