我该如何创建呢。 [英] How do I create this.
问题描述
CREATE PROCEDURE AddNewUserProc
{
@NricNo VarChar(50)
@donorNric VarChar(50)
@donorName VarChar(50)
@donorAddress VarChar(250)
@donorPostalCode VarChar(50)
@donorContactNo VarChar(50)
@donorType int
@donorOrganizationName VarChar(250)
}
AS
如果没有出现(选择NricNo来自Donor NricNo = @NricNo)
BEGIN
INSERT INTO Donor (NricNo,姓名,地址,PostalCode,ContactNo,类型,组织名称)VALUES(@ NricNo,@ donorNric,@ donorName,@ donorAddress,@ donorPostalCode,@ donorContactNo,@ donorType,@ donorOrganizationName)
END
//错误一直说必须声明@NricNo两次,'{'。
试试这个:
创建 程序加NewUserProc
@ NricNo VarChar ( 50 ),
@ donorNric VarChar ( 50 ),
@ donorName VarChar ( 50 ),
@ donorAddress VarChar ( 250 ),
@ donorPostalCode VarChar (< span class =code-digit> 50 ),
@ donorContactNo VarChar ( 50 ),
@ donorType int ,
@ donorOrganizationNameVarChar ( 250 )
AS
IF NOT EXISTS ( SELECT NricNo FROM 捐助者 WHERE NricNo = @ NricNo )
BEGIN
INSERT INTO 捐赠者(NricNo,姓名,地址,邮政编码,ContactNo,类型 ,OrganizationName) VALUES ( @ NricNo , @ donorNric , @ donorName , @ donorAddress , @ donorPostalCode , @ d onorContactNo , @ donorType , @ donorOrganizationName )
END
不要使用{}
括号来创建程序,但是使用逗号分隔参数。
改为尝试:CREATE PROCEDURE AddNewUserProc
@ NricNo VarChar ( 50 ),
@ donorNric VarChar ( 50 ),
@ donorName VarChar ( 50 ),
@ donorAddress VarChar ( 250 ),
@ donorPostalCode VarChar ( 50 ),
@ donorContactNo VarChar ( 50 ),
@ donorType int ,
< span class =code-sdkkeyword> @ donorOrganizationName VarChar ( 250 )
AS
IF 不 EXISTS ( SELECT NricNo FROM Donor WHERE NricNo = @ NricNo )
BEGIN
INSERT INTO Donor(NricNo,Name,Address,PostalCode,ContactNo, Type ,OrganizationName) VALUES ( @ NricNo , @ donorNric , @ donorName , @ donorAddress , @ donorPostalCode , @ donorContactNo , @ donorType , @ donorOrganizationName )
END 跨度>
CREATE PROCEDURE AddNewUserProc
{
@NricNo VarChar(50)
@donorNric VarChar(50)
@donorName VarChar(50)
@donorAddress VarChar(250)
@donorPostalCode VarChar(50)
@donorContactNo VarChar(50)
@donorType int
@donorOrganizationName VarChar(250)
}
AS
IF NOT EXISTS (SELECT NricNo FROM Donor WHERE NricNo = @NricNo)
BEGIN
INSERT INTO Donor(NricNo, Name, Address, PostalCode, ContactNo, Type,OrganizationName) VALUES(@NricNo, @donorNric , @donorName , @donorAddress, @donorPostalCode, @donorContactNo, @donorType, @donorOrganizationName)
END
//Error keep saying must declare @NricNo twice, incorrect syntax near '{'.
Try this:
CREATE PROCEDURE AddNewUserProc @NricNo VarChar(50), @donorNric VarChar(50), @donorName VarChar(50), @donorAddress VarChar(250), @donorPostalCode VarChar(50), @donorContactNo VarChar(50), @donorType int, @donorOrganizationName VarChar(250) AS IF NOT EXISTS (SELECT NricNo FROM Donor WHERE NricNo = @NricNo) BEGIN INSERT INTO Donor(NricNo, Name, Address, PostalCode, ContactNo, Type,OrganizationName) VALUES(@NricNo, @donorNric , @donorName , @donorAddress, @donorPostalCode, @donorContactNo, @donorType, @donorOrganizationName) END
Don't use{ }
brackets to create your procedure, but use commas to seperate the arguments.
Try this instead:CREATE PROCEDURE AddNewUserProc @NricNo VarChar(50), @donorNric VarChar(50), @donorName VarChar(50), @donorAddress VarChar(250), @donorPostalCode VarChar(50), @donorContactNo VarChar(50), @donorType int, @donorOrganizationName VarChar(250) AS IF NOT EXISTS (SELECT NricNo FROM Donor WHERE NricNo = @NricNo) BEGIN INSERT INTO Donor(NricNo, Name, Address, PostalCode, ContactNo, Type,OrganizationName) VALUES(@NricNo, @donorNric , @donorName , @donorAddress, @donorPostalCode, @donorContactNo, @donorType, @donorOrganizationName) END
这篇关于我该如何创建呢。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!