I have done this with Sql server temp table.
SELECT * INTO #temp FROM CIF_CARDpro_IRIS_USDDATA --Select from temp table SELECT * FROM #temp --List of columns SELECT COUNT(name) NumOfColumns FROM tempdb.sys.columns WHERE object_id = object_id('tempdb..#temp'); --drop temp table DROP TABLE #temp
Comments
Post a Comment