摘要:
去掉sql中的中文字符 CREATE FUNCTION [dbo].[fun_delchinese](@s nvarchar(max)) RETURNS nvarchar(MAX) AS BEGIN WHILE PATINDEX('%[吖-做]%', @s)>0 BEGIN SET @s=STUFF 阅读全文
摘要:
函数 ALTER function [dbo].[fn_Rollperiodin] ( @id VARCHAR(100) ) returns VARCHAR(1000) as BEGIN DECLARE @mess VARCHAR(1000) SET @mess='' declare @volume 阅读全文
摘要:
LINQ(Language Intergrated Query):集成查询语言 string[] array = { "1", "5", "6", "7" }; var query = from s in array select s; foreach(var aaa in query) { Con 阅读全文