Browse by Tags

All Tags » SQL (RSS)
若要查看表的列名,可以使用 sp_help 或下列查询之一:SELECT name FROM sys.columns WHERE OBJECT_ID IN (SELECT OBJECT_ID ('table_name')) 或 SELECT TOP 0 * FROM table_name。 1. Execute sp_help tablename 如: Execute sp_help 'Schedule' 2. Select Top 0 * From tablename 如:Select Top...
Posted by Ralax | with no comments
Filed under: ,
More Posts