ruilog
Notebook
Blog
About
Content Explore
从字符串中删除不需要的字符[SQL]
Published : 2007-12-21
Categories :
Tech
Tags :
Replace
Translate
SQL
DB2
MySQL
SQL Server
Oracle
PostgreSQL
O'Reilly , SQL Cookbook
by Antbony Molinaro
解决方案:replace(), translate()
DB2
select ename,
replace(translate(ename, 'aaaa', 'AEIOU'), 'a', '') stripped1,
sal,
replace(cast(sal as char(4)), '0', '') str...
如何导入MDF数据到 SQL server
Published : 2006-12-09
Categories :
Tech
Tags :
SQL Server
mdf
Import
mdf文件如何导入到sql server数据库
1.停掉 MSSQLSERVER, 将安装目录下C:\ProgramFile\MSS\MSSQL\Data\test.mdf 和 test_log.ldf文件移走
2.重启 MSSQLSERVER, 删除PUBS
3.将MDF文件移到安装目录下
4.在SQL查询分析器肿执行exec sp_attach_db 'test', 'C:\......\te...
1
Categories
All
Other
Private
School
Software
Tech
SmartKit
Marathon
Trip
Relax
Life