I have a field containing the date & time in the following format:
yyyymmddhhmmss
How can I convert this to a date format so I can run, for example, a select
query on anything within the last 24 hours?

I am using SQL Reporting Services v1 exclusively in a web reporting interface
and need to be able to select multiple search criteria.
EX: say my web report gives the capitols to each state in the union.  Right
now I have the capability to select either one state from a drop down ...

Hi, I'm currently using SQL Server 2000 SP3.
I'm facing some problems which make me think of a SQL Server BUG.
When executing a query, it seems that SQL Server tries to convert data
even if not in the resultset -> This leads to SQL Server error.

Apologies if this is not the correct place to put this.
I wrote this query to perform a fulltext search on tblPages.
SELECT * FROM tblPages,
FREETEXTTABLE(tblPages, *,@searchTerm) searchTable

Try hard to become familiar with T-SQL.
Can anybodey tell me the best way to deal with set's provided by a
stored procedure. Til yesterday I thougt trapping set in temp table
using INSERT EXEC is a way out of this, but then I struggeled with

I'm experiencing some very odd behavior in Enterprise Manager.
I have a process that performs the following:
1.) Restores a published database from Server A onto Server B. The
databases

hi all, I am considering what should be the best way of implementing
the following requirement.
I've got a SQL2K production server. Now I've got another machine as the
standby machine for this server

Is there any difference in the order of parameters in the where clause?
Does it add any speed to declare the least refined first or last?

Consider the following:
Example 1:
-----------------------------------------------------------------
CREATE PROC dbo.MyTestHere

I have two tables - Projects and ProjectStruct
Table Projects contains master records of the projects, ProjectStruct
allows to define a project herarchie and contains the fields
PrjStructId, ProjectId, PrjStructName, ..., ParentId

I want to copy all columns from tblA into tblB where tblA.UniqueID =
parameter @ID without having to list each column name in an insert
statement. Is this possible?
Thanks,

How is SQL useful in BPOs?  Is it worth working on it in a BPO for a fresher.
What other courses one should learn along with SQL to master database
management. How is it related to datamining and data warehousing?
Please help me.

i can t install sql 2005 beta 2 in my pc
it says .net frame work in corrupted or not installed but its running
properly in my computer.

Could someone please explain the pros/cons of installing the Veritas
SQL agent versus backing up the .bak file generated by SQL Server?  I
have worked with both setups in the past, but never really understood
what made one better than another.

one simple question, is there something like an extended error output
available for t-sql commands which fail?
e.g.
insert an string with a lenght of 5 in a column with varchar (3) throws an