For a detailed analysis of the various methods see http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=243877#bm245300

For a column MyTs, the fastest method is:

CAST( CAST( ( MyTs - 0.5 ) as integer ) as datetime )

The various...

"i just want to know how to run the tool in my sql statement"

Quote from Joe Celko:

Q: What is the best kind of rock to drive in wood screws.

A:...

"has anyone used the Unix2Dos utility? "

Yes.

Note that the fact that the file originates on a UNIX server is important but the fact that server is running Oracle is not...

Please provide DDL and sample data.

See http://www.aspfaq.com/etiquette.asp?id=5006

Try this:

CREATE TRIGGER dbactivity_t_ia ON dbactivity FOR INSERT

as

set nocount on

set xact_abort on

IF 0 = ( select count(*) from inserted) RETURN

insert into intstamp

(ints_serial,ints_type,ints_id,ints_id_table

,ints_date,ints_time,ints_action,ints_message

,ints_seq,ints_error)

select 0,...

There is a solution that is described in Joe Celko's book "Trees and Hierarchies in SQL for Smarties"

ISBN-13: 978-1558609204

http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/1558609202/ref=sr_1_5/002-5405555-1788044?ie=UTF8&s=books&qid=1177533429&sr=1-5

set nocount on

set xact_abort on

go

if object_id('tempdb..#temp') is not null drop table...

"where's the error check and rollback code that should go with it?"

add at the beginning:

set xact_abort on

The #Sample is for demonstration purposes only but when it is a base table, ANY reordering process does not work should any other connection perform an insert, update or delete...

The physically most efficient solution is to use a temporary table with an identity column to be new sort order.

IF OBJECT_ID('tempdb..#Sample') is not null drop table #Sample

IF OBJECT_ID('tempdb..#OrderNew') is not...

If you use the system tables, then the SQL will NOT be usable with SQL Server 2005.

Instead use the ISO metadata view named INFORMATION_SCHEMA.COLUMNS, which works for 2000 and...

under SQL Query Analyzer, run

exec masteer.dbo.sp_helpfile

In the result, does the file name column look like this(two slashes) ?

M:\MSSQL\Data\\master.mdf

If so, then when SQL server was installed, the directory for the system...

Began getting the same messsage in early March of 2007 and the error has been occuring about once a week when the cluster keep-alive process has been restarting SQL Server....

The section "WHERE (p.ActualHold > b.LowerLimit) AND (p.ActualHold b.LowerLimit) AND (p.ActualHold < b.UpperLimit)

To create objects that will be owned by a different user, the database role db_ddladmin must be granted. To restrict what objects can be created, you may deny a...

For SQL Server 2000 and 2005, here is a SQL batch that inlcudes supports for named instances. It has been tested when SQL Server is running on a cluster...