How to list all field names in the result set using mssql_field_name()?



How to list all field names in the result set using mssql_field_name()?..

Answer / Kunwer Ishan Gahlout

"There is no direct function named mssql_field_name(). Instead, you can use SQL Server's built-in function COLUMNS('table_name').* which returns a recordset with column_ordinal and column_name for each column in the specified table."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is mapping schema?

1 Answers  


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1 Answers  


Delete duplicate rows without using rowid.

1 Answers   Nagarro,


What is the Disadvantage of indexed sequential file.

1 Answers   HCL,


Which database stores information about replication?

1 Answers  


What is stored procedures?

1 Answers  


What are “unrepeatable reads”?

1 Answers  


What are the restrictions that views have to follow?

1 Answers  


explain databases and sql server databases architecture? : Sql server database administration

1 Answers  


What is recompile sql server?

1 Answers  


What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,


Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  


Categories