SQL \u0645\u062e\u0641\u0641 \u06a9\u0644\u0645\u0627\u062a Structured Query language \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0628\u06cc\u0634\u062a\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u062f\u0633\u062a\u0648\u0631\u0627\u062a sql \u062f\u0631 sql server \u060c SQL Server Management Studio \u0648 sqlcmd \u0642\u0627\u0628\u0644 \u0627\u062c\u0631\u0627 \u0634\u062f\u0646 \u0647\u0633\u062a\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0647 \u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a sql server \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u06cc\u0645. \u0628\u0627 \u0645\u0627 \u0647\u0645\u0631\u0627\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n
\u062f\u0633\u062a\u0648\u0631\u0627\u062a SQl \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u00a0MS Access, Paradox, DB2, Informix, MS SQL Server, My SQL, Oracle, Sybase \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u0634\u0648\u062f.<\/p>\n
\u0634\u06a9\u0644 \u06a9\u0644\u06cc \u062f\u0633\u062a\u0648\u0631:<\/p>\n
SELECT column_name(s) FROM table_name<\/p>\n
\u0634\u0631\u0637\u06cc \u06a9\u0631\u062f\u0646 \u062f\u0633\u062a\u0648\u0631 select \u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u0641\u0631\u0645\u0627\u0646 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f.\u0634\u06a9\u0644 \u06a9\u0644\u06cc \u062f\u0633\u062a\u0648\u0631 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a.<\/p>\n
SELECT column FROM table WHERE condition<\/p>\n
\u00a0\u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u0641\u06cc\u0644\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0686\u0646\u062f \u0645\u0642\u062f\u0627\u0631 \u062d\u0627\u0635 \u0627\u0632 \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n
\u0632\u0645\u0627\u0646\u06cc\u06a9\u0647 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0646\u0645\u0627\u06cc\u0634 \u062a\u0645\u0627\u0645\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0647\u0633\u062a\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u062d\u0631\u0641 \u0645\u0634\u062e\u0635\u06cc \u0622\u063a\u0627\u0632 \u0645\u06cc \u0634\u0648\u0646\u062f \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n
\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0646\u0627\u0645 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n
\u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u0641\u0631\u0645\u0627\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u062c\u062f\u0648\u0644 \u0645\u062e\u062a\u0644\u0641 \u06a9\u0648\u0626\u0631\u06cc \u06af\u0631\u0641\u062a.<\/p>\n
\u00a0<\/strong>: LEFT JION \u2013 RIGHT JOIN – INNER JOIN<\/strong><\/p>\n \u00a0\u00a0\u0645\u0648\u0627\u0631\u062f join \u0634\u0627\u0645\u0644 \u060c : INNER JOIN , LEFT JOIN , RIGHT JOIN\u0645\u06cc \u0634\u0648\u062f<\/p>\n INNER JOIN : <\/strong><\/p>\n SELECT field1, field2, field3<\/p>\n FROM first_table<\/p>\n INNER JOIN second_table<\/p>\n ON first_table.keyfield = second_table.foreign_keyfield<\/p>\n :<\/strong>LEFT JOIN <\/strong><\/p>\n SELECT field1, field2, field3<\/p>\n FROM first_table<\/p>\n LEFT JOIN second_table<\/p>\n ON first_table.keyfield = second_table.foreign_keyfield<\/p>\n \u00a0RIGHT JOIN :<\/strong><\/p>\n SELECT field1, field2, field3<\/p>\n FROM first_table<\/p>\n RIGHT JOIN second_table<\/p>\n ON first_table.keyfield = second_table.foreign_keyfield<\/p>\n \u00a0\u0628\u0627 \u0631\u0648\u0634 \u0622\u0632\u0645\u0648\u0646 \u0648 \u062e\u0637\u0627 \u0648 \u0645\u062b\u0627\u0644\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0642\u06cc\u0642\u0627 \u0645\u062a\u0648\u062c\u0647 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u06a9\u0627\u0631 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0628\u0647 \u0686\u0647 \u0634\u06a9\u0644 \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n <\/p>\n \u06cc\u06a9\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0645\u0647\u0645 \u062f\u0631 sql \u0645\u06cc \u0628\u0627\u0634\u062f \u060c \u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u062c\u0647\u062a \u06cc\u0627\u0641\u062a\u0646 \u0641\u0636\u0627\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f :<\/p>\n \u0634\u06a9\u0644 \u06a9\u0644\u06cc \u062f\u0633\u062a\u0648\u0631:<\/p>\n SELECT Column FROM table WHERE column IS NULL<\/p>\n \u0627\u0632 \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a \u0628\u0631 \u0631\u0648\u06cc \u0641\u06cc\u0644\u062f\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n \u0628\u0631\u0627\u06cc \u06cc\u06a9\u06cc \u06a9\u0631\u062f\u0646 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0645\u062e\u062a\u0644\u0641 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f:<\/p>\n SELECT field FROM table1<\/p>\n UNION<\/p>\n SELECT field FROM table2<\/p>\n \u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0631\u0627 \u06af\u0631\u0648\u0647 \u0628\u0646\u062f\u06cc \u06a9\u0631\u062f.<\/p>\n ELECT column_name(s) \u00a0\u0632\u0645\u0627\u0646\u06cc\u00a0 \u062f\u0627\u062f\u0647 \u0647\u0627 \u06af\u0631\u0648\u0646 \u0628\u0646\u062f\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 where \u0646\u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u060c \u062f\u0633\u062a\u0648\u0631 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a having \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n SELECT column, aggregate function (column) FROM table<\/p>\n GROUP BY column<\/p>\n HAVING aggregate function (column) condition value<\/p>\n \u06cc\u06a9\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0647\u0645\u06cc\u0634\u0647 \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u0647\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f \u0648\u06cc\u0631\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0647\u0633\u062a \u06a9\u0647 \u0642\u0628\u0644\u0627 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 Update \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n UPDATE table_name<\/p>\n SET column_name = new_value<\/p>\n WHERE column_name = some_value<\/p>\n \u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc\u06cc \u0627\u0632 \u062c\u062f\u0648\u0644 \u0631\u0627 \u062d\u0630\u0641 \u0646\u0645\u0627\u06cc\u06cc\u062f :<\/p>\n DELETE FROM table_name<\/p>\n WHERE column_name = some_value<\/p>\n \u0628\u0631\u0627\u06cc \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u062f\u0631 \u0628\u0627\u0646\u06a9 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n \u062a\u0631\u06a9\u06cc\u0628\u06cc \u0627\u0632 \u062f\u0648 \u062f\u0633\u062a\u0648\u0631 Update \u0648 Insert \u0627\u0633\u062a.<\/p>\n \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 \u062f\u06cc\u06af\u0631\u06cc \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n SELECT column_name(s) INTO newtable [IN externaldatabase] FROM source<\/p>\n \u062f\u0633\u062a\u0648\u0631 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644<\/p>\n CREATE TABLE people ( <\/p>\n <\/p>\n \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u062c\u0647\u062a \u062a\u063a\u06cc\u06cc\u0631 \u0645\u062d\u062a\u0648\u0627\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f<\/p>\n ALTER TABLE table_name<\/p>\n ADD column_name datatype<\/p>\n \u0639\u0645\u0644\u06af\u0631\u0647\u0627\u06cc AND \u0648 OR \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 \u06cc\u06a9 \u0634\u0631\u0637 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f .<\/p>\n <\/p>\n \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0628\u0633\u062a\u0647 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u06cc tsql \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MSSQL \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f .<\/p>\n tsql -S your.server.com -p 1433 -U WINDOWS-SQL-USERNAME -P PASSWORD<\/p>\n \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MSSQL \u062f\u0631 \u0622\u062f\u0631\u0633 \u06f1\u06f9\u06f2.\u06f1\u06f6\u06f8.\u06f1.\u06f1\u06f0\u06f0 \u0628\u0627 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc user \u0648\u06a9\u0644\u0645\u0647 \u0639\u0628\u0648\u0631 password \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0639\u0645\u0644 \u06a9\u0646\u06cc\u062f .<\/p>\n tsql -S 192.168.1.100 -p 1433 -U user-P password<\/p>\n \u00a0\u0627\u06af\u0631 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0645\u0634\u06a9\u0644 \u062f\u0627\u0631\u06cc\u062f \u062d\u062a\u0645\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0647\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0627\u0632 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MSSQL \u0631\u0627\u00a0 \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0645\u0631\u0627\u062c\u0644 \u0632\u06cc\u0631 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f .<\/p>\n \u0627\u0628\u062a\u062f\u0627 \u0627\u0632 \u0645\u0633\u06cc\u0631 \u0646\u0635\u0628 MSSQL \u060c \u0628\u0633\u062a\u0647\u00a0 SQL Server Configuration Manager \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0631 \u0635\u0648\u0631\u062a \u063a\u06cc\u0631 \u0641\u0639\u0627\u0644 \u0628\u0648\u062f\u0646 \u067e\u0631\u0648\u062a\u06a9\u0644 TCP\/IP \u0622\u0646\u0631\u0627 enable \u06a9\u0646\u06cc\u062f\u00a0\u0648 \u0633\u0631\u0648\u06cc\u0633 SQL Server \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u062c\u062f\u062f \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0627\u0639\u0645\u0627\u0644 \u0634\u0648\u062f .<\/p>\n \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0628\u0631\u0627\u06cc \u06a9\u0633\u0628 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u0645\u0642\u0627\u0644\u0647 \u06cc \u067e\u0631\u0648\u0633\u06cc\u062c\u0631 \u0686\u06cc\u0633\u062a<\/strong><\/a> \u0631\u0627 \u0645\u0637\u0627\u0644\u0639\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n
IS NULL<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
Scalar function <\/strong>\u0648<\/strong> Aggregate Functions<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u00a0UNION<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u062f\u0633\u062a\u0648\u0631 group by \u062f\u0631 sql<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u062f\u0633\u062a\u0648\u0631 order by<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\nFROM table_name
\nORDER BY column_name(s) [ASC|DESC]\n\n
HAVING<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u062f\u0633\u062a\u0648\u0631 update \u062f\u0631 sql<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
DELETE<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
INSERT INTO<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u062f\u0633\u062a\u0648\u0631 Upsert<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
SELECT INTO<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u062f\u0633\u062a\u0648\u0631 Create Table<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\nname TEXT,
\nage, INTEGER,
\nPRIMARY KEY(name));<\/p>\n\u062f\u0633\u062a\u0648\u0631 alter table \u062f\u0631 sql<\/strong><\/h3>\n
\n
\u062f\u0633\u062a\u0648\u0631 \u0647\u0627\u06cc \u0639\u0645\u0644\u06af\u0631 AND \u0648 OR<\/strong><\/h3>\n<\/li>\n<\/ul>\n
\n
\u0646\u062d\u0648\u0647 \u06cc <\/strong>query<\/strong> \u0632\u062f\u0646 : <\/strong><\/h2>\n
\u0644\u06cc\u0633\u062a \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f <\/strong>Tsql<\/strong> \u062a\u0648\u0644\u06cc\u062f \u06a9\u0646\u0646\u062f\u00a0<\/strong><\/h2>\n
\n