You will not be able to run SQL Server from a CD without installing anything on the user's computer. What you can do -- but I suspect that is not...

See this article by SQL Server MVP Tibor Karaszi for an extensive explanation of the datetime datatype and how to solve problems like this one: http://www.karaszi.com/SQLServer/info_datetime.asp

This should give you an idea of how you can solve it. Execute in Northwind:

SELECT *

FROM dbo.Employees

WHERE Country =

CASE

WHEN Title LIKE 'Sales%' THEN 'UK'...

No, all of the instances would have to share 2GB of memory.

There are differences concerning read-ahead reads between Standard and Enterprise Edition (Ent Ed does not have a fix amount of pages for read-ahead). That could perhaps make this problem only...

Also see this very similar question: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=173078

SET will only allow the expression on the right hand side to assign one value to the variable.

If you use SELECT, the statement might return several rows and only the...

Very nice to hear this! A big congratulation to you Frank, you definately deserve it.

Keep up the great work!

I would definately recommend going with the unions. A logical union is not slow in any way, however the implementation requires a distinct operation to remove any duplicates. Like Bert...

They are used by the diagram editor in EM.

>select * from orders where orderdate >='19960704' and orderdate select * from orders where orderdate between '19960704' and '19960716'

>Compare the execution plans and watch how the BETWEEN is internally resolved...

The + operator simply concatenates the string literal(s) with the varchar (or similar string data type) data from the column firstname.

You can use this:

GRANT CREATE VIEW TO login_name

To solve this you could use the HOLDLOCK and XLOCK locking hints, and run the select and update in a transaction. You could also implement some optimistic concurrency handling this...

I would assume they should both work. However, I think the best place to ask is in the SQL Server 2005 beta newsgroups.

http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us