Couldn't find anything in BOL, but out of curiosity, I tested it. Max is 256.

When I tried:

create table #T (ID int primary key)

insert into #t (id) select 1

select 1

from...

From the example given, I'd say the easiest way to do this would be:

select *

from dbo.Table

where Column like '%Reg%'

If you really need something smarter than that, then you need to...

Was this an interview question, or something on an exam? Are you looking for some specific data about joins, or just looking for someone to answer an interview question...

Because of the way views work, think of them as a way to give yourself a shortcut for complex queries that you will use over and over again.

So, the answer...

Enterprise Edition requires a server OS.

If you're planning on using it only for personal use, or for dev use, you can use SQL Server Dev Edition on Vista. That's...

Use a temp table instead of a CTE for this. CTEs can't have procs in them.

select 1

while @@rowcount > 0

... your update script here ...

Or you can use "While exists ()". Put the query you want inside the parentheses.

So, basically you don't back up the database, and someone deleted a system table that you need?

I'm really not sure what to do about that. I tried a Google...

MSDN.com has tutorials with walk-throughs for this kind of thing.

Volunteering to help a church or other charity is a good idea.

Another is to find something in your own life that...

Can you restore from a backup?

It looks okay to me too. I'd try running each sub-query separately. See if they all work on their own.

Don't you mean "BizzBuzz breaths per minute"?

If all the proc does is select stuff, you could always have the scheduled job that updates the statistics run the proc as a second step. Would that work...

I don't see an error in either of these. Can you post the whole proc that's giving you the error?

SQL Server 2005 Bible (Wiley Publishing) by Paul Nielsen, has very good data on that (and a ton of other data).