Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 INSERT IN TABLE + SET STATISTICS PROFILE

Author  Topic 

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2013-03-21 : 17:58:15
how to insert into a table "set statistics profile on"

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-03-22 : 00:14:37

set statistics profile on;
insert yourTable VALUES(arg1..., arg2...)
Go to Top of Page

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2013-03-22 : 12:29:34
for example
i enable set statistics profile on;
run a query select * from table1

I want the result to be inserted into a #temp
Go to Top of Page
   

- Advertisement -