As this is not a SQL Server error, you may want to start here or here (as the error message suggested.

malli.chitturi (11/2/2009)

---

Its not about memorizing the Q&A. Its about SQL is easy to Learn but hard to master. So Its just helping what part of SQL they have to concentrate...

Sorry? What seems to be the problem?

Alvin Ramard (11/2/2009)

---

First interview question: What would you do if I told you that I go by the nickname of GilaMonster...

Alvin Ramard (11/2/2009)

---

You, or Gail, should have told them: "Never mind memorizing questions and answers. Just close your eyes and...

In SQL Server 2005/2008 you can do this:

with FirstTest (

[Name],

[Score],

[Date],

[RowNum]

) as (

select

...

Amazing it is how snooty some can be.

By definition, a table is unordered even if you have indexes defined (either nonclustered or clustered). The fact that a result set returned by an unordered query (no ORDER...

Actually, what is annoying is people asking for answers to...

IIRC, you can use the Import/Export utility (SSIS) to transfer data (and can create the tables, but may be some other requirements) between SQL Server 2005 and SQL Server 2000.

Not a problem. I noticed you were new...

Without your code it is a little hard to know what you are having problems with here. Also, for the best help possible, please read and follow the instructions...

I'd be interested as well.

Still have not figured out what you are talking about with regard to white spce in the database. That question was asked earlier.

Thought this one was interesting. Basically, I found this neat code and I would like someone else to port it to SQL Server for me.