alter procedure [dbo].[p_Products_InsertNew]@ProductsName varchar(20),@TypeID int,@BrandID int,@Color varchar(20),@Weight varchar(20),@Spec varchar(20),@Cost money,@ProductsUints varchar(20),@Material varchar(20),@UpperLimit int,@LowerLimit int,@BeginEnterDate varchar(20),@FinalEnterDate varchar(20),@LatelyOFSDate varchar(20),@UnshelveDate varchar(20),@LoadingDate varchar(20),@Description varchar(200),@Price money,@ProductsCode varchar(50),@ProductsBarCode varchar(50)asdeclare @Num intinsert into t_Products(ProductsName,TypeID,BrandID,Color,Weight,Spec,Cost,ProductsUints,Material,UpperLimit,LowerLimit,BeginEnterDate,FinalEnterDate,LatelyOFSDate,UnshelveDate,LoadingDate,[Description],Price,ProductsCode,ProductsBarCode)values(@ProductsName,@TypeID,@BrandID,@Color,@Weight,@Spec,@Cost,@ProductsUints,@Material,@UpperLimit,@LowerLimit,@BeginEnterDate,@FinalEnterDate,@LatelyOFSDate,@UnshelveDate,@LoadingDate,@Description,@Price,@ProductsCode,@ProductsBarCode),
插入语句不是insert into表名()values()吗?select可以吗?
追答可呀啊
你可以试一试
还是不对,报同样的错误
追答哦,我写错 了应该是
insert 表名
select