declare #sqlserver
--------------------------------------------------declare的用法------------------------------ declare @id int declare @id int = 3 set @id=2 select @abc = count(*) from tc123 //注意@abc只能在select后使用等号