>>No. You can have only one clustered index per table.
>
>So, if I want to create a clustered index, I need to add clustered in it such as:
>
>
>CREATE CLUSTERED INDEX
>
>
>Or, when I want to create a clustered index, should I only ommit including it?
You need to explicitly specify CLUSTERED when you want to make the index CLUSTERED. By default it would be nonclustered.
If it's not broken, fix it until it is.
My Blog