Microsoft SQL Server, Transact-SQL, Business Intelligence, CLR, ...
Když neznáme přesnou strukturu výsledku stored procedury, nemůžeme použít CREATE TABLE a INSERT ... EXEC. Dá se to obejít pomocí OPENQUERY:
exec sp_serveroption [SERVER_NAME] , 'data access', 'true'
SELECT * INTO #W FROM OPENQUERY([SERVER_NAME], 'exec sp_who')
SELECT * FROM #W
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using