select * from table1 where date = '1/1/2008 12:00:00 AM' order by date asc
I would like it to query not only rows that match the exact date but also
ones that are close if no rows of the extract is returned.
Thank you

Is there an SQL equivalent of HTML escape sequences so that I could
include special characters like ' in an SQL string?

I have an some xml .. that I pass into a stored procedure.
The input datatype is now
@xml_doc xml
(it used to be @xml_doc (as) text

We have an asp.net application that was working fine on Windows 2003 /
SQL server 2000.  When one of our servers was upgraded to SQL 2005 we
noticed that some of the stored procedures were causing the
application to time out.  The SPs run within 2 seconds directly within

The collation default was set up incorrectly on our server.  I want to change
the server default.  
I found this command in the BOL.
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine

I'd like to get an expect opinion about the writing style for the SP. Here
is the point. I was always writing the SPs caching the temporary data myself
using the variable tables located in RAM and it was working just great. The
SP written in this way is readable, easily ...

I'm using sql 2000 version   had  zip column as nvarchar  datetype in various
tables . How to generate random zip  data for these tables.
Thanks in advance

Last night I attempted to move the model database on a SS 2000 SP4 server.  I
carefully followed the instructions in the kb article and did, for example,
the -c -m -T3608 switch (or whatever it was) and stopping/restarting
services, etc.  But when I did it, I got the standard ...

I am using a bit map for role ids.  Here is the “bitwise and” relation used
on some of the application’s queries:
    users.role_id & roles.id <>0
user.role_id is the foreign key and roles.id is the primary key.

I have a database that was developed with sql server 2005. I have a client
with sql 2000. Is there any way I can apply this database to the sql 2000?
All of the datatypes are the same. Can I use the scripting of the database
and then run that scripting in the sql server 2000 ...

I am comparing the performance of CTEs and their equivalent single reads.  the SQL in the join only returns the 3 rows
but 3 rows divided by 6 reads is 2 reads a piece (which is what it is one at a time).  The dbo.FullCriteria(2168) UDF
(which is shown below) only returns 11 rows ...

How do I display int fields in hex or octal in Query Analyser (SQL Server
2000)?
Been looking at a CONVERT, CAST and Maths functions in Books online.
Drawn a blank.

How can I have sql server send an email to someone every time a change
(edit/delete record) made in a table?

We have a SQL Server 2005 database that has an Oracle linked server
defined.  For that linked server, we are mapping all logins to a
single Oracle login.  We have a SQL Server view that uses OPENQUERY to
pull back the Oracle data.  That view is being referenced in a

hey all,
job history table
--------------
from_date, to_date, job_position