/* How to get linked values in one group using CTE*/
create table table_a
(col1 varchar(100),
col2 varchar(100))
go

Session propery SQL Server 2005


In sql server we can get session property many ways
1. dbcc useroptionsdbcc useroptions
This will give us information about all the enabled setting for that session.
In SQL Server 2005 two new options are available
2. sessionproperty function

Popular Posts