How to use the
row_number
SELECT
ROW_NUMBER() OVER (ORDER BY name ASC),
name, family, mobile, tell
FROM
dbo.customer
SQL text cannot be represented in the grid pane and diagram pane.
You can use row_number()
in a view, but you need to give it a name to use in a view:
SELECT row_number() over (order by name asc) as seqnum,
name, family, mobile, tell
FROM dbo.customer;