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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy