摘要: for ACCESS 数据库: update a, b set a.name=b.name1 where a.id=b.id for SQL Server 数据库: "update a set a.name=b.name1 from a,b where a.id=b.id" 以下在SQL Serve 阅读全文
posted @ 2009-07-24 19:03 emanlee 阅读(35172) 评论(1) 推荐(1) 编辑
摘要: -- Try:/* format (123) 456-7 to 123-4567 */ select SUBSTRING('(123) 456-7', 2, 3) + '-' + SUBSTRING('(123) 456-7', 7, 3) + SUBSTRING('(123) 456-7', 11... 阅读全文
posted @ 2009-07-24 19:03 emanlee 阅读(380) 评论(0) 推荐(0) 编辑