Viewing 5 posts - 16 through 20 (of 20 total)
To view the taskpad in EM, right click on a database, select view... taskpad.
November 30, 2003 at 5:13 pm
Use brackets in your where clause.
...
WHERE
(
tblProfile.Education = 'Some College'
OR tblProfile.Education = 'Associates Degree'
)
AND tblProfile.MemberIDpr = tblUsers.MemberID
...
November 30, 2003 at 5:08 pm
Have a look at this article...
http://www.sqlservercentral.com/columnists/hji/trace.asp
I have found it invaluable in identifying databases which are rarely used.
November 26, 2003 at 3:21 pm
Good question, I have also wondered about this.
I've always tried to avoid the use of "Select *" in any database queries. It's better to explicitly define what columns are...
September 25, 2003 at 11:22 pm
Chief, I agree. My first line in ALL my stored procedures is always SET NOCOUNT ON.
Nice tip on concatination Antares686/rmarda.
I prefer SET over SELECT. Basically an aesthetic choice.
March 3, 2003 at 3:41 pm
Viewing 5 posts - 16 through 20 (of 20 total)