When I was coming from a VB background into SQL, I was used to the Now() function to get the current date and time, and didn't yet know about GetDate()....

It was unclear because Commit only decrements the trancount by 1 till that hits 0, and then it actually commits stuff. Rollback takes you all the way to the...

while (1=1)

begin

set rowcount 1

select @temp1= A ,

@temp2= B from #test

if @@rowcount=0

begin

That @@rowcount will never equal zero.

Try this, you'll see why:

DECLARE @A CHAR(1) ;

CREATE TABLE #T (C1 CHAR(1)) ;

INSERT INTO...

If you want the word "NULL" instead of a null value, then yes, you'll need to do that for each column.

if object_id(N'tempdb..#T') is not null drop...

Not quite. ...

If the professor who assigned this is looking for a loop, then use a cursor for it. That's a "loop" in T-SQL.

If it isn't homework, skip the loop and...

You could use Coalesce or IsNull in your query.

Lynn Pettis (10/6/2011)

---

Then the code Jack ran into my be a vestige left over when...

Sean Lange (10/6/2011)

---

Jack Corbett (10/6/2011)

---

I refuse to feel old until the president of the U.S. is younger than me. Eventually it will happen, but not yet.

Never really listened to...

Grant Fritchey (10/6/2011)

---

Stefan Krzywicki (10/6/2011)

---

GilaMonster (10/6/2011)

---

Ninja's_RGR'us (10/6/2011)

---

Grant Fritchey (10/6/2011)

---

Steve Jones - SSC Editor (10/6/2011)

---

If you haven't seen it, his 2005 Stanford Commencement. Excellent talk: http://www.youtube.com/watch?v=D1R-jKKp3NA&feature=player_embedded#!

A sad day, and a reminder...

It will really depend on your table structure, index structure, and what type of data you are storing.

If, for example, you have a clustered index with a fill factor of...

Try this, see if it performs well enough on your actual data volume.

SELECT *,

DATEDIFF(DAY, OrderDate,

...

I haven't used Google docs much, but it sounds like it might be a way to get started.

How would you migrate from docs to wiki?

Building and administering Dev Edition on a VM isn't just for advanced features. It's how I learned the simple basics, too.

Very useful technique.

I also keep a database called ProofOfConcept...