Insert into table with Clustered index
what best practice insert data table clustered index ?? - sql azure required it. mean programically scharp ?? i´m friend guid aren´t int :-(. create guid, check exist in table - if no: insert - if yes: create new , check again...
for insert statements there no difference if (clustered) index exists or not, it's same.
a candidate primary key + clustered index integer column identity property, generates auto-incremented values.
olaf helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
wenn ich denke, ist das ein fehler und das beweise ich täglich
blog xing
Microsoft Azure > Azure SQL Database
Comments
Post a Comment