我们都知道在delphi中循环表中的记录是这样的
qy1.close;
qy1.sql.clear;
qy1.sql.add('select from a');
qy1.open;
while not qy1.eof do
begin
.......
qy1.next;
end;
有没有在sqlserver2000查询分析器里的循环呢?
请各位高手指教。
qy1.close;
qy1.sql.clear;
qy1.sql.add('select from a');
qy1.open;
while not qy1.eof do
begin
.......
qy1.next;
end;
有没有在sqlserver2000查询分析器里的循环呢?
请各位高手指教。
BEGIN
UPDATE titles
SET price = price * 2
SELECT MAX(price) FROM titles
IF (SELECT MAX(price) FROM titles) > $50
BREAK
ELSE
CONTINUE
END
DECLARE tnames_cursor CURSOR
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
OPEN tnames_cursor
DECLARE @tablename sysname
--SET @tablename = 'authors'
FETCH NEXT FROM tnames_cursor INTO @tablename
WHILE (@@FETCH_STATUS <> -1)
BEGIN
IF (@@FETCH_STATUS <> -2)
BEGIN
SELECT @tablename = RTRIM(@tablename)
EXEC ('SELECT ''' + @tablename + ''' = count(*) FROM '
+ @tablename )
PRINT ' '
END
FETCH NEXT FROM tnames_cursor INTO @tablename
END
CLOSE tnames_cursor
DEALLOCATE tnames_cursor
SELECT LastName, FirstName FROM Northwind.dbo.Employees
OPEN Employee_Cursor
FETCH NEXT FROM Employee_Cursor
WHILE @@FETCH_STATUS = 0 -- not eof
BEGIN
FETCH NEXT FROM Employee_Cursor
END
CLOSE Employee_Cursor
DEALLOCATE Employee_Cursor
select @zd='select top 100 * from qcsjb'
请问在sqlserver2000查询分析器里用什么语句可以显示出@zd的语句,也就是显示出'select top 100 * from qcsjb'的结果。
select @zd='select top 100 * from qcsjb'
请问在sqlserver2000查询分析器里用什么语句可以显示出@zd的语句,也就是显示出'select top 100 * from qcsjb'的结果。
我的意思是说怎样对@zd进行操作,才能显示出它的值所执行的sql语句。
望高手指点。