本文介绍了你可以解决这些商店程序问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
将以下客户和销售信息添加到数据库的
。 (使用商店程序)
名字:Priyanka
姓氏:Chopra
城市:孟买
州:MH
邮编:400001
产品ID:3
SalePrice:205
SaleDate:12/31/2005
Add the following Customer and Sale information to
the database. (using store procedure)
FirstName: Priyanka
LastName: Chopra
City: Mumbai
State: MH
Zip: 400001
ProductID: 3
SalePrice: 205
SaleDate: 12/31/2005
推荐答案
CREATE PROCEDURE NameOftheStoredPRocedure
@FirstName VARCHAR(50),
@LastName VARCHAR(50)
AS
BEGIN
SET NOCOUNT ON
INSERT INTO TableName(FirstName,LastName ) VALUES (@FirstName,@LastName);
END
查看下面的教程以获取更多信息
[]
[]
[]
check below tutorials for more information
Sql Server - How to write a Stored procedure in Sql server[^]
Overview of SQL Server Stored Procedure[^]
SQL Server – How to write stored procedures with output parameters?[^]
这篇关于你可以解决这些商店程序问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!