python执行sqlserver存储过程_SQLSERVER存储过程例子 | 工作 实践 真知 分享 IT python资源,python面试,python教程，python自学，python技术，...

CREATE PROCEDURE PR_INSERT_TWO

@biaoti nvarchar(255) ,

@zuozhe nvarchar(50) ,

@suoluetu nvarchar(255) ,

@biaoqian nvarchar(255) ,

@urlid nvarchar(255) ,

@guanjianci nvarchar(255) ,

@miaoshu nvarchar(555) ,

@jianjie ntext ,

@neirong ntext

AS

BEGIN

declare @a int

declare @nowid int

set @a=0

select @a = count(*) from dbo.sd_model_news where url=@urlid

if(@a != 0)

begin

print '已有记录'

end

else

begin

print '新id，做入表操作';

insert into dbo.sd_content(title,author,pic,tags,url,keyword,description,intro)

values(@biaoti,@zuozhe,@suoluetu,@biaoqian,@urlid,@guanjianci,@miaoshu,@jianjie);

print '新id，做入表sd_content操作';

select @nowid = max(id) from dbo.sd_content where url=@urlid;

print '新id，做查表sd_content操作';

insert into dbo.sd_model_news(cid,url,content) values(@nowid,@urlid,@neirong);

print '新id，做入表sd_model_news操作';

end

END

执行方法

EXEC PR_INSERT_TWO 'biaoti','zuozhe','suoluetu','biaoqian','urlid','guanjianci','miaoshu','jianjie','neirong'