Information générale
Forum:
Microsoft SQL Server
Titre:
How to use IDENTITY function
Hello ,everyone!
I use IDENTITY function is Error ,I don,t kown how to use IDENTITY()
This is my code:
use taxi
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'aa')
DROP TABLE aa
GO
declare @Num as tinyint
select @Num=max(CodeId) from c_mz
select IDENTITY (tinyint,@Num ,1 ) AS id_num, MZ into aa from driverTemp where MZ IS NOT NULL group by MZ order by MZ
go
"Line 5 : '@Num' syntax error
Why IDENTITY Arguments "send" cann't use variable
What's wrong?
Help me ,thanks!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement