将数字赋值给变量
declare @count int
select @count=COUNT(*) from Permission.Menu
将字符/Guid串赋给变量
declare @menuId uniqueidentifier
select @menuId=Id from (select row_number()over(order by Id)as row,Id from Permission.Menu)as List where row =@num
将数字赋值给变量
declare @count int
select @count=COUNT(*) from Permission.Menu
将字符/Guid串赋给变量
declare @menuId uniqueidentifier
select @menuId=Id from (select row_number()over(order by Id)as row,Id from Permission.Menu)as List where row =@num