Viewing 15 posts - 421 through 435 (of 529 total)
...if you explicitly use the JOIN keyword, you cannot leave out the ON clause.
/Hans
July 24, 2003 at 2:21 am
AnzioBake:
quote:
Often when using exists or in subqueries I use the "top 1" in the select so query eecution stops of...
July 22, 2003 at 5:24 am
Hi! I would say that EXISTS is not always better then IN. Ok, BOL says they are semantically equal but that does not mean they are the same performance wise...
BOL...
July 22, 2003 at 2:40 am
Hi!
Try the T-SQL command 'SET ROWCOUNT 100' on all your connections and you never get more then 100 rows when doing your SELECTs. Though it still has to be executed...
July 22, 2003 at 1:58 am
Hello Frank!
Some extra time had to be spent in office 🙁
quote:
but in how many cases does a login have no permissions...
July 17, 2003 at 9:28 am
Hi Frank!
Sorry if I'm disagreeing abit. This thing about not beeing able to do anything without a login is true. But if you have a login and no permissions (implicit...
July 17, 2003 at 8:46 am
Hi!
Frank, how do you mean?
Brian: No, I did not add my Test user to master. I let it rely on the Guest priveleges. Adding Guest to the db_denydatareader role, makes...
July 16, 2003 at 8:39 am
Hello Frank and Brian!
quote:
'put Guest into DB_Role db_denydatareader'And => this login still has access to master.
July 16, 2003 at 8:03 am
Hello Frank!
Well, wording is everything 😉 You have to know all relevant prerequists before you can answer in a correct way.
Maybe we should start with the topic name 'poor Question...
July 16, 2003 at 6:29 am
Frank:
quote:
Learn it the way they (whoever they are) want it to and don't spent too much time thinking about...
July 16, 2003 at 2:19 am
I agree exactly what ChrisLeonard said and if I could, I would have said the same thing. Thanks for expressing my feelings in a discussion based way...
Regards, Hans!
Edited by -...
July 15, 2003 at 3:21 am
I agree with MvG (no rhyme intended 😉
The CASE (or rather ISNULL) is the only way to solve your ORDER xx ASC with your NULLS in the end.
/Hans
July 14, 2003 at 4:13 am
Hi.
Just out of curiosity, I would like a clarification of 'You need to have permissions to any database on the server.' Does that mean you need to have access to...
July 14, 2003 at 2:16 am
BTW Do try to keep your DATE questions to one topic...
July 13, 2003 at 11:40 am
BOL:
quote:
DATEDIFFReturns the number of date and time boundaries crossed between two specified dates.
Syntax:
DATEDIFF ( datepart , startdate , enddate...
July 13, 2003 at 11:38 am
Viewing 15 posts - 421 through 435 (of 529 total)