BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
COMMIT
BEGIN TRANSACTION
EXECUTE sp_rename 'dbo.table1.oldfdname', 'Tmp_newfdname', 'COLUMN'
GO
EXECUTE sp_rename 'dbo.table1.Tmp_newfdname', 'newfdname', 'COLUMN'
GO
COMMIT
SET QUOTED_IDENTIFIER ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
COMMIT
BEGIN TRANSACTION
EXECUTE sp_rename 'dbo.table1.oldfdname', 'Tmp_newfdname', 'COLUMN'
GO
EXECUTE sp_rename 'dbo.table1.Tmp_newfdname', 'newfdname', 'COLUMN'
GO
COMMIT
为什么用了两次,当中还有一个Tmp_newfdname有什么用?