Java Database Connectivity Question:
How do you get Column names only for a table (SQL Server)?
Answer:
Write the Query. -
select name from syscolumns
where id=(select id from sysobjects where name='user_hdr')
order by colid --user_hdr is the table name
select name from syscolumns
where id=(select id from sysobjects where name='user_hdr')
order by colid --user_hdr is the table name
| Previous Question | Next Question |
| How do you call a Stored Procedure from JDBC? | What are collection pools? What are the advantages? |