摘要:
去空格 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 阅读全文