摘要: 去空格 replace(ltrim(rtrim(phone)),' ','')字符串轉化成整數 select MAX(convert(bigint,(replace(ltrim(rtrim([EmployeeNo])),' ',''))))--sql Function 函數:create function fn_IsWorkDay(@date datetime)returns bitasBEGINdeclare @IsWorkDay bitdeclare @WeekDayNum intdeclare @Type varchar(1 阅读全文
posted @ 2013-02-21 14:26 sirili 阅读(142) 评论(0) 推荐(0) 编辑