Venkatmca008
Senior Software Engineer
Tuesday, July 19, 2016
Create temp table with identity in SQL
Some time we need to create temp table with
identity in SQL.Below Tip will help tp resolve our issue
SELECT
SequentialRowNumber = identity(
INT
,1,1),ROW_NUMBER()
OVER (
ORDER
BY
CustID)
AS
Row,*
into
mytit1
from
#customers
No comments :
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments ( Atom )
No comments :
Post a Comment