شماره ۲: مفاهیم اولیه کوئری‌نویسی

شماره ۲: مفاهیم اولیه کوئری‌نویسی

نام آبجکت در کوئری باید داخل ' ' قرار بگیره (متفاوت با T-SQL)

⚡️SQL Server:

- Single quotes ' ': Used for string literals.

- Double quotes " ": Used for delimited identifiers (e.g., to allow for spaces or reserved words as object names).

- Square brackets [ ]: Used for delimited identifiers, often preferred in SQL Server for objects that contain spaces or reserved keywords.

⚡️ PostgreSQL:

- Single quotes ' ': Used for string literals.

- Double quotes " ": Used for delimited identifiers. This is the only method to handle identifiers with special characters or reserved words.

- Square brackets [ ]: Not used or recognized in PostgreSQL for identifiers.

#MSSQL_to_PGSQL