Windowing functions over, views, things in SQL Server

First, the window function over the role of two:

1, sort order by,row_number, flip page

2, zoned area partition by, combined with aggregation function for a part of the data to summarize

SQL Server statements that turn pages:

Select  from Select  as  from  as where t.num>6 and t.num<

Second, view: used to store a SELECT statement. is not a container for storing data.

Create VIEW View name

As

.... Select SQL statement:

Third, the thing, used to execute a coherent SQL statement process, if the error is rolled back, example: payment process

Opening things: Begin Tran

Commit a thing: Commit Tran

Rolling back things: Rollback Tran

Windowing functions over, views, things in SQL Server