declare @id int
declare @name varchar(20)
declare @str varchar(1000)
set @id=''
set @name=''
select @id=[8dgsUser_ID],@name=[8dgsUser_Name] from [8dgsUser] where [8dgsUser_ID]=2
print(@id)
print(@name)
这样就可以获取ID跟Name的值
declare @id int
declare @name varchar(20)
declare @str varchar(1000)
set @id=''
set @name=''
select @id=[8dgsUser_ID],@name=[8dgsUser_Name] from [8dgsUser] where [8dgsUser_ID]=2
print(@id)
print(@name)
这样就可以获取ID跟Name的值