If the Dr. was important (I think we can draw that inference) MS will have had him sign an NDA, plus a long notice clause, plus a non-compete clause.  If...

A lot of people don't like the stress of changing jobs and possibly moving house to boot.  These are often depicted as lifers and as such they can be abandoned...

This kind of t-sql will work if the string is always this well formed.  But will probably need extending using regexp if there are apostrophes in names.

declare @Name varchar(50)

declare @newName...

One thing you could do is return the output from SQL as XML, then the XML returned to the document can be read and any 'friendly' error messages placed in...

In simple terms SQL can't find the log file.  This is because the machine that did the sp_detach_db has a different internal physical file system, and the mdf contains a...

Transferring the data can be straightforward. I usually find that transferring it to working tables in exactly the same format as the access tables and then using t-sql to...

Well either knowing the answer or finding it out through a source that is always available are valid ways of answering QOD.

I just think that it would be better if...

No

But I tried to do a select count(*) and select * against a big and a little table and in both cases the execution plan used an 'index scan' to...

I don't think there are any problems with @@rowcount, but I would consider using min/max to get the row you want rather than top.

Brevity is good, how do you pronounce your name 5409045121009? Do you put the stress the second 4?

You could use a trigger on the table that writes to an...

You are cross posting - the site owners get cross about that kind of thang.

This is one way to create break totals and running totals without cursors or temp tables.

Here is a technique to calculate break totals (sum of a group) and running totals (sum of all groups to date. Perhaps you could see a different way to...

It must be true because that's what it says.

Apologies in advance because I must be being dumb, but can't you just remove 'StoredProc2' as it is only getting the output...

There are 3 'for xml' (explicit, raw and auto) options. The simplest of which if auto.

A simple example would be

create procedure usp_forxml

(@SupplierID int)

as

SELECT [ProductID], [ProductName], [SupplierID] FROM [Northwind].[dbo].[Products]...

If you are building up a sql string to execute repeated use of 'print' is your best way of debugging (but print commands should be removed before using the proc...