来自ipusr的博客一、表的创建sql语句:代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--CREATETABLE[tree]([node_id][int]NOTNULL,[node_name][varchar](20)COLLATEChinese... Read More
posted @ 2010-05-27 14:42 hevily Views(457) Comments(0) Diggs(1) Edit
select substring(quantityperunit,charindex('-',quantityperunit)+1,100) as 结果 from products[代码] Read More
posted @ 2010-05-27 12:04 hevily Views(1472) Comments(2) Diggs(2) Edit