The only clue to the right answer was the phrase "regardless of viewing software", and I got it right.

Of course, there aren't many options for either PDF or...

That is a major limitation and one that will frustrate developers but will give DBAs and sys admins reasons to not allow debugging at all, at least on production machines.

I...

Both answers are wrong. This is a case where a third answer should be provided.

The default behavior indicates that the data, if smaller than 8 KB, would be stored...

Compatibility mode is only a small fraction of the problem. The indicated answer is _so_ wrong. Only the SQL Server 2005 instances can be consolidated with any confidence.

There...

It is interesting to note that this ability may be removed in later releases. The referenced page says:

"The placement scheme of assemblies in application domains is designed primarily to achieve...

Everyone... Remember, pick the "best" answer.

".999..." is clearly closer to ".84..." than the other answers so it is best and the only correct answer.

I think all that is required is that the flag is set or the row id matches the one given.

AND (@EMPID = 999 OR EMPID = @EMPID)

--Peter

OK.

Remember just remember that PL/SQL != SQL*Plus != T-SQL.

The fact that MS SQL Server has one language/environment vs Oracle's two environments leads to confusion when going...

For TOAD, you can use this syntax and TOAD will prompt you every time for the value of CATEGORYID. If you use a _single_ ampersand, TOAD will reuse a...

cneuhold,

Thanks for clarifying. It really seems to me that the T-SQL language is not mature and can't match other compiled languages or PL/SQL.

If you could elaborate a little more on your goal, I might offer more specific advice or scripting examples.

I made the transition from Oracle to SQL Server and had...

Anonymous blocks allow you to imbed PL/SQL, including its variables, but that won't get you the results of the query. They have to be assigned to another variable, but...

In TOAD query window, enter the following:

SELECT * FROM Products WHERE CategoryID = 8

You can right click on upper left corner of results window and use Save As to export...

Use something like the following to generate the list of employee names:

SELECT employeeName, 1 orderby FROM employees

UNION

SELECT '-- All Employees --' employeeName, 999 orderby

ORDER BY orderby DESC, employeeName

--Peter

How is the transfer designed in DTS?

I suspect that it may have something to do with unique constraints (PKs) or something similar and that SQL Server wants to...