1.
create procedure dbo.dt_dropuserobjectbyid @id int
as
set nocount on
delete from dbo.dtproperties where objectid=@id
or
update......
or
insert......
go
不返回删除或更改或插入行数信息:2.
create procedure dbo.dt_dropuserobjectbyid @id int
as
set nocount on
delete from dbo.dtproperties where objectid=@id
or
delete...
or
update...
or
insert...
or
select...
or
select...
set nocount off
select * from yourtable
go
set nocount off是返回数据行数.
此处是返回最后一个select语句的数据行数.
create procedure dbo.dt_dropuserobjectbyid @id int
as
set nocount on
delete from dbo.dtproperties where objectid=@id
or
update......
or
insert......
go
不返回删除或更改或插入行数信息:2.
create procedure dbo.dt_dropuserobjectbyid @id int
as
set nocount on
delete from dbo.dtproperties where objectid=@id
or
delete...
or
update...
or
insert...
or
select...
or
select...
set nocount off
select * from yourtable
go
set nocount off是返回数据行数.
此处是返回最后一个select语句的数据行数.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货