DECLARE @ColumnName Varchar(50)
DECLARE @SQL Varchar(500)
DECLARE get_TableName CURSOR FOR
SELECT [TABLE_NAME]
FROM DatabaseName.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY [TABLE_NAME];
open get_TableName
FETCH NEXT FROM get_TableName INTO @TableName
WHILE @@FETCH_STATUS = 0
Begin
DECLARE get_ColumnName CURSOR FOR
SELECT [COLUMN_NAME]
FROM NPU_INFO.INFORMATION_SCHEMA.COLUMNS
WHERE [TABLE_NAME] = @TableName ORDER BY [COLUMN_NAME];
open get_ColumnName
FETCH NEXT FROM get_ColumnName INTO @ColumnName
WHILE @@FETCH_STATUS = 0
Begin
Print @TableName+'/'+@ColumnName
SET @SQL='What you want to run'
EXEC(@SQL)
FETCH NEXT FROM get_ColumnName INTO @ColumnName
End
CLOSE get_ColumnName
DEALLOCATE get_ColumnName
FETCH NEXT FROM get_TableName INTO @TableName
End
CLOSE get_TableName
DEALLOCATE get_TableName
[ add comment ] | permalink | related link |
( 3 / 10467 )TCP/IP stack repair options for use with Windows XP with SP2/SP3.
Start, Run, CMD to open a command prompt:
In the command prompt window that opens, type type the following commands:
Note: Type only the text in bold for the following commands.
Reset TCP/IP stack to installation defaults, type: netsh int ip reset reset.log
Reset WINSOCK entries to installation defaults, type: netsh winsock reset catalog
Reboot the machine.
[ add comment ] | permalink | related link |
( 3 / 4671 ) |
| 9/5-9/7. 2009 Utah National Parks |
[ add comment ] | permalink | related link |
( 3 / 4013 )[ add comment ] | permalink | related link |
( 3 / 2549 )昨天看了《同一首歌》在湾区的庆国庆的表演，听到万山红唱的一首老歌《那就是我》,十分感动。
那就是我
词作者：晓光
曲作者：谷建芬
我思念故乡的小河
还有河边吱吱唱歌的水磨
噢妈妈 如果有一朵浪花向你微笑
那就是我 那就是我 那就是我
我思念故乡的岁月
还有小路上赶集的牛车
噢妈妈 如果有一只竹笛向你吹响
那就是我 那就是我 那就是我
我思念故乡的渔火
还有沙滩上美丽的海螺
噢妈妈 如果有一叶风帆向你驶来
那就是我 那就是我 那就是我 那就是我
我思念故乡的明月
还有青山映在水中的倒影
噢妈妈 如果你听到远方飘来的山歌
那就是我 那就是我 那就是我
[ add comment ] | permalink | related link |
( 3 / 10253 )
Back Next
Avatar
