Question

用SQL怎样编写一个存储过程？

Answer 1

CREATE PROCEDURE [dbo].[usp_InsertTool]
@T_Name nvarchar(50),
@T_OldPrice money,
@T_TypeID smallint,
@T_CreateTime smalldatetime,
@T_IsValid bit,
@T_Description nvarchar(500),
@T_SoldCount bigint,
@T_ID int OUTPUT
AS
--SET NOCOUNT ON
INSERT INTO [dbo].[NA.Tool] (
[T_Name],
[T_OldPrice],
[T_TypeID],
[T_CreateTime],
[T_IsValid],
[T_Description],
[T_SoldCount]
) VALUES (
@T_Name,
@T_OldPrice,
@T_TypeID,
@T_CreateTime,
@T_IsValid,
@T_Description,
@T_SoldCount
)
--SET @T_ID = SCOPE_IDENTITY()
SELECT SCOPE_IDENTITY()

这就是一个插入数据并返回记录ID的存储过程，各种类型的参数都给你用到了

Answer 2

create proc 要定义的视图名 as select 参数 from 视图名