22,206
社区成员
发帖
与我相关
我的任务
分享
select id,mian from Table_1
select id,mian from Table_2
1 但是复苏的
2
3 Delphi
4
1 dsf
2 adfv
3 ouio
4 vbnm
1 但是复苏的
2 adfv
3 Delphi
4 vbnm
select id,isnull(select Table_1.mian from Table_2 where Table_1.id=Table_2.id)mian from Table_1
--@@rowcount=0 相当于查询语句没有返回零行
SELECT TOP 1 B.TAXUP
FROM ANT B LEFT JOIN ANTUDF A ON (B.PANNO=A.PANNO and B.ITEMNO=A.ITEMNO)
WHERE B.CODE='EOJ00000700' AND WO='1103046' AND B.TAXUP > 0 order by B.DATETIME desc
if @@rowcount=0
SELECT TOP 1 B.TAXUP
FROM ANT B LEFT JOIN ANTUDF A ON (B.PANNO=A.PANNO and B.ITEMNO=A.ITEMNO)
WHERE B.CODE='EOJ00000700' AND B.TAXUP > 0 order by B.DATETIME desc
if @@rowcount=0
select TOP 1 TAXUP,DATETIME from VQUT WHERE CODE='EOJ00000700' order by DATETIME desc
SELECT TOP 1 B.TAXUP
FROM ANT B LEFT JOIN ANTUDF A ON (B.PANNO=A.PANNO and B.ITEMNO=A.ITEMNO)
WHERE B.CODE='EOJ00000700' AND WO='1103046' AND B.TAXUP > 0 order by B.DATETIME desc
SELECT TOP 1 B.TAXUP
FROM ANT B LEFT JOIN ANTUDF A ON (B.PANNO=A.PANNO and B.ITEMNO=A.ITEMNO)
WHERE B.CODE='EOJ00000700' AND B.TAXUP > 0 order by B.DATETIME desc
select TOP 1 TAXUP,DATETIME from VQUT WHERE CODE='EOJ00000700' order by DATETIME desc
select id,mian=(case when isnull(Table_1.mian,'')='' then Table_2.mian else Table_1.mian end)
from Table_1 left join Table_2 on Table_1.id=Table_2.id
create table #t1 ( [id] INT, [mian] VARCHAR(30) )
INSERT INTO #t1
SELECT
1, '但是复苏的' UNION ALL SELECT
2, '' UNION ALL SELECT
3, 'Delphi' UNION ALL SELECT
4, ''
create table #t2 ( [id] INT, [mian] VARCHAR(30) )
INSERT INTO #t2
SELECT
1, 'dsf' UNION ALL SELECT
2, 'adfv' UNION ALL SELECT
3, 'ouio' UNION ALL SELECT
4, 'vbnm'
select isnull(t1.id,t2.id),isnull((case t1.mian when '' then null else t1.mian end),t2.mian)
from #t1 t1
full join #t2 t2
on t1.id = t2.id
select t1.id,case t1.mian when '' then t1.mian else t2.mian end)
from Table_1 t1
inner join Table_2 t2
on t1.id = t2.id
SET NOCOUNT ON
DECLARE @t1 TABLE ( [id] INT, [mian] VARCHAR(30) )
INSERT INTO @t1
SELECT
1, '但是复苏的' UNION ALL SELECT
2, '' UNION ALL SELECT
3, 'Delphi' UNION ALL SELECT
4, ''
DECLARE @t2 TABLE ( [id] INT, [mian] VARCHAR(30) )
INSERT INTO @t2
SELECT
1, 'dsf' UNION ALL SELECT
2, 'adfv' UNION ALL SELECT
3, 'ouio' UNION ALL SELECT
4, 'vbnm'
SET NOCOUNT OFF
SELECT A.[id],
CASE WHEN A.[mian] IS NULL OR A.[mian]='' THEN (SELECT TOP 1 [mian] FROM @t2 WHERE [id]=A.[id]) ELSE A.[mian] END 'mian' FROM @t1 A
/*id mian
----------- ------------------------------
1 但是复苏的
2 adfv
3 Delphi
4 vbnm
(所影响的行数为 4 行)
*/
select t1.id,isnull(t1.mian,t2.mian)
from Table_1 t1
inner join Table_2 t2
on t1.id = t2.id
1 但是复苏的
2
3 Delphi
4