Yes - it is definitely working.

The first SP does

BEGIN TRY

BEGIN TRANSACTION

Do stuff

INSERT record

COMMIT TRAN

END TRY

BEGIN CATCH

-- handle and rollback

END CATCH

The...

Hi

There are 3 SPs that are public facing via a Service and they need to use BCP to create fmt and dat files, or consume these files. The consumption should...

Cheers - but don't get me wrong - it isn't that I dislike SQL CLR - I am a .NET Dev in my real job :D, but I happen to...

Hi

I forgot I made this post as it went silent for so long...I have decided to use SQL# (sqlsharp.com) component which allows me to compress the Xml datatype into a...

Hi Grant

To me this sounds like you are advocating a table per 'enum' else I can't see how the FK constraint would work?

I have a preference for less tables -...

Are you prescribing a single table for all by database wide constants, or a table per type/enum?

I have given a simple example below of what I believe you are suggesting...