شماره ۲: مفاهیم اولیه کوئرینویسی
نام آبجکت در کوئری باید داخل ' ' قرار بگیره (متفاوت با 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