79252496

Date: 2024-12-04 19:32:34
Score: 2.5
Natty:
Report link

You can also use "ALTER TABLE" to add an identity column to a temp table.

ALTER TABLE #TABLE ADD LineID NOT NUll IDENTORY(1,1)

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Phil Raffel