SQL Server 2008 R2 中的自动收缩、加密和恢复模型属性

Question

jhowe

Asked: 2015-02-26 06:06:57 +0800 CST2015-02-26 06:06:57 +0800 CST 2015-02-26 06:06:57 +0800 CST

SQL去掉中间字符

772

简单的问题，不是那么简单的答案！我有一堆日期...如何删除中间数字（不正确）以便我只有第 3 周、2011/2012 等？谢谢！

Reporting_Week_Name
Week 52, 2010/2011/2012
Week 52, 2010/2011/2012
Week 1, 2011/2011/2012
Week 1, 2011/2011/2012
Week 1, 2011/2011/2012
Week 1, 2011/2011/2012
Week 1, 2011/2011/2012
Week 1, 2011/2011/2012
Week 1, 2011/2011/2012
Week 2, 2011/2011/2012
Week 2, 2011/2011/2012
Week 2, 2011/2011/2012
Week 2, 2011/2011/2012
Week 2, 2011/2011/2012
Week 2, 2011/2011/2012
Week 2, 2011/2011/2012
Week 3, 2011/2011/2012
Week 3, 2011/2011/2012
Week 3, 2011/2011/2012
Week 3, 2011/2011/2012
Week 3, 2011/2011/2012
Week 3, 2011/2011/2012
Week 3, 2011/2011/2012
Week 4, 2011/2011/2012
Week 4, 2011/2011/2012
Week 4, 2011/2011/2012
Week 4, 2011/2011/2012
Week 4, 2011/2011/2012
Week 4, 2011/2011/2012
Week 4, 2011/2011/2012
Week 5, 2011/2011/2012
Week 5, 2011/2011/2012
Week 5, 2011/2011/2012
Week 5, 2011/2011/2012
Week 5, 2011/2011/2012
Week 5, 2011/2011/2012
Week 5, 2011/2011/2012
Week 6, 2011/2011/2012
Week 6, 2011/2011/2012
Week 6, 2011/2011/2012
Week 6, 2011/2011/2012
Week 6, 2011/2011/2012
Week 6, 2011/2011/2012
Week 6, 2011/2011/2012
Week 7, 2011/2011/2012
Week 7, 2011/2011/2012
Week 7, 2011/2011/2012
Week 7, 2011/2011/2012
Week 7, 2011/2011/2012
Week 7, 2011/2011/2012
Week 7, 2011/2011/2012
Week 8, 2011/2011/2012
Week 8, 2011/2011/2012
Week 8, 2011/2011/2012
Week 8, 2011/2011/2012
Week 8, 2011/2011/2012
Week 8, 2011/2011/2012
Week 8, 2011/2011/2012
Week 9, 2011/2011/2012
Week 9, 2011/2011/2012
Week 9, 2011/2011/2012
Week 9, 2011/2011/2012
Week 9, 2011/2011/2012
Week 9, 2011/2011/2012
Week 9, 2011/2011/2012
Week 10, 2011/2011/2012
Week 10, 2011/2011/2012
Week 10, 2011/2011/2012
Week 10, 2011/2011/2012
Week 10, 2011/2011/2012
Week 10, 2011/2011/2012
Week 10, 2011/2011/2012
Week 11, 2011/2011/2012
Week 11, 2011/2011/2012
Week 11, 2011/2011/2012
Week 11, 2011/2011/2012
Week 11, 2011/2011/2012
Week 11, 2011/2011/2012
Week 11, 2011/2011/2012
Week 12, 2011/2011/2012
Week 12, 2011/2011/2012
Week 12, 2011/2011/2012
Week 12, 2011/2011/2012
Week 12, 2011/2011/2012
Week 12, 2011/2011/2012
Week 12, 2011/2011/2012
Week 13, 2011/2011/2012
Week 13, 2011/2011/2012
Week 13, 2011/2011/2012
Week 13, 2011/2011/2012
Week 13, 2011/2011/2012
Week 13, 2011/2011/2012
Week 13, 2011/2011/2012
Week 14, 2011/2011/2012
Week 14, 2011/2011/2012
Week 14, 2011/2011/2012
Week 14, 2011/2011/2012
Week 14, 2011/2011/2012
Week 14, 2011/2011/2012
Week 14, 2011/2011/2012
Week 15, 2011/2011/2012
Week 15, 2011/2011/2012
Week 15, 2011/2011/2012
Week 15, 2011/2011/2012
Week 15, 2011/2011/2012
Week 15, 2011/2011/2012
Week 15, 2011/2011/2012
Week 16, 2011/2011/2012
Week 16, 2011/2011/2012
Week 16, 2011/2011/2012
Week 16, 2011/2011/2012
Week 16, 2011/2011/2012
Week 16, 2011/2011/2012
Week 16, 2011/2011/2012
Week 17, 2011/2011/2012
Week 17, 2011/2011/2012
Week 17, 2011/2011/2012
Week 17, 2011/2011/2012
Week 17, 2011/2011/2012
Week 17, 2011/2011/2012
Week 17, 2011/2011/2012
Week 18, 2011/2011/2012
Week 18, 2011/2011/2012
Week 18, 2011/2011/2012
Week 18, 2011/2011/2012
Week 18, 2011/2011/2012
Week 18, 2011/2011/2012
Week 18, 2011/2011/2012
Week 19, 2011/2011/2012
Week 19, 2011/2011/2012
Week 19, 2011/2011/2012
Week 19, 2011/2011/2012
Week 19, 2011/2011/2012
Week 19, 2011/2011/2012
Week 19, 2011/2011/2012
Week 20, 2011/2011/2012
Week 20, 2011/2011/2012
Week 20, 2011/2011/2012
Week 20, 2011/2011/2012
Week 20, 2011/2011/2012
Week 20, 2011/2011/2012
Week 20, 2011/2011/2012
Week 21, 2011/2011/2012
Week 21, 2011/2011/2012
Week 21, 2011/2011/2012
Week 21, 2011/2011/2012
Week 21, 2011/2011/2012
Week 21, 2011/2011/2012
Week 21, 2011/2011/2012
Week 22, 2011/2011/2012
Week 22, 2011/2011/2012
Week 22, 2011/2011/2012
Week 22, 2011/2011/2012
Week 22, 2011/2011/2012
Week 22, 2011/2011/2012
Week 22, 2011/2011/2012
Week 23, 2011/2011/2012
Week 23, 2011/2011/2012
Week 23, 2011/2011/2012
Week 23, 2011/2011/2012
Week 23, 2011/2011/2012
Week 23, 2011/2011/2012
Week 23, 2011/2011/2012
Week 24, 2011/2011/2012
Week 24, 2011/2011/2012
Week 24, 2011/2011/2012
Week 24, 2011/2011/2012
Week 24, 2011/2011/2012
Week 24, 2011/2011/2012
Week 24, 2011/2011/2012
Week 25, 2011/2011/2012
Week 25, 2011/2011/2012
Week 25, 2011/2011/2012
Week 25, 2011/2011/2012
Week 25, 2011/2011/2012
Week 25, 2011/2011/2012
Week 25, 2011/2011/2012
Week 26, 2011/2011/2012
Week 26, 2011/2011/2012
Week 26, 2011/2011/2012
Week 26, 2011/2011/2012
Week 26, 2011/2011/2012
Week 26, 2011/2011/2012
Week 26, 2011/2011/2012
Week 27, 2011/2011/2012
Week 27, 2011/2011/2012
Week 27, 2011/2011/2012
Week 27, 2011/2011/2012
Week 27, 2011/2011/2012
Week 27, 2011/2011/2012
Week 27, 2011/2011/2012
Week 28, 2011/2011/2012
Week 28, 2011/2011/2012
Week 28, 2011/2011/2012
Week 28, 2011/2011/2012
Week 28, 2011/2011/2012
Week 28, 2011/2011/2012
Week 28, 2011/2011/2012
Week 29, 2011/2011/2012
Week 29, 2011/2011/2012
Week 29, 2011/2011/2012
Week 29, 2011/2011/2012
Week 29, 2011/2011/2012
Week 29, 2011/2011/2012
Week 29, 2011/2011/2012
Week 30, 2011/2011/2012
Week 30, 2011/2011/2012
Week 30, 2011/2011/2012
Week 30, 2011/2011/2012
Week 30, 2011/2011/2012
Week 30, 2011/2011/2012
Week 30, 2011/2011/2012
Week 31, 2011/2011/2012
Week 31, 2011/2011/2012
Week 31, 2011/2011/2012
Week 31, 2011/2011/2012
Week 31, 2011/2011/2012
Week 31, 2011/2011/2012
Week 31, 2011/2011/2012
Week 32, 2011/2011/2012
Week 32, 2011/2011/2012
Week 32, 2011/2011/2012
Week 32, 2011/2011/2012
Week 32, 2011/2011/2012
Week 32, 2011/2011/2012
Week 32, 2011/2011/2012
Week 33, 2011/2011/2012
Week 33, 2011/2011/2012
Week 33, 2011/2011/2012
Week 33, 2011/2011/2012
Week 33, 2011/2011/2012
Week 33, 2011/2011/2012
Week 33, 2011/2011/2012
Week 34, 2011/2011/2012
Week 34, 2011/2011/2012
Week 34, 2011/2011/2012
Week 34, 2011/2011/2012
Week 34, 2011/2011/2012
Week 34, 2011/2011/2012
Week 34, 2011/2011/2012
Week 35, 2011/2011/2012
Week 35, 2011/2011/2012
Week 35, 2011/2011/2012
Week 35, 2011/2011/2012
Week 35, 2011/2011/2012
Week 35, 2011/2011/2012
Week 35, 2011/2011/2012
Week 36, 2011/2011/2012
Week 36, 2011/2011/2012
Week 36, 2011/2011/2012
Week 36, 2011/2011/2012
Week 36, 2011/2011/2012
Week 36, 2011/2011/2012
Week 36, 2011/2011/2012
Week 37, 2011/2011/2012
Week 37, 2011/2011/2012
Week 37, 2011/2011/2012
Week 37, 2011/2011/2012
Week 37, 2011/2011/2012
Week 37, 2011/2011/2012
Week 37, 2011/2011/2012
Week 38, 2011/2011/2012
Week 38, 2011/2011/2012
Week 38, 2011/2011/2012
Week 38, 2011/2011/2012
Week 38, 2011/2011/2012
Week 38, 2011/2011/2012
Week 38, 2011/2011/2012
Week 39, 2011/2011/2012
Week 39, 2011/2011/2012
Week 39, 2011/2011/2012
Week 39, 2011/2011/2012
Week 39, 2011/2011/2012
Week 39, 2011/2011/2012
Week 39, 2011/2011/2012
Week 40, 2011/2011/2012
Week 40, 2011/2011/2012
Week 40, 2011/2011/2012
Week 40, 2011/2011/2012
Week 40, 2011/2011/2012
Week 40, 2011/2011/2012
Week 40, 2011/2011/2012
Week 41, 2011/2011/2012
Week 41, 2011/2011/2012
Week 41, 2011/2011/2012
Week 41, 2011/2011/2012
Week 41, 2011/2011/2012
Week 41, 2011/2011/2012
Week 41, 2011/2011/2012
Week 42, 2011/2011/2012
Week 42, 2011/2011/2012
Week 42, 2011/2011/2012
Week 42, 2011/2011/2012
Week 42, 2011/2011/2012
Week 42, 2011/2011/2012
Week 42, 2011/2011/2012
Week 43, 2011/2011/2012
Week 43, 2011/2011/2012
Week 43, 2011/2011/2012
Week 43, 2011/2011/2012
Week 43, 2011/2011/2012
Week 43, 2011/2011/2012
Week 43, 2011/2011/2012
Week 44, 2011/2011/2012
Week 44, 2011/2011/2012
Week 44, 2011/2011/2012
Week 44, 2011/2011/2012
Week 44, 2011/2011/2012
Week 44, 2011/2011/2012
Week 44, 2011/2011/2012
Week 45, 2011/2011/2012
Week 45, 2011/2011/2012
Week 45, 2011/2011/2012
Week 45, 2011/2011/2012
Week 45, 2011/2011/2012
Week 45, 2011/2011/2012
Week 45, 2011/2011/2012
Week 46, 2011/2011/2012
Week 46, 2011/2011/2012
Week 46, 2011/2011/2012
Week 46, 2011/2011/2012
Week 46, 2011/2011/2012
Week 46, 2011/2011/2012
Week 46, 2011/2011/2012
Week 47, 2011/2011/2012
Week 47, 2011/2011/2012
Week 47, 2011/2011/2012
Week 47, 2011/2011/2012
Week 47, 2011/2011/2012
Week 47, 2011/2011/2012
Week 47, 2011/2011/2012
Week 48, 2011/2011/2012
Week 48, 2011/2011/2012
Week 48, 2011/2011/2012
Week 48, 2011/2011/2012
Week 48, 2011/2011/2012
Week 48, 2011/2011/2012
Week 48, 2011/2011/2012
Week 49, 2011/2011/2012
Week 49, 2011/2011/2012
Week 49, 2011/2011/2012
Week 49, 2011/2011/2012
Week 49, 2011/2011/2012
Week 49, 2011/2011/2012
Week 49, 2011/2011/2012
Week 50, 2011/2011/2012
Week 50, 2011/2011/2012
Week 50, 2011/2011/2012
Week 50, 2011/2011/2012
Week 50, 2011/2011/2012
Week 50, 2011/2011/2012
Week 50, 2011/2011/2012
Week 51, 2011/2011/2012
Week 51, 2011/2011/2012
Week 51, 2011/2011/2012
Week 51, 2011/2011/2012
Week 51, 2011/2011/2012
Week 51, 2011/2011/2012
Week 51, 2011/2011/2012
Week 52, 2011/2011/2012
Week 52, 2011/2011/2012
Week 52, 2011/2011/2012
Week 52, 2011/2011/2012
Week 52, 2011/2011/2012
Week 52, 2011/2011/2012
Week 52, 2011/2012/2013
Week 1, 2012/2012/2013

2 个回答

Voted

Mikael Eriksson · Answer 1 · 2015-02-26T06:11:38+08:00

Best Answer

Mikael Eriksson

2015-02-26T06:11:38+08:002015-02-26T06:11:38+08:00

您可以使用charindex查找第一个/并stuff删除 5 个字符。

select stuff(Reporting_Week_Name, charindex('/', Reporting_Week_Name), 5, '')

数据浏览器

4

Sabin B · Answer 2 · 2015-02-26T06:11:38+08:00

Sabin B

2015-02-26T06:11:38+08:002015-02-26T06:11:38+08:00

DECLARE 
@vcVar AS VARCHAR(500) = 'Week 3, 2011/2011/2012'

SELECT STUFF(@vcVAR , CHARINDEX('/',@vcVar) ,5,'')

1

SQL去掉中间字符

连接到 PostgreSQL 服务器：致命：主机没有 pg_hba.conf 条目

如何让sqlplus的输出出现在一行中？

选择具有最大日期或最晚日期的日期

如何列出 PostgreSQL 中的所有模式？

列出指定表的所有列

如何在不修改我自己的 tnsnames.ora 的情况下使用 sqlplus 连接到位于另一台主机上的 Oracle 数据库

你如何mysqldump特定的表？

使用 psql 列出数据库权限

如何从 PostgreSQL 中的选择查询中将值插入表中？

如何使用 psql 列出所有数据库和表？

SQL去掉中间字符

2 个回答

相关问题