sqlserver创建索引

use db
go
if not exists (select 1 from sys.indexes where name='index' and object_id=object_id('table'))
begin
    CREATE NONCLUSTERED INDEX [index] ON [dbo].[table]
    (
        [a] ASC,
        [b] ASC,
        [c] ASC,
        [d] ASC
    )
    INCLUDE ( [e],
        [f],
        [g)
end