(sql字符串函数说明.docVIP

sql字符串函数说明.txt丶︶￣喜欢的歌，静静的听，喜欢的人，远远的看我笑了当初你不挺傲的吗现在您这是又玩哪出呢？死亡循环 淡定 如果有一天晚上，你从家里出去，你发现楼梯一直往下延伸，永远没有尽头，你永远找不到出口，你会怎么想？ 爱情没有永恒，只有彼此的慰藉和责任。 {0:P}百分号格式化字符串 A brother is only a fame//legend哥只是个传说 CREATE PROCEDURE proc_parameterNumber @SingleNumberId varchar(10), @SingleNumber varchar(10) output AS BEGIN if not exists (select * from SingleNumber where SingleNumberId=@SingleNumberId) begin set @SingleNumber= return end else begin declare @Prefixion varchar(10) declare @Number bigint declare @Width tinyint select @Prefixion=Prefixion,@Number=Number,@Width=Width from SingleNumber where SingleNumberId=@SingleNumberId update SingleNumber set Number=Number+1 where SingleNumberId=@SingleNumberId declare @currentNumber varchar(100) @currentNumber=00000000000000000000000+@Number set @SingleNumber=@currentNumber end END GO /// summary /// 添加项目对应的课程 /// /summary /// param name=courseIds课程Id数组/param /// param name=projectId项目id/param public static void AddCourseSettings(int[] courseIds, string projectId) { SqlParameterList splist = new SqlParameterList(); splist.AddAParameter(@ProjectId, SqlDbType.Char, 8, projectId); string strSql = ; for (int i = 0; i courseIds.Length; i++) { splist.AddAParameter(@CourseId + i.ToString(), SqlDbType.Int, courseIds[i]); strSql += string.Format(@ if exists(select * from CourseSetting where ProjectId=@ProjectId and CourseId=@CourseId{0}) return; else insert into CourseSetting(ProjectId,CourseId) values (@ProjectId,@CourseId{0}); end, i); DataAccessor.ExecuteSqlOnly(strSql, false, splist); } } declare @PayAbleTuition int --应交费用 select @PayAbleTuition=PayAbleTuition from PayCondition where PayConditionId=1 if not exists (select TuitionId from Tuition where PayConditionId=1) --预交 一次交清 保留 @TuitionAmount：当前所交费用 begin if(@TuitionAmount@PayAbleTuition) select 预交 else if(@TuitionAmount=@PayAbleTuitio