Your question looks and sounds like something from a test.

If it's a legit question, then what you're looking for is the concept of "correlated subqueries". The book "SQL Server...

The solution I'd go with would be to assign a standard identity column to the orders table, and then use a view with the Row_Number function in it for the...

I'm going to add a vote for "buy something that does this for you". RedGate's Compare is good. I use ApexSQL Diff, because it compares both structure and...

If you search the web (Google, Live, Yahoo, whatever), for "infopath sql server", you'll find articles like the one at:

http://msdn.microsoft.com/en-us/library/aa159896.aspx

That one is about how to connect InfoPath to SQL Server,...

DBMail is built into SQL 2005 and 2008. If you are using a version before that, it's a bit more complex.

Assuming you're using 2005/08, you'll need to enable the...

Do you have a question about the code?

I don't know a way to get exactly what you're looking for in one solution.

I'd log the update (as you're doing), and run a trace. From time-stamps, SPIDs, etc.,...

In that case, I'm pretty sure you're going to be stuck with making sure all necessary variables are declared NChar/NVarchar, that you have N before any string-literals, etc.

The only reason I sometimes use table variables instead of temp tables is speed. Yeah, it's cutting milliseconds off the processing time, but sometimes that matters. Since table...

Timothy (1/5/2009)

---

GSquared (1/5/2009)

---

If you set a standard that the variable "i" (or @i) is only to be used for while loops, and is to be used for all while loops,...

The discussion on Joe's article was definitely interesting.

Like most who chimed in, I prefer using DateAdd over Floor/Ceiling, because of consistency. Unlike most who chimed in, I don't tie...

Is there a reason to do this in a trigger, as opposed to working from a trace? A trace will give you exactly what you're looking for, the proc...

You could try setting the default collation to an extended character set. Not sure if that would work, but it might be worth testing on a dev server.

My general rule of thumb is only use table variables for less than 100 rows of data. Even then, things like transaction management and the ability to use DDL...

If it's actually tempdb, then you need to keep in mind that tempdb is essentially wiped out whenever you restart the SQL services (such as if you reboot the server...