J

I just pointed out that the OUTPUT in SQL implementation is not a pure output parameter and can cause issues if not used carefully.

In most cases (depending on your...

GSquared,

You presented a nice case for sequential transactions. I need a good case that will prove that the nesting the way it is implemented really works and is usefull....

GSquared, with all due respect - SQL pretends to nest transactions :). If the last ROLLBACK uncommits all your pervious work this is not nesting in my book.

Lee,

Few comments and warnings on what might bite you in the future.

1. Calling SPs from another SP is not a big deal and has nothing to do with set based...

The difference between your script and mine is the usage and the output it generates. The objective of my script is to generate a set of insert statements that can...

Before you start adding your miliseconds please remember that a datetime datatype is accurate to 3 miliseconds not 1 milisecond (and there are 999 not 99 of them 🙂 )....

Post your select statement you use to build your string.

I think one or more of the fields you are getting your data from is defined as NVARCHAR or NCHAR and...

Can you post a sample SQL call you use to store your data.

I think it might be caused by a convesion to NVARCHAR somewhere

GilaMonster (3/4/2009)

Just to explain why. If you define a varchar (or char, nchar, nvarchar, binary, varbinary) without giving a length parameter, the default...

Obsolete methods (proceudres, views, functions) are a big headache in a system that is evolving because they introduce confusion. Sometimes the business change forces you to modify a design of...

Another thought.

I do not believe in backups.

I believe in double or triple backups. And if possible using different methods and media types.

I think there is also another aspect to this issue. Security. When you back up your database and store the backups on tapes, disks, online or whatever ather method you...

Nicely put Steve.

I will never give a definite answer if asked if something is going to work unless I test the crap out of it. Been burned too many times...

Bob,

you are right - I do not check anything, I measure time by checking a shadow of a stick and wind direction by licking my finger and sticking it out....