Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --============== Create example source table =======================================
- CREATE TABLE [dbo].[Stages_raw_day2](
- [name] [varchar](200) NULL,
- [address] [varchar](400) NULL
- ) ON [PRIMARY]
- GO
- INSERT INTO Stages_raw_day2
- (name,
- address)
- VALUES
- ('The Shakespeare Theatre','154bis, boulevard de la Chapelle')
- --========================================================================
- INSERT INTO Stages_raw_day2
- (name,
- address)
- VALUES
- ('Theatre Victor Hugo','11, rue du Temple')
- --========================================================================
- INSERT INTO Stages_raw_day2
- (name,
- address)
- VALUES
- ('The Dostojevskij theatre','10, rue Fontaine')
- --========================================================================
- INSERT INTO Stages_raw_day2
- (name,
- address)
- VALUES
- ('Theatre Sokrates','1, rue du Temple')
- --========================================================================
- -- ¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤
- -- !!!!!!!!!!!!! Name change !!!!!!!!!!!!!!!!!!!!!!!!!!!
- -- ¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤
- INSERT INTO Stages_raw_day2
- (name,
- address)
- VALUES
- ('August Strindbergs','Storgatan 2')
- --========================================================================
- INSERT INTO Stages_raw_day2
- (name,
- address)
- VALUES
- ('Teater Ingmar Bergman','Drottninggatan 55')
- --========================================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement