求一个select语句，刚才没把问题描述清楚

2008-04-07 01:20:54 160 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SELECT 语句详解如果要查询表的所有内容，则把要查询的列名用一个星号 * 号表示(实验 2、3 中都已经使用过)，代表要查询表中所有的列。在处理多个表时，子查询只有在结果来自一个表时才有用。在正式开始本实验内容之前，需要先下载相关数据库表，搭建好一个名为mysql_shiyan 的数据库(有三张表：department，employee，project)，并向其中插入数据。刚才下载的两个文件 MySQL-04-01.sql 和 MySQL-04-02.sql，其中第一个文件用于创建数据库，第二个文件向数据库中插入数据。阅读详情

create table #tb (vNo varchar(15))
insert into #tb
select '2006206110'
union all
select '2006216700'
union all
select '2006236570'
union all
select '2006237470'
union all
select '2006007030'
union all
select '2006069140'

select * from #tb

当我想查询'2006007030' '2006069140' '20061010888'
只返回'20061010888'，因为我的表里面没有'20061010888'

...全文

电容式麦克风：从原理到实际电路波形解析本文深入解析电容式麦克风的工作原理，从核心的振膜与背板结构、电荷锁定机制到场效应管放大器的作用。通过实物拆解与等效电路分析，阐明声音振动如何转换为电压信号，并指导如何用示波器实测波形，直观展现声电转换过程，适合电子爱好者和音频技术学习者。阅读详情

tianhuo_soft

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

-狙击手- 2008-04-08

打赏
举报

declare @sql varchar(200)
set @sql='2006007030,2006069140,20061010888'
select @sql=replace(','+@sql+',',','+vno+',','') from #tb
select replace(@sql,',','')

顶这个

JL99000 2008-04-07

打赏
举报

我顶你个妃

huangjh_love 2008-04-07

打赏
举报

use HC

create table #tb (vNo varchar(15)) 

insert into #tb 

select '2006206110'  

union all 

select '2006216700'  

union all 

select '2006236570'  

union all 

select '2006237470'  

union all 

select '2006007030'  

union all 

select '2006069140'  



declare @sql varchar(200)

set @sql='2006007030,2006069140,20061010888'

select @sql=replace(','+@sql+',',','+vno+',','') from #tb

select  replace(@sql,',','') vNo

drop table #tb

wangxuelid 2008-04-07

打赏
举报



/*

20061010888



*/

pt1314917 2008-04-07

打赏
举报



create table #tb (vNo varchar(15)) 

insert into #tb 

select '2006206110'  

union all 

select '2006216700'  

union all 

select '2006236570'  

union all 

select '2006237470'  

union all 

select '2006007030'  

union all 

select '2006069140'  



declare @sql varchar(200)

set @sql='2006007030,2006069140,20061010888'

select @sql=replace(','+@sql+',',','+vno+',','') from #tb

select  replace(@sql,',','')

wangxuelid 2008-04-07

打赏
举报

create table #tb (vNo varchar(15)) 

insert into #tb 

select '2006206110'  

union all 

select '2006216700'  

union all 

select '2006236570'  

union all 

select '2006237470'  

union all 

select '2006007030'  

union all 

select '2006069140'  



Create table #tab (a varchar(20))

insert into #tab

select '2006007030'  union 

select  '2006069140' union

select '20061010888'



select * from #tab where a not in (select vNo from #tb )

areswang 2008-04-07

打赏
举报

create table #tb (vNo varchar(15))
insert into #tb
select '2006206110'
union all
select '2006216700'
union all
select '2006236570'
union all
select '2006237470'
union all
select '2006007030'
union all
select '2006069140'

create procedure test @vNO AS VARCHAR(15) OUTPUT
AS
SELECT TOP 1 @vNO FROM #TB WHERE VNO<>@VNO

EXEC TEST '20061010888'

jinjazz 2008-04-07

打赏
举报

create table #tb (vNo varchar(15)) 

insert into #tb 

select '2006206110'  

union all 

select '2006216700'  

union all 

select '2006236570'  

union all 

select '2006237470'  

union all 

select '2006007030'  

union all 

select '2006069140'  

select * from (

select '2006007030' as vno union select '2006069140' union select '20061010888' )a

where vno   not in (select vno from #tb )

drop table #tb

viva369 2008-04-07

打赏
举报



create table #tb (vNo varchar(15)) 

insert into #tb 

select '2006206110'  

union all 

select '2006216700'  

union all 

select '2006236570'  

union all 

select '2006237470'  

union all 

select '2006007030'  

union all 

select '2006069140'



go



select * from

(

select '2006007030' tblColumn 

union all 

select '2006069140'  

union all 

select '20061010888'

) as tbl

where not exists(select * from #tb where vNo = tblColumn)

求一个select语句，刚才没把问题描述清楚

相关推荐