Viewing 15 posts - 886 through 900 (of 1,131 total)
Do only Agents with codes begining with 13, 17 and 19 have sub-agents? (or was this just an example?).
If all agents may have subagents, then this SQL comparison might be...
SQL = Scarcely Qualifies as a Language
November 14, 2005 at 6:59 pm
Actually, is this case only, the two SQL statements are logically equivalant and would produce identical results.
The join criteria is "ON hst.InvID = inv.InvID" and since nulls = null evaluates...
SQL = Scarcely Qualifies as a Language
November 14, 2005 at 3:45 pm
Local temporary tables are visible only to the creating session but global temporary tables are visible to all sessions.
To create a global temporary table, prefix the table name with two...
SQL = Scarcely Qualifies as a Language
November 14, 2005 at 2:28 pm
Did I miss something, or are we not in the twenty-first century?
Here is my opinion on "Who were the top ten people of the twentieth century to have influenced the...
SQL = Scarcely Qualifies as a Language
November 14, 2005 at 2:21 pm
Just curious as to why you are trying to save the password of generic administrative SQL logins. The auditors will not be happy that generic accounts with known passwords...
SQL = Scarcely Qualifies as a Language
November 14, 2005 at 10:25 am
For the case when the same user has more than one row that has the same high score that is the greatest, then the comment to be return will be...
SQL = Scarcely Qualifies as a Language
November 13, 2005 at 5:10 pm
Your SQL attempts are very close.
As all SQL statements have "input" of a set and the "output" is always a set, this set can be used just as...
SQL = Scarcely Qualifies as a Language
November 12, 2005 at 9:41 am
Are either of the servers Windows 2003 or even Windows XP?
MS made some security changes with 2003 and requires that you create registry values for all XA DLLs that you...
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 2:36 pm
The SQL Server login for a connection can be determined from the system function
SUSER_SNAME()
Of course, if this is a multi-tier application where the application always connects using the...
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 11:00 am
Sorry, you are correct but there are workarounds.
See "How can I fix a corruption in a system table? " at http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=14051&DisplayTab=Article
As the stored procedure sp_fixindex will check to confirm that...
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 9:46 am
You could try, but then run checkdb again.
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 9:16 am
No, you master database has significant corruption and "allow data loss" could mean such things as logins, security rights or user databases "disappearing".
First, make a backup of the master database.
Second,...
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 8:55 am
From Books OnLine:
Comparison Operators
Comparison operators test whether or not two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image...
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 5:49 am
Your original question:
And your follow up:
Let me be perfectly clear:
THIS CANNOT BE DONE AS THIS INFORMATION IS NOT STORED INSIDE OF SQL SERVER.
This information is only stored in the Windows...
SQL = Scarcely Qualifies as a Language
November 11, 2005 at 4:57 am
I re-read the original message and determined that the data has a hidden constraint that for a customer, the values for date_ran must be consisten for all pools.
This can only...
SQL = Scarcely Qualifies as a Language
November 10, 2005 at 6:55 am
Viewing 15 posts - 886 through 900 (of 1,131 total)