SQLServer2005插入資料的問題? - 手錶

By Ursula
at 2009-06-10T00:00
at 2009-06-10T00:00
Table of Contents
這是我用sqlserver2005打的但是出現了錯誤但我不知道是哪個地方錯了Createtable手錶(IDvarchar(50)notnull,錶面varchar(50),機芯varchar(50),錶帶材質varchar(50),價格varchar(50),picimage,primarykey(ID),);Createtable廠牌(IDvarchar(50)notnull,廠牌varchar,primarykey(廠牌),foreignkey(ID)references手錶(ID)ONDELETECASCADEONUPDATECASCADE);Createtable功能(IDvarchar(50)notnull,防水varchar(50),鬧鈴varchar(10),碼錶計時varchar(10)primarykey(ID),foreignkey(ID)references手錶(ID)ONDELETECASCADEONUPDATECASCADE);InsertInto手錶(ID,錶面,機芯,錶帶材質,價格,pic)Select'BL9000-32A'AsID,'藍寶石水晶玻璃,不鏽鋼錶殼'As錶面,'原廠機芯G900'As機芯,'真皮'As錶帶材質,'17200'As價格,*FromOpenRowSet(BulkN'C:\DocumentsandSettings\TsungHan\MyDocuments\project\001.jpg',Single_Blob)Aspic;InsertInto廠牌Values('BL9000-32A','Citizen');InsertInto功能Values('BL9000-32A','日常生活防水','2組鬧鈴','無');錯誤的訊息是訊息207,層級16,狀態1,行33無效的資料行名稱'價格'。訊息207,層級16,狀態1,行33無效的資料行名稱'pic'。...Showmore
Tags:
手錶
All Comments

By Jessica
at 2009-06-14T08:14
at 2009-06-14T08:14