I don't have SQL Server available as I write this but my approach would be to do a DATEDIFF between a fixed date in the future and your time col...

I seem to remember that there was a thread about it once before but can't find it now.

The E is something to do with powers of 10. 1E1 =...

Basically NVARCHAR is a double-byte version of VARCHAR.

Some procedures demand that an NVARCHAR is passed and sp_executesql is one of them

If you run

sp_executesql 'SELECT * from sales'

you get an error...

SmallDateTime stores date/time value accurate to the minute

DateTime stores date time values accurate to 3 milliseconds.

exec sp_changedbowner '<>'

Putting your code in stored procs is best practice.

Putting your SELECT DISTINCT into CommandText means that you have to grant read access to your table therefore someone with a valid...

Create a temporary table that holds the extracted IP Address from MT then do an inner join between status and your temp table

ADO tutorial

If you are using ADO to connect to the database have a look at the ADO Stream object.

If you are using .NET use a file stream and Binary reader...

I believe that SQL Clustering has a limit on the number of nodes but assume a server per node plus some form of centralised storage that is available to all...

Well you are likely to get more than one "Chris Smith" as well as more than one "Chris" and more than one "Smith".

ALTER TABLE dbo.MyTable

ADD CONSTRAINT unq_MyTable UNIQUE (FirstName,LastName)

If I get a vague definition of what an update on a table is supposed to do I carry out something similar to the SQL below:

CREATE PROC dbo.setTable @id Int,...

I wish that the editorial was included in the home page of the site.

It adds a bit of variety and is a reminder that there is a human...

If all your tables have a clustered index then

SELECT object_name(id),SUM(rows)

FROM sysindexes

WHERE indid=1

GROUP BY object_name(id)

WITH ROLLUP

indid=1 is the clustered index

I don't have BOL to hand but I seem to remember that you can do something like SELECT @@SERVERNAME