1 / 3

دستور Select

دستور Select. SELECT [ALL|DISTINCT] [TOP ( <expression> ) < column list > [FROM < source table(s)/view(s) >] [WHERE < restrictive condition >] [GROUP BY < column name or expression using a column in SELECT list >] [HAVING < restrictive condition based on the GROUP BY results >]

don
Download Presentation

دستور Select

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. دستور Select SELECT [ALL|DISTINCT] [TOP (<expression>) <column list> [FROM <source table(s)/view(s)>] [WHERE <restrictive condition>] [GROUP BY <column name or expression using a column in SELECT list>] [HAVING <restrictive condition based on the GROUP BY results>] [ORDER BY <column list>] [[FOR XML {RAW|AUTO|EXPLICIT|PATH [(<element>)]}[, XMLDATA][, ELEMENTS][, BINARY base 64]] [OPTION (<query hint>, [, ...n])]

  2. دستور CREATE DATABASE • CREATE DATABASE <database name> • [ON [PRIMARY] • ([NAME = <’logical file name’>,] • FILENAME = <’file name’> • [, SIZE = <size in kilobytes, megabytes, gigabytes, or terabytes>] • [, MAXSIZE = size in kilobytes, megabytes, gigabytes, or terabytes>] • [, FILEGROWTH = <kilobytes, megabytes, gigabytes, or terabytes|percentage>])] • [LOG ON • ([NAME = <’logical file name’>,] • FILENAME = <’file name’> • [, SIZE = <size in kilobytes, megabytes, gigabytes, or terabytes>] • [, MAXSIZE = size in kilobytes, megabytes, gigabytes, or terabytes>] • [, FILEGROWTH = <kilobytes, megabytes, gigabytes, or terabytes|percentage>])] • [ COLLATE <collation name> ] • [ FOR ATTACH [WITH <service broker>]| WITH DB_CHAINING • ON|OFF | TRUSTWORTHY ON|OFF] • [AS SNAPSHOT OF <source database name>][;]

  3. دستور CREATE TABLE • CREATE TABLE [database_name.[owner].]table_name • (<column name> <data type> • [[DEFAULT <constant expression>] • |[IDENTITY [(seed, increment) [NOT FOR REPLICATION]]]] • [ROWGUIDCOL] • [COLLATE <collation name>] • [NULL|NOT NULL] • [<column constraints>] • |[column_nameAS computed_column_expression] • |[<table_constraint>] • [,...n] • ) • [ON {<filegroup>|DEFAULT}] [TEXTIMAGE_ON {<filegroup>|DEFAULT}]

More Related