declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for update 字段1,字段2,字段3....把要更新的字段跟在后面,如上.
解决方案 »
- SELECT SUM(IF (DATEDIFF(n, server_date,server_finish_date) > 240 THEN ww = 240 ELSE ww = (DATEDIFF(n, server_date,server_finish_
- 推理6,第一个答对的分全送。
- sql急急!!!!!!!!!!!!
- mysql 插入中文进去后,去出来时什么都看不到
- 怎样打开.db文件?
- ,,,,,提问
- 如何在新插入记录中把一个自动字段的内容加到另一字段中!
- 定义表的字段时,用VARCHAR 是不是比用char 在执行SQL语句时慢?除了长度可变外还有什么优缺点吗
- SQL 7过渡到 SQL 2000引起的阻塞问题
- Real类型 在SQL2K SQL2008显示不一样?何解?求科普
- 初学:在 查询分析器 中保存 .sql 的时候有3种格式:Unicode、ANSI、OEM 有什么区别?怎么用?
- 个人历史成绩统计问题
declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 order by hetongbianhao,bianhao for update of changjiafeiyong
-- Declare and using an UPDATE cursor
-- =============================================
DECLARE <@variable_1, sysname, @v1> <datatype_for_variable_1, sysname, varchar(20)>,
<@variable_2, sysname, @v2> <datatype_for_variable_2, sysname, varchar(40)>DECLARE <cursor_name, sysname, test_cursor> CURSOR
FOR SELECT <column_1, sysname, au_fname>, <column_2, sysname, au_lname> FROM <table_name, sysname, pubs.dbo.authors>
FOR UPDATE of <column_1, sysname, au_fname>DECLARE @count smallint
SELECT @count = 1OPEN <cursor_name, sysname, test_cursor>
FETCH NEXT FROM <cursor_name, sysname, test_cursor> INTO <@variable_1, sysname, @v1>, <@variable_2, sysname, @v2>WHILE (@@fetch_status <> -1)
BEGIN
IF (@@fetch_status <> -2)
BEGIN
-- PRINT 'add user-defined code here...'
-- eg
PRINT 'updating record of ' + @v1 + ' ' + @v2
UPDATE pubs.dbo.authors
SET au_fname = @v1 + '-' + CAST(@count AS varchar(4))
WHERE au_lname = @v2
END
FETCH NEXT FROM <cursor_name, sysname, test_cursor> INTO <@variable_1, sysname, @v1>, <@variable_2, sysname, @v2>
SELECT @count = @count + 1
ENDCLOSE <cursor_name, sysname, test_cursor>
DEALLOCATE <cursor_name, sysname, test_cursor>
GO
declare ht_curs cursor for select changjiafeiyong,changjiazhekou,jisuanleixing,zhi,shuliangs,danjia,danjia_kd from #t1 for update