不好意思UNION SELECT * FROM [viwIwfCommand] WHERE PkID = @id 改为 SELECT * FROM [viwIwfCommand] WHERE PkID = @id
解决方案 »
- 在用的是mssqlserver ,现在想每月最后一天自动去运行一个sql语句,请前辈指点一下方向。
- 触发器语法问题
- 怎么进行周统计呢
- 100分的问题, 渴望帮助.
- 雪地在线裸跪求教:为什么我用DTS把excel表格导入到数据库中,excel里明明只是一条记录,倒进数据库里却有6条一模一样的记录(解决立马给
- 这个语句为什么会timeout? 送分拉~~~
- sql与oracle
- 数据从数据库到XML文档的相互映射转换。可以实现吗?哪些公司做到了?哪些公司有中间件?
- 如何将vFp中的数据用vb工具导入到sql server
- 执行SQL语法出错,at line 1 MySQL Errno:0 Message:MySQL Query Error
- sql server中sql语句中的逗号如何转意
- 求一交叉表报表,高手请进,解决后立马给分!!!
CREATE PROCEDURE spciwfProQuickLoad
@PkID int
AS
DECLARE @id int
SELECT * FROM [viwIwfProcess] WHERE PkID = @PkID
SELECT * FROM [viwIwfPhase] WHERE ProcessID = @PkID
SELECT * FROM [viwIwfTransation] WHERE ProcessID = @PkIDDECLARE cur1 CURSOR FOR
SELECT PkID FROM [viwIwfPhase] WHERE ProcessID = @PkID
OPEN cur1
FETCH NEXT FROM cur1 INTO @id
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT * FROM [viwIwfCommand] WHERE PkID = @id
ENDCLOSE cur1
DEALLOCATE cur1
GO
后面再加上一句fetch next from cur1 into @id让指针进行移动!
FETCH NEXT FROM cur1 INTO @id
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT * FROM [viwIwfCommand] WHERE PkID = @id
FETCH NEXT FROM cur1 INTO @id
END