Frågan#1
denna kod funkar i query analyzer men jag får inte spara den som en sp, varför?
får felmess: Error 7405: heterogeneous queries required the ansi_nulls and ansi_warnings option to be set for the connection....
Delete From tblProducts
Insert Into tblProducts (Supplierid, Suppliername, Articleid, Productname, Notes, Price)
(SELECT Supplierid, Suppliername, Articleid, Productname, Cast(Notes as varchar(2000)), Price FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0','d:\db\products.mdb';'admin';'',[tblProducts]))