Hi
How to run the next line in sql when the previous line is in failure in a .sql file while Executing the .sql file in runtime using C#
I have written sql script like this
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_QTY_IN DEFAULT ((0)) FOR [QTY_IN]
GO
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_QTY_OUT DEFAULT ((0)) FOR [QTY_OUT]
GO
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_UNIT_COST DEFAULT ((0)) FOR [UNIT_COST]
GO
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_AMT_IN DEFAULT ((0)) FOR [AMT_IN]
GO
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_AMT_OUT DEFAULT ((0)) FOR [AMT_OUT]
GO
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_ID DEFAULT ((0)) FOR [ID]
GO
ALTER TABLE [dbo].[STOCKDETAILS] ADD Constraint DF_STOCKDETAILS_BATCH_NO DEFAULT ((0)) FOR [BATCH_NO]
GO
ALTER TABLE [dbo].[PRODUCT] ADD Constraint DF_PRODUCT_SERIALIZED DEFAULT ((0)) FOR [SERIALIZED]
GO
--------------------------RUN THIS SCRIPT IF GRADEDDETAILS TABLE CONTAINS DATA / IF ERROR OCCURS WHILE CONVERTING THE ABOUVE SRIPT---------
ALTER TABLE GradedDETAILS ADD STOCK_DATE1 DATETIME NULL ----STEP 1--
ALTER TABLE GradedDETAILS ALTER COLUMN [STOCK_DATE] NVARCHAR(100) ----STEP 2--
UPDATE GradedDETAILS SET [STOCK_DATE]=CONVERT(DATETIME, [STOCK_DATE], 104) ----STEP 3--
UPDATE GradedDETAILS SET [STOCK_DATE1]=[STOCK_DATE] ----STEP 4--
ALTER TABLE GradedDETAILS DROP COLUMN [STOCK_DATE] ----STEP 5--
SP_RENAME 'GradedDETAILS.STOCK_DATE1','STOCK_DATE','COLUMN' ----STEP 6--
I want to execute query step by step in sql using C# with single click
if you execute it once then i got error like this
Incorrect syntax near 'SP_RENAME'.
when one line is failed total execution fails due to that error
I have more scripts to run in a single click. would u please resolve this error