Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: string concatination

    Here we go...

    GO

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    CREATE TABLE [dbo].[TEST1](

    [a1] [varchar](10) NULL,

    [a2] [varchar](10) NULL,

    [a3] [varchar](10) NULL

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    GO

    INSERT [dbo].[TEST1] ([a1], [a2], [a3]) VALUES (N'A', N'B', N'C')

    INSERT [dbo].[TEST1]...

Viewing post 1 (of 1 total)