sqlserver數(shù)據(jù)庫入門-wenkub
2023-03-14 15:49:07 本頁面
【正文】 ProfileString (gs_inifile, DATABASE, userid, dbo) = ProfileString (gs_inifile, DATABASE, dbpass, ) = ProfileString (gs_inifile, DATABASE, logid, sa) = ProfileString (gs_inifile, DATABASE, LogPassWord, ) = ProfileString (gs_inifile, DATABASE, ServerName, (local)) = ProfileString (gs_inifile, DATABASE, Dbparm, ) = FALSEconnect Using SQLCA。UID=。UID=。Uid=SA。 Trusted_Connection=yes provStr 2/27/2023 18數(shù)據(jù)庫入門獲取數(shù)據(jù) SQL語句String ls_empl_name // 變量定義Select empl_name INTO :ls_empl_name FROM bse_employee Where empl_no = ‘system’ Using SQLCA 。 // using SQLCA MessageBox(提示 ,保存時出錯 !) End if2/27/2023 20數(shù)據(jù)庫入門與數(shù)據(jù)庫連接 Datawindow2/27/2023 21數(shù)據(jù)庫入門TransactSQL 語言簡介l 標(biāo)示符： create Table employee ( empl_no char(10) PRIMARY KEY, empl_name varchar(20), age int default 0 , …. ）l 數(shù)據(jù)類型： l 函數(shù)：l 表達式： l 運算符：l 注釋l 關(guān)鍵字： 2/27/2023 22數(shù)據(jù)庫入門創(chuàng)建與刪除表l Create Table CREATE TABLE [dbo].[bse_department] ([dep_no] [varchar] (10) not NULL ,[dep_tycode] [char] (1) NULL ,[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ā)部 ’
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1