hessam2003
جمعه 27 بهمن 1391, 13:11 عصر
چگونه من این Procedure را در #C استفاده کنم؟
http://www.uploadbaz.com/w69rgz1pjo3mshow pic (http://www.uploadbaz.com/w69rgz1pjo3m)
Create procedure phone_insert
@id_srl bigint, ----------------->Auto number and PK.
@id bigint,
@name nvarchar(20),
@err nvarchar(50) output
AS
if exists (select id_srl from Phone
where id_srl=@id_srl)
begin
set @err="کد کاربری قبلا ثبت شده است"
return
end
insert into phone value(@id,@name)
http://www.uploadbaz.com/w69rgz1pjo3mshow pic (http://www.uploadbaz.com/w69rgz1pjo3m)
Create procedure phone_insert
@id_srl bigint, ----------------->Auto number and PK.
@id bigint,
@name nvarchar(20),
@err nvarchar(50) output
AS
if exists (select id_srl from Phone
where id_srl=@id_srl)
begin
set @err="کد کاربری قبلا ثبت شده است"
return
end
insert into phone value(@id,@name)