sqlserver數(shù)據(jù)庫入門(完整版)
【正文】 [dep_name] [char] (10) NULL ,[dep_no1] [char] (4) NULL ,[dep_name1] [char] (10) NULL ,[dep_bld_date] [datetime] NULL ,[dep_vendor_shared] [smallint] NULL ,[dep_telno] [char] (20) NULL ) ON [PRIMARY]GOl drop tabledrop table [dbo].[bse_department]GO2/27/2023 23數(shù)據(jù)庫入門更改數(shù)據(jù)l Insert INSERT INTO bse_department (dep_no, dep_name) VALUES ( ‘KFB’, ‘開發(fā)部 ’ ) GOl Update:UPDATE bse_department SET dep_name = ‘development’ WHERE dep_no = ‘KFB’GOl Delete Delete from bse_department WHERE dep_no = ‘KFB’2/27/2023 24數(shù)據(jù)庫入門簡單查詢l Select 列名 ,… from 表 …Where 條件 …SELECT * FROM bse_department WHERE (dep_tycode = 39。l 靈活使用游 (cursor)標并發(fā)選項，如樂觀并發(fā)(OPTIMISTIC )l 在事務中，盡量訪問最小量數(shù)據(jù)，減少鎖定數(shù)據(jù)行數(shù)。)l 查詢統(tǒng)計：SELECT dep_no AS 部門編號 , COUNT(*) AS 部門人數(shù)FROM bse_employeeGROUP BY dep_no2/27/2023 25數(shù)據(jù)庫入門聯(lián)合查詢l 聯(lián)合查詢 JOIN ( INNER, LEFT, RIGHT )SELECT , COUNT(*) AS 部門人數(shù)FROM bse_employee INNER JOIN bse_department ON = GROUP BY , 2/27/2023 26數(shù)據(jù)庫入門聚合函數(shù)l SUM ( …)l AVG( …)l COUNT(…)l MAX(…)l MIN(…)Select COUNT( *) from table1 Select sum( column1) from table22/27/2023 27數(shù)據(jù)庫入門結(jié)果集組合l UNIONSelect * from tableAUNIONSelect * from tableBUNIONSelect * from tableC l Note: 結(jié)果集結(jié)構(gòu)必須相同。Database=northwind // VB –2 = sqloledb“ ProvStr = Server=MyServer。連接 Access// Profile Access = ODBC = False = ConnectString=39。2. 設置控制某些行為的選項3. 執(zhí)行 Transact
環(huán)評公示相關推薦
鄂ICP備17016276號-1