1、declare cursor

declare cursor發(fā)音

英：　　美：

declare cursor中文意思翻譯

常見(jiàn)釋義：

聲明游標

declare cursor雙語(yǔ)使用場(chǎng)景

1、remote database is just specified in the DECLARE CURSOR statement using the database option.───只需使用DATABASE選項在DECLARE cursor語(yǔ)句中指定遠程數據庫。

2、If the query expression is part of a DECLARE CURSOR statement, column_alias cannot be used in the FOR UPDATE clause.───如果查詢(xún)表達式是DECLARECURSOR語(yǔ)句的一部分，則不能在DECLARECURSOR中使用column_alias。

3、Use a 'DECLARE cursor' statement to define a cursor over the evaluation of the query.───使用' DECLARE CURS OR '語(yǔ)句在查詢(xún)的評估上定義一個(gè)游標。

4、The DECLARE CURSOR statement is the root of the graphical execution plan tree, with its related statement as a child or node.───DECLARECURSOR語(yǔ)句是圖形執行計劃樹(shù)的根，與之相關(guān)的語(yǔ)句為子級或節點(diǎn)。

5、An application should only execute DECLARE CURSOR if it has set all the API cursor attributes back to their defaults.───應用程序只有在將所有的API游標特性設置回默認值后，才可以執行DECLARECURSOR。

6、DECLARE CURSOR permissions default to any user that has SELECT permissions on the views, tables, and columns used in the cursor.───默認情況下，將DECLARECURSOR權限授予對游標中所使用的視圖、表和列具有SELECT權限的任何用戶(hù)。

7、With the DECLARE CURSOR command, a cursor is defined that reads all data of the source table SALES using a trivial SELECT statement.───使用DECLARECURSOR命令定義一個(gè)游標，它使用SELECT語(yǔ)句讀取源表SALES的所有數據。

8、Is the name of a cursor created by a DECLARE CURSOR statement that either has the LOCAL keyword or that defaulted to LOCAL.───由具有LOCAL關(guān)鍵字或默認設置為L(cháng)OCAL的DECLARECURSOR語(yǔ)句創(chuàng )建的游標名稱(chēng)。

9、Definition of the required cursor does not occur separately by executing DECLARE cursor.───不需要通過(guò)執行DECLARE CURSOR單獨定義所需的游標。

declare cursor相似詞語(yǔ)短語(yǔ)

1、hereby declare───特此聲明

2、cursor io───光標io

3、cursor───n.光標；（計算尺的）[計]游標，指針

4、cursor game───光標游戲

5、declare───vt.宣布，聲明；斷言，宣稱(chēng)；vi.聲明，宣布

6、declare oneself───v.發(fā)表意見(jiàn)，顯露身份; 抒發(fā)己見(jiàn)；顯露身分；發(fā)表意見(jiàn)

7、leading declare───前導聲明

8、cursor extension───光標擴展

9、cursor customizer───光標自定義程序

2、sql server中查詢(xún)所有表的創(chuàng )建和修改時(shí)間？

這個(gè)存儲過(guò)程將列出數據庫的所有表的創(chuàng )建時(shí)間:

Create proc usp_alldatabases

as

begin

declare @script as nvarchar(2000)

if exists(select 1 from sysobjects where name='tab_alltables') drop table tab_alltables

create table tab_alltables (db nvarchar(1000), tab nvarchar(1000),cdate datetime)

declare c cursor for

select 'insert into tab_alltables (tab,db,cdate) select name,'''+name+ ''',crdate from ' +name+'..sysobjects where xtype=''u''' from master..sysdatabases where dbid>4

open c

fetch c into @script

while @@fetch_status=0

begin

exec (@script)

print @script

fetch c into @script

end

close c deallocate c

select * from tab_alltables --You can add your criteria here to serach for a particular table name

end

這個(gè)SP將產(chǎn)生三列：

1) db: 數據庫名稱(chēng)

2) tab : 表名稱(chēng)

3) cdate： 表的創(chuàng )建時(shí)間

轉