declare @table sysname

DECLARE @Row_Count int

SELECT @Row_Count = rows FROM sysindexes

WHERE id = OBJECT_ID(@table) AND indid <...

IF you're trying to do date arithmetic, your syntax is slightly off

Trythis

Select number, emission

from NF

WHERE (emission > dateadd(dd, -60, getdate())

To get everything within the past 60 days.

The easy way is to make the 2nd user a member of the role db_ddladmin. This will allow them to make any DDL change so it might not be...

In a simple answer: yes!

For details, I would look at the (undocumented) sp_who2 stored proc to see where it retrieves its info from. You can use the same logic...

To add to what's already been answered, you need to use caution and preserve your actual error code. ALL t-sql statements reset @@ROWCOUNT and @@ERROR. This includes your...

quote:

---

What is DDL?

---

DDL = data definition language.

Post the statement used to create the table and...

There is not an either/or situation with join and union. join is used to combine 2 or more tables into a single virtual table with a set of columns...

You should have a PK on every table of substance in your db. There really isn't any good reason NOT to have at least one column. If you...

No one in their right mind would give a critical project to a rookie. You need to work on a home grown project. I suggest looking at one...

hey! once you're ready, i would hop over to mcsebraindumps.com. The price is right and info is readily available to help you assess your readiness to take the exam.

A little late (:) but still relevant: I think someone fairly strong in SS7 could pass the SS2K exams. It wouldn't be a walk in the park by any...

I still say books online is the best resource. All the info, all of it right, and surprisingly relevant to the test. With the 120-day free trial, it's...

MS has changed their retention policy on expiring certifications. Now instead of expiring, they have added a qualifier to what you are certified in. My MCDBA show I...

I took both 029 and 229. i would say go for the SQL 2000 exams because there wasn't that much additional material covered, in my opinion. The cert...

I suggest mcsebraindumps.com. They have tons of sample questions. Just don't trust the answers. The pri¢e is very right (free).