SQL Server development skills 1

1. How to get the ID of current inserted record? Using @ identity keyword. e. g. create Table Table1 (ID int identity (1, 1) not null, name nvarchar (64) goinsert into Table1 ('Hello World') goselect @ identity2. how to cleanup SQL Server plan cache? DBCC dropcleanbuffers -- cleanup all cache datadbcc freeproccache -- cleanup plan Cache

 

3. Can I create an index on the view?

Yes, the notice is the unique clustered index must be created first. And you should useWith schemabindingFlag when creating.

E.G,

Create view V1With schemabindingAs SQL statement

Go

Create index unique clustered idx_1 on [columns...]

 

4. What's the different between clustered index and index?

The difference is clustered index try to store the relation data in the same page on disk as possible. but index not. so, almost performance of clustered index is better than index, but when you re-create the index or order by result set, it is low performance.