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 |
|
anwarul.haque
Starting Member
7 Posts |
Posted - 2008-11-24 : 07:19:08
|
| Hi All,with thisSELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME ='Your Table name here'I'm getting table detail infobut i need table details as well as field values also, is this possible?Please help me to out.Thanks in advanceHaqueHaque |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 07:33:19
|
| you need union this withselect columns from yourtableto get it |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-11-24 : 07:36:15
|
| If you send resultset to front end, you can easily get the table information thereMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|