摘要:
1.函数解释len()是用来计算字符串长度left()是用来截取指定部分的字符串2.sql语句:select id,pid from tborder by case when pid=0 then left('00000',5-len(id))+convert(varchar,id) when pi 阅读全文
摘要:
--分页存储过程if (object_id('pro_page', 'P') is not null) drop proc pro_stugocreate procedure pro_stu( @pageIndex int, @pageSize int)as declare @startRow in 阅读全文