by Pieter Brinkman
23. August 2009 03:04
With common table expressions you can save the results to a temporary result set and use this results set for other queries.
[code:tsql]
WITH temporaryNamedResultSet
AS
(
select UserName from aspnet_Users
)
select * from temporaryNamedResultSet
[/code]
by Pieter Brinkman
26. June 2008 08:03
Execute the next query to enable CLR.
-- Turn advanced options on
EXEC sp_configure 'show advanced options' , '1';
go
reconfigure;
go
EXEC sp_configure 'clr enabled' , '1'
go
reconfigure;
-- Turn advanced options back off
EXEC sp_configure 'show advanced options' , '0';
go
More info about CLR on Microsoft MSDN.
Subscribe