Question :How do you get Column names only for a table (SQL Server)? Write the
Query. (JDBC)
Answer :select name from syscolumns where id=(select id from sysobjects where
name='user_hdr') order by colid --user_hdr is the table name
www.interviewhelper.org is a hope for all the Job seekers. Users can find unlimited here. These range from technical to HR, from functional to behavioral. www.interviewhelper.org contains in the fields like Ajax,VB,Networking,Sharepoint,JEE,Perl,Javascript,Bioinformatics,Classic ASP,Unix,Linux,Accounting,Oracle DBA,Microprocessor,Bluetooth,jms,jme,.net framework,ABAP,ASP,ASP.net,Basic .net Framework,Interview Questions,C language,C++,database,Oracle,Java,PHP,LAMP,SAP etc.
Friday, March 13, 2009
How do you get Column names only for a table (SQL Server) Write the
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment