1、declare cursor

declare cursor發(fā)音

英：　　美：

declare cursor中文意思翻譯

常見釋義：

聲明游標

declare cursor雙語使用場景

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

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

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

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

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

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

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命令定義一個游標，它使用SELECT語句讀取源表SALES的所有數(shù)據(jù)。

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)鍵字或默認設(shè)置為LOCAL的DECLARECURSOR語句創(chuàng)建的游標名稱。

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

declare cursor相似詞語短語

1、hereby declare───特此聲明

2、cursor io───光標io

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

4、cursor game───光標游戲

5、declare───vt.宣布，聲明；斷言，宣稱；vi.聲明，宣布

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

7、leading declare───前導(dǎo)聲明

8、cursor extension───光標擴展

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

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

這個存儲過程將列出數(shù)據(jù)庫的所有表的創(chuàng)建時間:

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

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

1) db: 數(shù)據(jù)庫名稱

2) tab : 表名稱

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

轉(zhuǎn)