一种办法从go的地方分开,去掉go,分成多次执行。
解决方案 »
- SQL查询【简单】
- 求高手帮我看下这个sql2005的报表服务配置问题啊.
- 把小数点去掉,后面确认为2位,不够2位的补0,若没有小数点即为整数,后面补2个0
- 如何查询Decimal为自定义格式
- 存储过程参数赋值时 逗号的问题怎么解决
- 存储过程及触发器+错误
- 请各位大哥指点(数据库)
- 这条语名那里有问题
- 请问那里有SQL SERVER 2000 下栽,给你500分!
- InterBase用ADO怎么连, ADO驱动程序吗?
- sql server 7/2000中最大连接数(同时可以有多少用户登陆)怎样修改??
- 从c:\XXX.mdb文件中导两个表的数据到Sql server的两个表中,sql脚本怎么写?
/*[Microsoft][ODBC SQL Server Driver][SQL Server]'CREATE TRIGGER' must be the first statement in a query batch.*/
use att2000
if Exists(select name from sysobjects where name='UpdateEmp' and type='TR')
Drop Trigger UpdateEmp
goif Exists(select name from sysobjects where name='insertEmp' and type='TR')
Drop Trigger insertEmp
goif Exists(select name from sysobjects where name='DeleteEmp' and type='TR')
Drop Trigger DeleteEmp
goCREATE TRIGGER UpdateEmp ON [dbo].[USERINFO]
FOR UPDATE
AS
BEGIN
DECLARE @name nvarchar (20)
DECLARE @deptid smallint
DECLARE @userid smallint
DECLARE @hiredday smalldatetime
select @userid=userid,@name=name,@deptid=defaultdeptid,@hiredday=hiredday from inserted
IF (select count(*) from cat_userinfo where attuserid=@userid)>0
update cat_userinfo set name=@name,deptid=@deptid,hiredday=@hiredday where attuserid=@userid
ELSE
INSERT INTO cat_userinfo(attuserid,name,deptid,manager,hiredday,isquit,createDateTime) select userid,name,defaultdeptid,0,hiredday,0,getdate() from inserted
END
GOCREATE TRIGGER insertEmp ON [dbo].[USERINFO]
FOR INSERT
AS
BEGIN
INSERT INTO cat_userinfo(attuserid,name,deptid,manager,hiredday,isquit,createDateTime) select userid,name,defaultdeptid,0,hiredday,0,getdate() from inserted
END
GOCREATE TRIGGER DeleteEmp ON [dbo].[USERINFO]
FOR DELETE
AS
BEGIN
DECLARE @name nvarchar (20)
DECLARE @deptid smallint
DECLARE @userid smallint
DECLARE @hiredday smalldatetime
select @userid=userid,@name=name,@deptid=defaultdeptid,@hiredday=hiredday from deleted
update cat_userinfo set name=@name,deptid=@deptid,hiredday=@hiredday,isquit=1,resignday=getdate() where attuserid=@userid
delete user_access_group where user_id =@userid
END
GO
其中 OSQL:命令词
-U后面紧接着USERID
-P后面紧接着password
-d后面紧接着dbname
-i后面紧接着 要执行的脚本的路径\名称
注意:参数的大小写
参数与参数值之间不要有空格
不同的参数以空格隔开