Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tampapat
Starting Member
18 Posts |
 Posted - 2012-09-05 : 11:01:56
|
| I am trying to get the names and count of all the fields in a DB. I was told the best way is to Iterate,cursor and loop the sys.table and sys.sys fields. Can someone tell me the best way to do this please. I am new at SQLPatrick Palmer |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-05 : 11:33:54
|
| Dupe, answered here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=178513 |
 |
|
|
|
|
|
Iterate,cursor and loop