Java Database Connectivity Question:
Download Questions PDF

How do you get Column names only for a table (SQL Server)?


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

Download Java Database Interview Questions And Answers PDF

Previous QuestionNext Question
How do you call a Stored Procedure from JDBC?What are collection pools? What are the advantages?