Ambition IT - Weblog
SQL Server
posts - 36, comments - 9, trackbacks - 0
Tuesday, July 06, 2010
#
Execute a command against all tables in a database
Have you ever wanted to execute a command againts all tables in your database? And did you struggle with cursors or WHILE BEGIN ... END loops? So did I. Until I discovered the undocumented stored procedure sp_MSforeachtable and I love it.
posted @
Tuesday, July 06, 2010 6:15 PM
|
Feedback (1)
«
July
»
Sun
Mon
Tue
Wed
Thu
Fri
Sat
27
28
29
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
About
Contact
Login
Archives
March, 2011 (1)
January, 2011 (1)
October, 2010 (1)
September, 2010 (7)
August, 2010 (1)
July, 2010 (2)
June, 2010 (1)
May, 2010 (2)
April, 2010 (5)
March, 2010 (2)
February, 2010 (4)
January, 2010 (2)
October, 2009 (2)
July, 2009 (5)
Ambition IT
Ambition IT
SQL PASS
Syndication:
RSS
ATOM