Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Table Creation script for recreating issue with TRIM function usage

Created October 15, 2017 11:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samirbehara-zz/1a272a8483664e04aaba30a054fb72b9 to your computer and use it in GitHub Desktop.
Save samirbehara-zz/1a272a8483664e04aaba30a054fb72b9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Table Creation script for recreating issue with TRIM function usage
CREATE TABLE [dbo].[Titles](
[Titlecode] [decimal](13, 0) NOT NULL,
[ListCode] [char](3) NULL,
[ZLineNumber] [int] NOT NULL,
[ZLineRateCode] [char](3) NULL,
[ZLineComment] [varchar](30) NULL,
CONSTRAINT [pk_Titles] PRIMARY KEY CLUSTERED
(
[Titlecode] ASC,
[ZLineNumber] ASC
))
CREATE NONCLUSTERED INDEX [nc_ListCode] ON [dbo].[Titles]
(
[ListCode] ASC
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment