DECLARE @name NVARCHAR(10) SELECT @name = stuName FROM Student WHERE stuName= N'张三'
DECLARE @name NVARCHAR(10) 1. set @name='张三' 2. select @name =stuName from Student where stuName='张三'语法要求!
set @name=(select stuName from Student where stuName='张三') --or select @name=stuName from Student where stuName='张三'
declare @name nvarchar(30) set @name='张三' ,select @name='张三' --赋值需要select或者 set select @name=stuName from Student where stuName='张三' --需要指一个字段,,或值 select @name='张三' from Student where stuName='张三'
declare @name nvarchar(30) set @name='张三' select @name=stuName from Student where stuName='张三'
select @name from Student where stuName='张三' 这样写有意思么? 除非你表中有多个张三,而你每有一个张三要得到一个@name,才有可能用这样的查询语句.不然,这种语句不可能出现在实用程序里.
1. declare @name as varchar(10) 2. set @name ='张三' 3. select @name = 哪个字段? from Student where stuName = @name
DECLARE @name NVARCHAR(10)
SELECT @name = stuName FROM Student WHERE stuName= N'张三'
1. set @name='张三'
2. select @name =stuName from Student where stuName='张三'语法要求!
--or
select @name=stuName from Student where stuName='张三'
set @name='张三' ,select @name='张三' --赋值需要select或者 set
select @name=stuName from Student where stuName='张三' --需要指一个字段,,或值
select @name='张三' from Student where stuName='张三'
set @name='张三'
select @name=stuName from Student where stuName='张三'
这样写有意思么?
除非你表中有多个张三,而你每有一个张三要得到一个@name,才有可能用这样的查询语句.不然,这种语句不可能出现在实用程序里.
2. set @name ='张三'
3. select @name = 哪个字段? from Student where stuName = @name