SQL Update语句不执行任何操作

我有一个SQL Update语句，当通过新的查询窗口在VS2010中运行时，它可以工作，但当我将其构造为更新语句时，什么都不会发生。

我想知道是否有人能看出我做错了什么？正如我所说的，当通过VS2010中的查询窗口执行代码时，代码是有效的。

这是我的代码：

SqlConnection connection = new SqlConnection(DBConnection.GetConnection().ConnectionString);
string updateStatement = 
    "DECLARE @OldParent hierarchyid, @NewParent hierarchyid " +
    "SELECT @OldParent = Hierarchy FROM SpecProducts " +
    "WHERE ID = @NodeToMoveID ; ------ top item to be moved " +
    "SELECT @NewParent = Hierarchy FROM SpecProducts " +
    "WHERE ID = @NodeToMoveIntoID  ; -- ID of item to move into - new parent " +
    "DECLARE children_cursor CURSOR FOR " +
    "SELECT Hierarchy FROM SpecProducts " +
    "WHERE Hierarchy = @OldParent; " +
    "DECLARE @ChildId hierarchyid; " +
    "OPEN children_cursor " +
    "FETCH NEXT FROM children_cursor INTO @ChildId; " +
    "WHILE @@FETCH_STATUS = 0 " +
    "BEGIN " +
    "START: " +
       "DECLARE @NewId hierarchyid; " +
       "SELECT @NewId = @NewParent.GetDescendant(MAX(Hierarchy), NULL) " +
       "FROM SpecProducts WHERE Hierarchy.GetAncestor(1) = @NewParent; " +
       "UPDATE SpecProducts " +
       "SET Hierarchy = Hierarchy.GetReparentedValue(@ChildId, @NewId), " +
           "MovedToDate = @MovedToDate, " +
           "MovedToBy = @MovedToBy " +
       "WHERE Hierarchy.IsDescendantOf(@ChildId) = 1; " +
       "IF @@error <> 0 GOTO START -- On error, retry " +
       "FETCH NEXT FROM children_cursor INTO @ChildId; " +
       "END " +
       "CLOSE children_cursor; " +
       "DEALLOCATE children_cursor;";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.Parameters.AddWithValue("@NodeToMoveID", nodeIDToMove);
updateCommand.Parameters.AddWithValue("@NodeToMoveIntoID", newParentID);
updateCommand.Parameters.AddWithValue("@MovedToDate", DateTime.Now);
updateCommand.Parameters.AddWithValue("@MovedToBy", userModifying.ID);
try
{
    connection.Open();
    updateCommand.ExecuteNonQuery();
    return true;
}

需要指出的一点是，当我的代码在VS2010Query窗口中执行时，我会收到关于"Declare"功能的警告，但我按continue，它就工作了。我的语句不起作用是否与Declare功能有关？

如有任何想法/解决方案，我们将不胜感激。

非常感谢。

Rob