Is there any need for ANY, SOME or ALL?
Is there anything that can't be done with In, (NOT) EXISTS or the new EXCEPT
and INTERSECT operators or other subqueries?
thanks

If I have the string '200807', how can I change this to be '31/7/08' and get
the date of 2008/07/31 in the SQL? get the last day of the month first..
Thanks for your help.

How do I get a DISTINCT Count by a Date???
Employee #       Date
*********      ****
12345678          07/29/2008

I have a series of read and update activities in a transaction. All of my
read activities are of the default isolation level (read committed). If
another update (in its own transaction) changes and commits the data after
the my transaction starts, is the read in my transaction ...

I have a Catch block for an Insert...Select statement. This statement may
insert zero, one or multiple rows.
In my Catch block, is there any way to determine the primary key (Identity
column) of the record I attempted to insert when the failure occured? Or,

I have a table from which I need to get only the newest record, but the
newest for each account based on creation date.
Each account can have many entries but only the most recent for each is what
I want, should I use top or max and can you show by a simple sql statement.

For quite a while I've been using the code on this page for importing data
from SQL to Excel:
http://support.microsoft.com/kb/306125/en-us
It works great until I needed to use a SPROC for retrieving timephased data

have 2 SQL server.
Have a Table on Server A with an identity field.
On server B, I execute an insert statement into the table on Server A. Then I wan to get the identity value that was entered the the new record inserted into the table.
Calling @@Identity on server B returns NULL. ...

Please excuse my ignorance, as I'm not overly with the inner workings of SQL,
nor do I know programming very well.  I've been given the task of taking all
of the data from a table on our sql 2005 server, exporting it, and importing
it into a SQl 2005 express client.  This needs ...

Does anyone know how I can programtically get all the Sql server service
accounts mainly just the sql server service and agent service
for my auditing so I don't have to log onto to every server to find out?
I have had a good look and can't find it in any of the sql tables

I'd like to schedule a job to run a batch file every night but am unsure of
the syntax. I thought there was an extended stored procedure that could run
files but am unable to locate anything in books online. Any help would be
appreciated.

-- Little demo of xp_sprintf featuring a well-known saying, just for fun.
DECLARE @p1    VARCHAR(30),
       @p2    VARCHAR(4)
DECLARE @input_string    VARCHAR(100)

Not sure if the subject is worded correctly, but here's my problem:
I installed SQL 2005 on my XP Pro machine that already had SQL 2000
installed.  The SQL 2000 service is simply "MYMACHINE", so I had to
name the 2005 SQL service "MYMACHINE\MYNAME", and this has caused me

In the SQL 2005 SMO object library, what is the difference between the
"Default" property of a Column member (of a table), and the
"DefaultConstraint" property?
I am looking here:

I have the following code in SQL 2005 using the SMO object model:
' Options to script the default constraints.
Dim DefaultConstraintsOptions As _
Microsoft.SqlServer.Management.Smo.ScriptingOptions = New _