Well, this is not a comment on the artcle.

But why do I see this as today's headline on the homepage when it is obviously from June?

Cheers,

Frank

Hi kingram2000,

quote:

---

i have a DB with a MS-Access 2k front end, been running fine for the past year, now i am having...

hi Patrick,

quote:

---

Same here. They have a multitude of projects and no App DBA. So I've been doing the job for the past...

quote:

---

Tonight

---

ooh, I see, in this case....

Cheers,

Frank

quote:

---

PS. Can I use a copy of your standards when it's complete?

---

kind of a lazybone...

quote:

---

Thanks a lot !

---

get several cups of coffee, when you print those thousands of pages...

Hi Surjit,

quote:

---

Thats right when u select distinct...when i query only select...then it should display all records..i need all records for my application...

quote:

---

I woul like to do that, unfortunately, I am behind exchange server and hence cannot post any code here. I will try...

Hi Surjit,

quote:

---

select name from user_table where id_user in (5,25,5)

when i run the above query in query analayser in SQL Server 2000 i...

quote:

---

Yes that's correct,but my query is bit complicated and I cannot use desc or asc.Nevertheless I am use 2 different queries to...

Hi Jacobe,

quote:

---

Like top 5, is there something called bottom 5 to fetch the lowest 5?

---

to...

quote:

---

Hello Mark

I tried with another query which is as follows

SELECT TOP 5 *

FROM ...

Hi haremeher,

quote:

---

How can i optimise stored procedures in all ways.

---

what so you mean by 'optimise'?

With...

Hi vivian123,

quote:

---

Do DBAs out there follow their own, home brewed standards? Is there a Database equivalent of the Hungarian notation or Pascal...

Hi hbkdba,

quote:

---

Are the ANSI SQL specs ('92, '99) available for download ?

---

yes, they are!

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13985

Cheers,

Frank