March 17, 2008 at 6:31 pm
Hello Experts
Where can i get the Manual for SQL for SQL Server 2005? I need to find out the equivalent of oracle stuff like
1. select * from
(select columns here where ..ORDER BY my_col DESC)
where rownum < 11
2. select column from table/view where create_date like { date functions here }
TIA
March 17, 2008 at 8:21 pm
It's called "SQL Server Books Online".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 18, 2008 at 8:14 am
Check out this link:
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
-- You can't be late until you show up.
April 7, 2008 at 11:55 pm
Finally i came across this link which i found useful. Thought i will share this with the forum.
http://www.sqljunkies.com/Article/4E65FA2D-F1FE-4C29-BF4F-543AB384AFBB.scuk
Thanks for all the suggestions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply