All geek questions in one place

Is SQL Server Express ANSI compatible?

Can you run ANSI SQL statements in SQL Server Express 2005 or 2008?

+3
source share
3 answers

Sql server understands Ansi Sql. However, there are always different interpretations of the standards. Here's an article in which I found that lists some of the differences: Think that ANSI Standard SQL is fully migrated between databases? Think again.

+3
source

SQL Server , SQL- ANSII, T-SQL SQL Server. ANSII , , , , . , .

, ANSII , . , , , , . , . .

+1

ANSI. , ||, + SQL Server.

, , .

( , ) ANSI, :

  • / ANSI (DATE '2012-08-28', TIMESTAMP '2012-08-28 17:33:05')
  • VALUES ( INSERT)
  • (col1, col2) = (1,2)
  • NULLS FIRST/LAST ORDER BY

T-SQL.

SQL - , SQL, .

() - , .

, , .

You paid a lot of money for all the features of SQL Server (or not so much for SQL Server Express), so keep that in mind.

+1
source

Source: https://habr.com/ru/post/1722532/

More articles:


All Articles