SQL does not keep any form of rowid or insert time that you can use to pick up frst or last inserted record.

If you want to be able to get...

It should be doable as a table constraint

Something like something like (ColA IS NULL AND ColB IS NULL) OR (ColA IS NOT NULL AND ColB IS NOT NULL)

These are the RSS feeds that I watch. Note that my job is SQL performance tuning and optimisation, so some of these might be a much lower level than you're...

Is this comp sci homework?

I'd suggest a cursor (forward_only, read_only) over the instructors and use a select statement for each to build up the list of courses. Something like

SELECT...

I would suggest NOLOCK as a last resort. Look at optimising your select as much as possible to get it running faster, also look at optimising the update. Firstly you...

Yes it can. As that piece from books online stated, a select takes shared locks for the duration of it's execution. A shared lock means that while other reads can...

Thanks Todd. I noticed the E-Learning. How long does it take? I was considering taking it during lunch breaks next week.

I've got a lot of experience with 2000, and have...

There's not that much difference between a cursor that processes a set of records one by one and a while loop that processes a set of records one by one....

Can you give an example of @sql_string?

There is an error avoidence technique that you could use:

IF EXISTS (SELECT 1 FROM sysobjects WHERE name='TableToBeDropped')

 DROP TABLE TableToBeDropped

Yes, but it will require a subquery to do the calculation

SELECT PRODUCTS.PRODUCT_ID, PRODUCTS.P_NAME, VOTES.V_SCORE

FROM [PRODUCTS]

LEFT JOIN [VOTES]

  ON VOTES.PRODUCT_ID = PRODUCTS.PRODUCT_ID AND

       VOTES.USER_ID = 3

LEFT OUTER JOIN (SELECT Product_ID,...

I'm not a fan of dynamic SQL, but this is a place where it will help.

DECLARE @DBName varchar(20)

SET @DBName = 'msdb'

DECLARE @sSQL VARCHAR(500)

SET @sSQL = 'SELECT name, filename FROM '...

I mostly agree with Marco. Here's a suggested rewrite

SELECT Table01.field01, Table01.field02, Table01.field03, Table01.field04, Table01.field05

 FROM Table01 LEFT OUTER JOIN Table02 ON Table01.field03 = Table02.field03

 LEFT OUTER JOIN Table03 ON Table01.field03 = Table03.field03

 WHERE...

You can change TempDB's collation by changing the colation of then entire server. That will involve rebuilding the master database with the new collation. Look up Rebuildm in books online.

If you are...

How about building up an insert/update statement as a string then executing it after the rollback. Something like this

BEGIN TRANSACTION

Insert into VeryImportantTable (...) values (...)

IF @@Error!=0

BEGIN

DECLARE @sSQL VARCHAR(1000)

SET @sSQL =...

Yes you can. You can't trap the ones above 20, but those are written into the error log. 11 through 19 are standard errors, less than 11 are warnings or...