Jeff Moden (12/14/2011)

---

BWAA-HAAA!!! Judging by the fact that more people got the wrong answer than the correct one, I'd say you just taught a whole bunch of people a...

SQLRNNR (12/14/2011)

---

Jim Murphy (12/14/2011)

---

Steve Jones - SSC Editor (12/14/2011)

---

SQLRNNR (12/14/2011)

---

Just as long...

Put my Tally table into the model DB so it now appears in any new DB created

These items might assist you in deciding on the migration

http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle

http://office.microsoft.com/en-us/access-help/move-access-data-to-a-sql-server-database-by-using-the-upsizing-wizard-HA010275537.aspx

http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/

Nice question learned something today - thanks

LutzM (12/12/2011)

---

Evil Kraig F (12/12/2011)

---

...

Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that a few...

In addition to the two answers above you may want to read

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

The above contains some sample injection attack methods and examples.

You may also want to look at this:

http://blogs.msdn.com/b/sqlcat/archive/2008/10/09/table-variable-vs-temp-table-and-estimated-vs-actual-query-plan.aspx

WayneS (12/12/2011)

---

jcrawf02 (12/12/2011)

---

WayneS (12/9/2011)

---

Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a...

Heck - glad I could be of assistamce ...

Is this what you require

CREATE TABLE #Car_User_Log(CarNo VARCHAR(6), Driver VARCHAR(20), UsedDate smalldatetime)

INSERT INTO #Car_User_Log

SELECT 'Car1', 'Neil','12/9/2011' UNION ALL

SELECT 'Car1', 'Don','12/10/2011' UNION ALL

SELECT 'Car2', 'Ramon','12/9/2011' UNION ALL

SELECT 'Car2', 'Sherwood','12/10/2011' UNION ALL

SELECT...

LSN is normally the Log Sequence Number and you can read about that here:

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

If you mean the databse ID number read about it here:

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

Now if you really mean Database ID...

Jeff Moden (12/11/2011)

---

bitbucket-25253 (12/10/2011)

---

If you are not completely committed to IT .. and I mean COMPLETELY, then I would suggest taking a college or graduate school course leading to a...

If you are not completely committed to IT .. and I mean COMPLETELY, then I would suggest taking a college or graduate school course leading to a degree, and/or a...

Hmmm Not wanting to give away the reasoning utilized to determine the correct answer I am posting this comment - so as to receive automatic notifications of additions to the...