What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 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|improve this question

migrated from stackoverflow.com Sep 16 '09 at 19:14

This question came from our site for professional and enthusiast programmers.

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|improve this answer

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|improve this answer

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

share|improve this answer
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

You must log in to answer this question.

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