本文演示了如何使用SQL创建表、插入数据，并通过变量获取表中特定记录的值。重点介绍了SQL查询语句的应用。
如果有多条记录,则获得最后一个:
SQL code
create table tablea(id int,ip varchar(15),apps varchar(10))
insert into tablea select 23,'127.0.0.1','aaa'
insert into tablea select 23,'127.0.0.2','abb'
go
declare @Variable1 varchar(15),@Variable2 varchar(10)
select @Variable1 = ip ,@Variable2 = apps from tablea where id = 23
select @Variable1,@Variable2
/*
--------------- ----------
127.0.0.2 abb
(1 行受影响)
*/
go
drop table tablea
SQL code
create table tablea(id int,ip varchar(15),apps varchar(10))
insert into tablea select 23,'127.0.0.1','aaa'
insert into tablea select 23,'127.0.0.2','abb'
go
declare @Variable1 varchar(15),@Variable2 varchar(10)
select @Variable1 = ip ,@Variable2 = apps from tablea where id = 23
select @Variable1,@Variable2
/*
--------------- ----------
127.0.0.2 abb
(1 行受影响)
*/
go
drop table tablea
扫一扫
1556
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
