摘要:
/// /// 判断输入的字符串是不是数字,不是返回True,否则返回False /// /// /// public static bool IsNum(string text) { for (int i = 0; i /// 判断输入的字符串全是字符不包括数字,不是返回false,否则返回true 20100728 /// /// /// public static bool IsChar(string text) { int count = 0; for (int i = 0; i < text.Length; i++) { if (!Char.IsNumber(te... 阅读全文
摘要:
update dbo.VersionsTree set parentId=d.ss from (SELECT Reverse(SUBSTRING(SUBSTRING(Reverse(metacode),(LEN(metaid)+4),LEN(metacode)),0,Charindex('||',SUBSTRING(Reverse(metacode),(LEN(metaid)+4),LEN(metacode)),1))) as ss,metaCode FROM [repositoryShop].[dbo].[VersionsTree]) as d where VersionsT 阅读全文