Wednesday, August 27, 2014

sql bracket woes

an example of nightmares in brackets:

IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[xx]') AND type in (N'U'))
drop table xx
go
create table x (x int)
EXEC sp_rename '[dbo].[x]', '[dbo].[xx]';
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[[dbo]].[xx]]]') AND type in (N'U'))
EXEC sp_rename '[dbo].[[dbo]].[xx]]]', 'xx';

GO

No comments:

Post a Comment