ahh so true; the dba title is one you can apparently take at will; we see way to many "dba" titles around the neck of posters asking questions from Chapter...

I don't think anyone can post anything that would be more understandable that what exists in Books online;...

how about selecting all the non-5.10.15 values so they can be eliminated?

WHERE vehicle_types IN (05,10,15)

AND vehicle_types NOT IN (SELECT vehicle_types FROM SOMETABLE WHERE vehicle_types NOT IN (05,10,15))?

WHERE vehicle_types IN (05,10,15)

AND vehicle_types NOT IN (20)?

excellent job on giving us all the stuff we need to help with!

in this case, i thinkyou want to use the BETWEEN command in your where statement, that lets you...

there are two ways;

you can not refer to the column at all, or you need to use the NULL keyword explicitly:

--define the columns being inserted, skip #4

INSERT INTO TableName ...

i think i understood you correctly...say there is a file Archive.zip on your ftp site, you wanted to know the names of the files / contents INSIDE Archive.zip before having...

nope, there is no way to read the contents of a zip file unless it exists locally; so if the file exists on the FTP site, you have to download...

this is normal; the execution plan is cached;

when you create a proc/function/view, and it features SELECT * FROM, behind the scenes the actual query is stored as SELECT Col1,Col2,Col3.... for...

Nagesh S-432384 (5/21/2010)

---

TRUNCATE TABLE permissions is default to the members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles. I think you should be able...

yep, what you posted matches what i have in my snippets, captured from some other post on the same subject:

The main clauses in SQL are logically executed in the following...

just the "thank you" you already gave us is enough; we all apreciate receiving that!

it's fairly simply, just pass in the format string you want to use; if you are familiar with the CONVERT(date,StyleNumber), many of the typical formats are built in:

declare @TheDate datetime

SET...

glad i could help a bit!

when you take a backup, it gets the data, and then the log of all changes as well; so say you had a backup that was huge, and took...