Viewing 15 posts - 5,011 through 5,025 (of 7,636 total)
Jerry Hung (10/30/2008)
Interesting, but you can get by with the JOINSELECT * FROM Person.Person P
INNER JOIN (
SELECT FirstName = 'Jean'
) T ON P.FirstName = T.FirstName
COLLATE Latin1_General_CS_AS -- works
[/code]
This does not...
October 30, 2008 at 2:15 pm
jeanlibera (10/30/2008)
This query does not work:SELECT * FROM INT_AUX_LISTING
WHERE FIRST_NM IN ('Jean')
COLLATE Latin1_General_CS_AS
The error is:
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'COLLATE'.
Yes, because COLLATE can...
October 30, 2008 at 2:12 pm
Scott MacCready (10/30/2008)
Version B is the script you get from the 'script to' command in the SSMS GUI.
When embedded in the t-sql script, it fails.
When...
October 30, 2008 at 1:09 pm
I am between meetings here, but let me quickly call out three suggestions:
1) See my Blog (in my signature) or just downlaod this zip file: http://www.movingsql.com/dnn/LinkClick.aspx?fileticket=c7EJbXre%2fLg%3d&tabid=125&mid=461 which the...
October 30, 2008 at 12:26 pm
We cannot see the error from here. Could you please tell us what it is?
October 30, 2008 at 10:40 am
h.schlais (10/30/2008)
Should the END CONVERSATION be wrapped in an IF to avoid ending a conversation with a NULL handle ?
Well, if should be protected by an IF. I usually...
October 30, 2008 at 7:43 am
Suresh B. (10/30/2008)
Both versions report success in the messages tab when run. Nonetheless, the table survives.
Both versions reported report success does not mean they executed the DROP TABLE part. IF...
October 30, 2008 at 7:31 am
This should do it:
Select DepartmentId, Departmentname
From Department
Left Outer Join Employee ON Employee.DepartmentID = Department.DepartmentID
Where Employee.DepartmentID IS NULL
October 29, 2008 at 9:38 pm
naidussdba (10/29/2008)
I have to Display List all the departments that don’t have any employees(Without using sub query).
So why this unusual restriction?
October 29, 2008 at 9:32 pm
Jeff: just because they're not out to get you, doesn't mean that you can't be paranoid.
(p.s. This is "Humor" also.)
😀
October 29, 2008 at 9:07 pm
h.schlais (10/29/2008)
October 29, 2008 at 7:26 pm
Yes, but "Well-Formed" XML includes both Documents and Fragments.
If this is really important to you, I think that you could just test whether the first character is an "<" or...
October 29, 2008 at 3:14 pm
This is nice, but it is not what was asked for.
Here is a link that explains how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/.
Here are the things that would...
October 29, 2008 at 3:06 pm
Viewing 15 posts - 5,011 through 5,025 (of 7,636 total)