What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 137 Stack Exchange communities.

I ask simply because I found this and assumed it was a MSSQL question, yet the answer is seemingly Oracle Specific. No?

http://stackoverflow.com/questions/1027387/limited-t-sql-join

share

migration rejected from stackoverflow.com Jan 2 at 21:16

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Roombatron5000, ɥʇǝS, Lance Roberts, Martijn Pieters, gnat Jan 2 at 21:16

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question pertains only to a specific site in the Stack Exchange Network. Questions on Meta Stack Exchange should pertain to our network or software that drives it as a whole, within the guidelines defined in the help center. You should ask this question on the meta site where your concern originated." – Roombatron5000, ɥʇǝS, Lance Roberts, Martijn Pieters, gnat
If this question can be reworded to fit the rules in the help center, please edit the question.

2  
Sql Server has a 'with' clause starting with version 2005. –  Joel Coehoorn Sep 16 '09 at 19:14
    
And this belongs on meta. –  Joel Coehoorn Sep 16 '09 at 19:14
    
Thanks.. Never saw it implemented that way. –  user135988 Sep 16 '09 at 19:23

3 Answers 3

  • Yes, sql-server refers specifically to ms sql server
  • Sometimes people are dumb about tags anyway
  • Sometimes an expert in one tag will watch other similar tags and try to be helpful
  • In this case, Sql Server has had a "With" clause — called common table expressions (CTE) — since the 2005 version.
share

The tag "sql-server" implies Microsoft SQL Sever (MSSQL).

The answer in question is correct. Common Table Expressions (CTEs) were introduced in SQL Server 2005, making that syntax perfectly fine and not specific to Oracle at all.

share

T-SQL is the language used by SQL Server. SQL Server is a Microsoft product also called MSSQL

share
1  
The vendor of the product does not call it "MSSQL". Also, "MSSQL" can be confused with "MySQL", so I suggest it not be used. –  John Saunders Sep 16 '09 at 20:50

Not the answer you're looking for? Browse other questions tagged .