select *
from nottable
where len(no) > 12
from nottable
where len(no) > 12
解决方案 »
- 同一条信息在同一个表中出现三次及以上的sql
- 数据表设计问题,一个电表一天96个数据,有200-300个电表,是横着搞96列好呀,还是坚着做一列好呢?
- sql理论问题
- 原先值由空变为非空,触发器 update却无动作。各位帮我瞧瞧~
- 跨数据库查询问题
- 有专门是MSDE的书吗?
- 问一下:什么是数据库的三级模型结构?(在线等)
- 有个设计时的问题?请进来帮帮忙.是自定义字段的.
- 奇了怪了
- 求sql(救急)!!!
- sql server 2005与excel之间导入导出数据问题!
- 在SQL2005上 无法连接到报表服务器,显示错误为:客户端发现响应内容类型为“text/html:charset=utf-8”但应为“text/xml”
where exists (select 1 from notable where no like rtrim(t.no) + '%' and no<>t.no)
where exists (select 1 from notable where no like rtrim(t.no) + '%' and no <>t.no)
-- Author: liangCK 小梁
-- Date : 2008-11-20 11:22:17
---------------------------------
--> 生成测试数据: @T
DECLARE @T TABLE (no VARCHAR(14))
INSERT INTO @T
SELECT 'SSIL08110001' UNION ALL
SELECT 'SSIL08110002' UNION ALL
SELECT 'SSIL08110003' UNION ALL
SELECT 'SSIL08110004' UNION ALL
SELECT 'HCC0940' UNION ALL
SELECT 'SSIL08110004-A' UNION ALL
SELECT 'SSIL08110004-B' UNION ALL
SELECT 'SSIL08110004-C'--SQL查询如下:SELECT *
FROM @T AS t
WHERE EXISTS(
SELECT *
FROM @T
WHERE no<>t.no
AND no LIKE t.no+'%'
)/*
no
--------------
SSIL08110004(1 行受影响)*/
INSERT INTO #A SELECT 'SSIL08110001'
INSERT INTO #A SELECT 'SSIL08110002'
INSERT INTO #A SELECT 'SSIL08110003'
INSERT INTO #A SELECT 'SSIL08110004'
INSERT INTO #A SELECT 'HCC0940'
INSERT INTO #A SELECT 'SSIL08110004-A'
INSERT INTO #A SELECT 'SSIL08110004-B'
INSERT INTO #A SELECT 'SSIL08110004-C'SELECT * FROM #A A
WHERE (SELECT COUNT(*) FROM #A WHERE LEFT(S_NO,LEN(A.S_NO))=A.S_NO)>1DROP TABLE #A /**
SSIL08110004