July 27, 2010 at 1:13 pm
Hi,
Here's a sample create index statement that was generated with SQL 2008 Management Studio...
CREATE NONCLUSTERED INDEX [I_TimeQueue, sysname,>]
ON [dbo].[TimeQueue] ([RuleInstanceId],[TriggerTime])
GO
Can anyone explain what the "sysname,>" part is? The definition of sysname on msdn is pretty strait forward, but it seems weird that this option isn't listed in the CREATE INDEX t-sql syntax. (see links below) Also, what is the significance of the ",>" parameter at the end?
Thanks
Charlie
July 27, 2010 at 2:32 pm
It looks like this is part of a template. In SSMS if you hit CTRL+ALT+T it will display the templates. Expand the index section and double click on the Create Index Basic template. You can then hit CTRL+SHIFT+M and fill in the variables. They are displayed in <variable, datatype, example> format.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy