触发器内容:
use #booksSET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- 删除原有触发器
if exists(select name from sysobjects where name='User_Da_tri')
drop trigger User_Da_tri
GOCREATE TRIGGER User_Da_tri
ON [dbo].[Users_HB]
INSTEAD OF DELETE
AS
declare @KH nchar(10)
BEGIN
SET NOCOUNT ON;
if exists(select @KH=US_KaHao from deleted where US_Money>0)
return '账户中有余款,不能删户!'
-- Insert statements for trigger hereEND
GO错误提示:
消息 102,级别 15,状态 1,过程 User_Da_tri,第 11 行
'=' 附近有语法错误。
消息 178,级别 15,状态 1,过程 User_Da_tri,第 12 行
在此上下文中不能使用带有返回值的 RETURN 语句。
use #booksSET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- 删除原有触发器
if exists(select name from sysobjects where name='User_Da_tri')
drop trigger User_Da_tri
GOCREATE TRIGGER User_Da_tri
ON [dbo].[Users_HB]
INSTEAD OF DELETE
AS
declare @KH nchar(10)
BEGIN
SET NOCOUNT ON;
if exists(select @KH=US_KaHao from deleted where US_Money>0)
return '账户中有余款,不能删户!'
-- Insert statements for trigger hereEND
GO错误提示:
消息 102,级别 15,状态 1,过程 User_Da_tri,第 11 行
'=' 附近有语法错误。
消息 178,级别 15,状态 1,过程 User_Da_tri,第 12 行
在此上下文中不能使用带有返回值的 RETURN 语句。
解决方案 »
- 一个关于列的默认值的问题
- 请问unix环境下怎样访问sqlserver数据库?谢谢
- 求助:如何通过GET方式向Reporting Service中的报表传递参数
- 本地机器可以用IP连接远程数据库,web服务器却连接不上远程数据库
- 不同IP服务器上触发器同步删除数据问题
- sql2000中update OPENDATASOURCE问题,为什么在sql2000中不能用
- 彻底清除日志?(在线等待,5小时内结贴)
- 100分 求SQL精度转化语句 在线等
- 怎么在存贮过程中返回某个记录在记录集中的位置
- *****Transact-SQL 编程之谜系列*****
- 一个关于OpenDataSource的问题
- 统计P表中红色零件数,并把color命名为红色零件数
GO
SET QUOTED_IDENTIFIER ON
GO
-- 删除原有触发器
if exists(select name from sysobjects where name='User_Da_tri')
drop trigger User_Da_tri
GO CREATE TRIGGER User_Da_tri
ON [dbo].[Users_HB]
INSTEAD OF DELETE
AS
declare @KH nchar(10)
BEGIN SET NOCOUNT ON;
if exists(select US_KaHao from deleted where US_Money>0)
return '账户中有余款,不能删户!'
-- Insert statements for trigger here END
GO
SET QUOTED_IDENTIFIER ON
GO
-- 删除原有触发器
if exists(select name from sysobjects where name='User_Da_tri')
drop trigger User_Da_tri
GO CREATE TRIGGER User_Da_tri
ON [dbo].[Users_HB]
INSTEAD OF DELETE
AS
declare @KH nchar(10)
BEGIN SET NOCOUNT ON;
if exists(select US_KaHao from deleted where US_Money>0)
select '账户中有余款,不能删户!'
-- Insert statements for trigger here END
if exists(select @KH=US_KaHao from deleted where US_Money>0)
PRINT '账户中有余款,不能删户!'
-- Insert statements for trigger here
if exists(select @KH=US_KaHao from deleted where US_Money>0)
print '账户中有余款,不能删户!'
-- Insert statements for trigger here END
GO
GO
SET QUOTED_IDENTIFIER ON
GO
-- 删除原有触发器
if exists(select name from sysobjects where name='User_Da_tri')
drop trigger User_Da_tri
GO CREATE TRIGGER User_Da_tri
ON [dbo].[Users_HB]
INSTEAD OF DELETE
AS
declare @KH nchar(10)
BEGIN
SET NOCOUNT ON;
if exists(select 1 from deleted where US_Money>0 and US_KaHao=@KH)
select '账户中有余款,不能删户!'
-- Insert statements for trigger here END
这句有问题
if exists(select US_KaHao from deleted where US_Money>0)
begin
print '账户中有余款,不能删户!'
rollback tran
end
ON [dbo].[Users_HB]
INSTEAD OF DELETE
AS
BEGIN
if exists(select US_KaHao from deleted where US_Money>0)
return '账户中有余款,不能删户!'
else
delete [Users_HB] from [Users_HB] a,deleted b
where a.id=b.id
END
GO