[h2551996]

السلام عليكم
لدي هذي الاكودا
واريد اضافتها في امر واحد 
تظهر مشاكل
وعند الاضافة كل سطر منفصل 
لا يحدث مشكلة

كود :

ALTER TABLE [dbo].[Products]  WITH NOCHECK ADD  CONSTRAINT [FK_Products_Items_Group] FOREIGN KEY([MainGroup_ID]) REFERENCES [dbo].[Items_Group] ([Group_ID]) NOT FOR REPLICATION
ALTER TABLE [dbo].[Products] NOCHECK CONSTRAINT [FK_Products_Items_Group]
ALTER TABLE [dbo].[Products]  WITH NOCHECK ADD  CONSTRAINT [FK_Products_Items_SupGroup] FOREIGN KEY([SubGroup_ID]) REFERENCES [dbo].[Items_SupGroup] ([Group_ID]) NOT FOR REPLICATION
ALTER TABLE [dbo].[Products] NOCHECK CONSTRAINT [FK_Products_Items_SupGroup]
ALTER TABLE Products ALTER COLUMN Prod_Barcode nvarchar(20)
ALTER TABLE Customers ALTER COLUMN Cust_Name nvarchar(500)
ALTER TABLE Customers ALTER COLUMN Cust_Phone nvarchar(20)
ALTER TABLE Customers ALTER COLUMN Cust_Tax nvarchar(20)

UPDATE [dbo].[Sale] SET [Cust_Phone_No] = '',[Sale_Note] = ''


UPDATE [dbo].[Customers] SET [Cust_Tax] = ''








CREATE UNIQUE NONCLUSTERED INDEX [PROD_BARCODE_INDEX] ON [dbo].[Products] ([Prod_Barcode] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

CREATE PROCEDURE [dbo].[InsertPRODUCTS] (@Prod_ID int,@Prod_Name nvarchar(200),@Prod_Barcode nvarchar(20),@Prod_Qty real,@Buy_Price real,@SaleGomla_Price real,@Sale_Price real,@Is_Tax nvarchar(MAX),@Tax_Value real,@Sale_PriceByTax real,@MiniQty real,@MaxDiscount real,@MainGroup_ID int,@SubGroup_ID int,@Main_UnitName nvarchar(MAX),@Main_UnitID int,@Sale_UnitName nvarchar(MAX),@Sale_UnitID int,@Buy_UnitName nvarchar(MAX),@Buy_UnitID int) AS SET NOCOUNT OFF; INSERT INTO [dbo].[Products] ([Prod_ID], [Prod_Name], [Prod_Barcode], [Prod_Qty], [Buy_Price], [SaleGomla_Price], [Sale_Price], [Is_Tax], [Tax_Value], [Sale_PriceByTax], [MiniQty], [MaxDiscount], [MainGroup_ID], [SubGroup_ID], [Main_UnitName], [Main_UnitID], [Sale_UnitName], [Sale_UnitID], [Buy_UnitName], [Buy_UnitID]) VALUES (@Prod_ID, @Prod_Name, @Prod_Barcode, @Prod_Qty, @Buy_Price, @SaleGomla_Price, @Sale_Price, @Is_Tax, @Tax_Value, @Sale_PriceByTax, @MiniQty, @MaxDiscount, @MainGroup_ID, @SubGroup_ID, @Main_UnitName, @Main_UnitID, @Sale_UnitName, @Sale_UnitID, @Buy_UnitName, @Buy_UnitID); SELECT Prod_ID, Prod_Name, Prod_Barcode, Prod_Qty, Buy_Price, SaleGomla_Price, Sale_Price, Is_Tax, Tax_Value, Sale_PriceByTax, MiniQty, MaxDiscount, MainGroup_ID, SubGroup_ID, Main_UnitName, Main_UnitID, Sale_UnitName, Sale_UnitID, Buy_UnitName, Buy_UnitID FROM Products WHERE (Prod_ID = @Prod_ID)

CREATE PROCEDURE [dbo].[UpdatePRODUCTS] (@Prod_ID int,@Prod_Name nvarchar(200),@Prod_Barcode nvarchar(20),@Prod_Qty real,@Buy_Price real,@SaleGomla_Price real,@Sale_Price real,@Is_Tax nvarchar(MAX),@Tax_Value real,@Sale_PriceByTax real,@MiniQty real,@MaxDiscount real,@MainGroup_ID int,@SubGroup_ID int,@Main_UnitName nvarchar(MAX),@Main_UnitID int,@Sale_UnitName nvarchar(MAX),@Sale_UnitID int,@Buy_UnitName nvarchar(MAX),@Buy_UnitID int,@Original_Prod_ID int) AS SET NOCOUNT OFF; UPDATE Products SET Prod_ID = @Prod_ID, Prod_Name = @Prod_Name, Prod_Barcode = @Prod_Barcode, Prod_Qty = @Prod_Qty, Buy_Price = @Buy_Price, SaleGomla_Price = @SaleGomla_Price, Sale_Price = @Sale_Price, Is_Tax = @Is_Tax, Tax_Value = @Tax_Value, Sale_PriceByTax = @Sale_PriceByTax, MiniQty = @MiniQty, MaxDiscount = @MaxDiscount, MainGroup_ID = @MainGroup_ID, SubGroup_ID = @SubGroup_ID, Main_UnitName = @Main_UnitName, Main_UnitID = @Main_UnitID, Sale_UnitName = @Sale_UnitName, Sale_UnitID = @Sale_UnitID, Buy_UnitName = @Buy_UnitName, Buy_UnitID = @Buy_UnitID WHERE (Prod_ID = @Original_Prod_ID); SELECT Prod_ID, Prod_Name, Prod_Barcode, Prod_Qty, Buy_Price, SaleGomla_Price, Sale_Price, Is_Tax, Tax_Value, Sale_PriceByTax, MiniQty, MaxDiscount, MainGroup_ID, SubGroup_ID, Main_UnitName, Main_UnitID, Sale_UnitName, Sale_UnitID, Buy_UnitName, Buy_UnitID FROM Products WHERE (Prod_ID = @Prod_ID)

CREATE PROCEDURE [dbo].[UpdatePRODUCT_NAME] (@Prod_Name nvarchar(200),@Original_Prod_ID int) AS SET NOCOUNT OFF; UPDATE Products SET Prod_Name = @Prod_Name WHERE (Prod_ID = @Original_Prod_ID)

CREATE PROCEDURE [dbo].[DeletePRODUCTS] (@Original_Prod_ID int) AS SET NOCOUNT OFF; DELETE FROM Products WHERE (Prod_ID = @Original_Prod_ID)





CREATE PROCEDURE [dbo].[InsertCUSTOMER] (@Cust_ID int,@Cust_Name nvarchar(500),@Cust_Phone nvarchar(20),@Cust_Address nvarchar(MAX),@Notes nvarchar(MAX),@Account real,@Cust_Tax nvarchar(20)) AS SET NOCOUNT OFF; INSERT INTO [dbo].[Customers] ([Cust_ID], [Cust_Name], [Cust_Phone], [Cust_Address], [Notes], [Account], [Cust_Tax]) VALUES (@Cust_ID, @Cust_Name, @Cust_Phone, @Cust_Address, @Notes, @Account, @Cust_Tax); SELECT Cust_ID, Cust_Name, Cust_Phone, Cust_Address, Notes, Account, Cust_Tax FROM Customers WHERE (Cust_ID = @Cust_ID)

CREATE PROCEDURE [dbo].[UpdateCUSTOMER] (@Cust_ID int,@Cust_Name nvarchar(500),@Cust_Phone nvarchar(20),@Cust_Address nvarchar(MAX),@Notes nvarchar(MAX),@Account real,@Cust_Tax nvarchar(20),@Original_Cust_ID int) AS SET NOCOUNT OFF; UPDATE Customers SET Cust_ID = @Cust_ID, Cust_Name = @Cust_Name, Cust_Phone = @Cust_Phone, Cust_Address = @Cust_Address, Notes = @Notes, Account = @Account, Cust_Tax = @Cust_Tax WHERE (Cust_ID = @Original_Cust_ID)

CREATE PROCEDURE [dbo].[DeleteCUSTOMER] (@Original_Cust_ID int) AS SET NOCOUNT OFF; DELETE FROM Customers WHERE (Cust_ID = @Original_Cust_ID)