SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Don Halloran

SQL Server, SSIS, SSAS and maybe even SSRS rants and raves (and, on occasion, useful code or designs).

Archives: June 2011

Things That Should Be In TSQL

Relation Types

create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints!
create table T(type_T)

Relvar Assignment

This follows from relation types:
create table T(type_T)
create table U(type_T) = T 
declare @V table(type_T) = U 
Strong typing could be enforced, which might…

Read more

1 comments, 864 reads

Posted in Don Halloran on 15 June 2011

Getting Backup File Information from a Table Valued UDF - SQLCLR to the Rescue?


After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead I got an error about functionality being disabled in the SQLCLR) I gave up and turned back to the idea of opening a connection and using the engine to…

Read more

0 comments, 1,356 reads

Posted in Don Halloran on 15 June 2011