如何用游标? 因字段是text类型,存储过程似乎不能用select text from XXX where ...
UPDATE Table SET a1 = (SELECT a1 FROM Table WHERE a2 = '123') WHERE a2 = '234'
To genphone_ru(票票): 字段是text类型,使用你说的方式显示错误。 Error 279: The text, ntext, and image data types are invalid in this subquery or aggregate expression
在Delphi程序中实现吧。 var wsText:WideString;with Query1 do begin Close; Sql.Clear; Sql.Add('SELECT sText FROM Table WHERE A1 = ''123'''); Open; wsText := FieldByName('sText').AsString; Close; Sql.Clear; Sql.Add('UPDATE Table SET sText = '''+wsText+''' WHERE A1 = ''134'''); ExecSQL; end;
存储过程中实现不了吗?我看到有一个命令updatetext似乎是针对text类型的但不知怎么用。
UPDATE Table1 SET a1 = b.a1 from Table1 a,(SELECT a1 FROM Table WHERE a2 = '123') b WHERE a2 = '234'
如何在存储过程中实现?
因字段是text类型,存储过程似乎不能用select text from XXX where ...
WHERE a2 = '234'
字段是text类型,使用你说的方式显示错误。
Error 279: The text, ntext, and image data types are invalid in this subquery or aggregate expression
var wsText:WideString;with Query1 do
begin
Close;
Sql.Clear;
Sql.Add('SELECT sText FROM Table WHERE A1 = ''123''');
Open;
wsText := FieldByName('sText').AsString;
Close;
Sql.Clear;
Sql.Add('UPDATE Table SET sText = '''+wsText+''' WHERE A1 = ''134''');
ExecSQL;
end;