Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 T-SQL queries...

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-06-22 : 12:26:00
Is there a site where can i get the list of T-sql queries ...just to check my t-sql knowledge?

------------------------
I think, therefore I am

nr
SQLTeam MVY

12543 Posts

Posted - 2004-06-22 : 12:29:55
????
Bol gives the syntax.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-22 : 12:50:03
quote:
Originally posted by ravilobo

list of T-sql queries


What list?

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-06-22 : 13:00:37


http://weblogs.sqlteam.com/





Brett

8-)
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-06-23 : 05:30:40
I am looking for sql query questions like....

1>how to find the nth highest in a table?
2>How to delete the duplicate records?
3>How to select random records from a table?


..these kind of queries are asked in the interviews....(I know the answer for above queries) ...
Is there a centralised place where i can look for these kind of queries...

If i want anything on DTS i noramlly look in www.sqldts.com Is there a similar place for t-sql queries..








------------------------
I think, therefore I am
Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2004-06-23 : 06:35:14
You could find most of those from doing a search of the forum here. I'd suggest though that you'd be better off concentrating on the general rather than the specific.

-------
Moo. :)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-06-23 : 11:56:11
I'd suggest going through the articles here on SQLTeam. Just go to the main page and look under Topics section on the left.

Tara
Go to Top of Page

kselvia
Aged Yak Warrior

526 Posts

Posted - 2004-06-23 : 17:19:37
This is a pretty good list: http://www.umachandar.com/technical/SQL6x70Scripts/main.htm
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2004-06-24 : 02:40:00
quote:
Originally posted by kselvia

This is a pretty good list: http://www.umachandar.com/technical/SQL6x70Scripts/main.htm




Thanks a lot !!! Thats what i wal looking for.....

------------------------
I think, therefore I am
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-06-24 : 04:53:38
Books any good? Celeko's "SQL for Smarties", for example? Others recommend the Guru range, but Amazon hasn't delivered my copies yet, so I don't know about them ... yet

Kristen
Go to Top of Page
   

- Advertisement -