Your team has been punished for putting ANY KIND[/b] of xml in the db in the first place.

XML is another form of database.

Slower one, more resource demanding, with significant...

When was the last time when...

There is no way to debug an SP with any kind of debugging tools.

Unless it's purely procedural code without any attempt to access data in database.

But in this case, I...

What kind of number?

Integer, decimal, float?

Is "$100.00-" a number for your application?

For some it is.

You did not explain why do you need to convert COLUMNS_UPDATED() to @realUpdate.

Why do you need to convert COLUMNS_UPDATED() to @realUpdate?

What's wrong with it as it is?

And there is an easier way to do this conversion:

SET @realUpdate = CONVERT(int, COLUMNS_UPDATED() )

But you...

It's in connection strings for OLE DB drivers DTS uses to connect to different data sources, including SQL Server databases.

Connection string may be hadcoded in VB code, may be loaded...

You need to check all DB Connections in your DTS's.

DTS is just an application.

It may connect to whatever database it's been set to connect to.

Database has no way to know...

You better don't.

There is no any reason why store date and time separately could be better than datetime.

If you eventually need date portion of datetime value you may use DateOnly...

There is another way to define constrains:

CREATE TABLE #Test1

(RowNum INT IDENTITY(1,1),

TypeID int,...

Martin,

Your question has nothing to do with T-SQL.

It's a task from school math.

To find the correct answer you need:

- stop browsing Internet for it;

- take a piece of paper;

- draw...

Your WHERE clause does not limit...

Then you have 1 to 1 relation between Customers and Addresses, so you may just repeat CustomerID as AddressID.

I can.

Simply by opening BOL on related topic.

What if 2 customers share the same address?

How do you manage it?