How are you trying to delete it? And is this SQL Server 2000 or 2005?

-SQLBill

Do your best to NEVER use Enterprise Manager to make schema changes. It tends to CREATE and copy from old to new, drop old and rename new. A...

What's the difference from the way it used to be? DATEDIFF never took care of DST. Remember, not everyone or every country uses Daylight Savings Time. For example: Arizona...

It is still a visit regardless of who visits. Yes, it would be nice if they didn't count the post's originator, but there are more important things for them to...

Most likely the problem is that your last restore was done using WITH NORECOVERY. To fix this, just run this...(replace dbname with the real database name)

RESTORE DATABASE dbname WITH RECOVERY.

-SQLBill

You have the right idea. Look up BACKUP LOG in the Books OnLine. That's where you will see all the syntax options and examples.

-SQLBill

Yes, but why? Both of those will give the same value because you are counting all rows (COUNT(*)) both times.

And also, what are you trying to do?

Providing the table structure,...

I don't think there is anything that does it automatically. After you make a change, you can right click on the table, select All Tasks > Generate SQL Script. But...

One BIG problem is that this isn't a SQL site, it's a site for Microsoft SQL Server. JET SQL (Access) and Transact-SQL (SQL Server) are not the same thing. The...

If I understand correctly, you need to do something like this:

SELECT 'a' + list.b

FROM (SELECT 'b'

FROM tablename) list

Notice...

Have you run them both? I'll guess that they won't give you the same data.

The WHEREs aren't looking for the same data.

This is the first where:

WHERE orderNumber=@ordernumber AND

...

This would not be something that is done in SQL Server. You would use your front-end (presentation) to format the data returned by the query.

-SQLBill

It's all in how it's being used:

1st script:

This is a good statement, list.a exists in the statement.

(SELECT 'a'+list.a)='aa')

FROM (SELECT 'a' as a) as list

2nd Script:

This is a bad statement....

Why would it need it? SQL Server gets its time from the server.

-SQLBill

It's real frustrating. I can understand the time out issue and I type long responses in notepad and then copy it over. But this is in no way...