Is there a better way of doing this:
SELECT * FROM PreGXSurvey
 WHERE dtsurvey BETWEEN
 CONVERT(DATETIME, '9/25/06', 1)

is there a sql update query or similar that I could type out and run on the
fly somehow that would populate a specific field in all of the records of a
table with the same value? Thx

I'm running SQL2000 Standard on a 2003 standard server.
I want to upgrade to 2005. I have about a half dozen small databases on
the system with very basic table structure and maybe 20 very basic
stored procedures (select and insert procedures).

I have 3 tables:
Telbook(Id:int,Name:char,address:char,comment:ntext,owneruserid:int),
PK:id
TelNumbers(telbookid:int,telno:char,telNotype:int,syscode:int),PK:syscode,F­K:telNumbers.telbookid=telbook.id

When using the MS SQL 2005 JDBC driver, I now need to have the DNS name
resolution to the client correctly set up. If not I get the following
error:
SQLState: 08S01

I'm using Bulk Insert for the first time and have a question.
I'm getting an error message about a field being  truncated:
Bulk insert data conversion error (truncation) for row 2, column 12
(Depleted)

I have SQLServer 2005 dev edition loaded on a windowsXP Pro machine.
I installed it ok. I just attempted to load the Personal Web Site Starter
Kit that comes with VStudio 2005 -- it loaded ok, but when I went to view
the default.aspx page I got this error:

I am seeing intermittent blocking problems. The strange part of it is,
that the SPID listed in the Blk By column is the same as the SPID that
is being blocked.
Has anyone seen this before, or have any idea what this may suggest?

Can someone help me use the Replace function properly?
I try this:
SELECT REPLACE('<br />','<br />','vbCrLf'), * FROM Peart3Log
This returns all the records, but includes a 'no name' column filled

please, how to promt user in mu sql 2005 script? For example, I need user to
confirm some operations.. .
Thx in advance

How to dynamically find out and store the logical datafile and logfile name
from a backup file of a database so that the restore statement of the
database could be generated at run time.
Gouri

I have to prepare an ER diagram for the objects in my SQL Server
database. I have used the option "DIAGRAMS" in EnterPrise Manager of
SQL Server 2000. It is creating the diagram for the selected tables
(but the diagram contains only the table which i have selected. It is

please help newbie
I need to create a lot of objects the same type (let's say: schemas)
I wish to use paramerized block in loop to do so.
- how to put names of my objects to such control-flow?

I am moving an Access db to SQL as a 'project'.  How can I replicate
Access's Primary key generation in SQL 2000?
Example:  EmployeeID, TestID, TransactionID that all have unique primary key
numbers that are auto-generated?

I have just installed SQL 2005, SP1 server on two test computers and am
trying to get database mirroring to work. No witness server is being
used. I have done a FULL backup of the database and backed up the
transaction log.  I have also restored the database and the transaction