【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供399.sql参考,解决您在399.sql学习中工作中的难题,参考学习。
use db_sql
GO
if exists(select * from INFORMATION_SCHEMA.TABLES
where table_name = 'tb_con20')
drop table tb_con20
GO
create table tb_con20
(
编号 int primary key,
varchar(15),
性别 char(2),
年龄 int,
单位名称 varchar(20),
电话 varchar(16),
备注 varchar(30)
)
GO
insert into tb_con20 values(1,'王一','男',23,'方X鞋业','8319XXXX','无')
insert into tb_con20 values(2,'林红','女',22,'从X乳业','8112XXXX','无')
insert into tb_con20 values(3,'姜苏','女',25,'星X集团','8220XXXX','无')
insert into tb_con20 values(4,'赵月','男',28,'李X驾校','8330XXXX','无')
GO
declare @word varchar(30)
set @
word='方X鞋业'
select from tb_con20 where contains(单位名称,@word)