Sql Server Error : The IDENTITY function can only be used when the SELECT statement has an INTO clause.

Posted by Sqltimes
On April 30, 2015
0 Comments

Quick one today: Recently, ran into an interesting error message that looks very complicated, but is fairly straight one. 1 2 Msg 177, Level 15, State 1, Line 1 The IDENTITY function can only be used when the SELECT statement has an INTO clause. The code looked something like this: 1 2 3 4 5 […]

Posted by Sqltimes
On April 29, 2015
0 Comments

Quick one today: As alwways, there is value in formatting SQL code in a proper way. There are several ‘proper’ ways to format code; And all are great. To each, their own. But one formatting tip that everyone appreciates is keeping Sql Server identifiers or keywords in UPPER CASE. There is a keyboard shortcut, that […]

Posted by Sqltimes
On April 29, 2015
0 Comments

Sql Server Error : The IDENTITY function can only be used when the SELECT statement has an INTO clause.

Sql Server : Keyboard shortcut to change to UPPER CASE in Sql Server Management Studio (SSMS)

Sql Server : Keyboard shortcut to change to UPPER CASE in Sql Server Management Studio (SSMS)