so this is code to delete a value from a table, while updating the identity
it keeps throwing the SQL exception
System.Data.SqlClient.SqlException: ‘Incorrect syntax near the keyword ‘TABLE’.
Incorrect syntax near the keyword ‘TABLE’.’
Any help would be appreciated
<code>private void button3_Click(object sender, EventArgs e)
string deleteID = Interaction.InputBox("Enter Which ID should be deleted", "Delete Value");
string conn = "Data Source=ANI-L5P11\SQLEXPRESS;Initial Catalog=TimeManagement;Integrated Security=True";
SqlConnection con = new SqlConnection(conn);
SqlCommand sqlCommand = new SqlCommand(@"DELETE FROM [dbo].[TimeManager2] WHERE ID = '"+deleteID+"'" +
"CREATE TABLE [dbo].[TempManager]([startTime] [varchar](50),[endTime] [varchar](50),[timeTaken] [varchar](50),[Activity] [varchar](50))" +
"INSERT INTO [dbo].[TempManager] SELECT startTime, endTime, timeTaken, Activity FROM TimeManager2" +
"TRUNCATE TABLE [dbo].[TimeManager2]" +
"DBCC CHECKIDENT (TimeManager2, RESEED, 1)" +
"INSERT INTO [dbo].[TimeManager2] (startTime, endTime, timeTaken, Activity) SELECT startTime, endTime, timeTaken, Activity FROM TempManager order by startTime" +
"DROP TABLE TempManager", con);
sqlCommand.ExecuteNonQuery();
<code>private void button3_Click(object sender, EventArgs e)
{
string deleteID = Interaction.InputBox("Enter Which ID should be deleted", "Delete Value");
string conn = "Data Source=ANI-L5P11\SQLEXPRESS;Initial Catalog=TimeManagement;Integrated Security=True";
SqlConnection con = new SqlConnection(conn);
SqlCommand sqlCommand = new SqlCommand(@"DELETE FROM [dbo].[TimeManager2] WHERE ID = '"+deleteID+"'" +
"CREATE TABLE [dbo].[TempManager]([startTime] [varchar](50),[endTime] [varchar](50),[timeTaken] [varchar](50),[Activity] [varchar](50))" +
"INSERT INTO [dbo].[TempManager] SELECT startTime, endTime, timeTaken, Activity FROM TimeManager2" +
"TRUNCATE TABLE [dbo].[TimeManager2]" +
"DBCC CHECKIDENT (TimeManager2, RESEED, 1)" +
"INSERT INTO [dbo].[TimeManager2] (startTime, endTime, timeTaken, Activity) SELECT startTime, endTime, timeTaken, Activity FROM TempManager order by startTime" +
"DROP TABLE TempManager", con);
con.Open();
sqlCommand.ExecuteNonQuery();
con.Close();
}
</code>
private void button3_Click(object sender, EventArgs e)
{
string deleteID = Interaction.InputBox("Enter Which ID should be deleted", "Delete Value");
string conn = "Data Source=ANI-L5P11\SQLEXPRESS;Initial Catalog=TimeManagement;Integrated Security=True";
SqlConnection con = new SqlConnection(conn);
SqlCommand sqlCommand = new SqlCommand(@"DELETE FROM [dbo].[TimeManager2] WHERE ID = '"+deleteID+"'" +
"CREATE TABLE [dbo].[TempManager]([startTime] [varchar](50),[endTime] [varchar](50),[timeTaken] [varchar](50),[Activity] [varchar](50))" +
"INSERT INTO [dbo].[TempManager] SELECT startTime, endTime, timeTaken, Activity FROM TimeManager2" +
"TRUNCATE TABLE [dbo].[TimeManager2]" +
"DBCC CHECKIDENT (TimeManager2, RESEED, 1)" +
"INSERT INTO [dbo].[TimeManager2] (startTime, endTime, timeTaken, Activity) SELECT startTime, endTime, timeTaken, Activity FROM TempManager order by startTime" +
"DROP TABLE TempManager", con);
con.Open();
sqlCommand.ExecuteNonQuery();
con.Close();
}
I have tried everything i could find related to this problem, but no one has specifically done this variation, hence i am asking on this platform.