摘要:
一.sql分页:先分页后多表连接查询 declare @row int; select @row=COUNT(*) from BS_Subject where 1=1; SELECT TOP 10 @row as Record, a.*,c.ClassName FROM BS_Subject a l 阅读全文
摘要:
$(window.parent.document).find("#ContentIframe").load(function() { var main = $(window.parent.document).find("#ContentIframe"); var thisheight = $(document).height(); if (thisheight < 800) thisheight = 800; ... 阅读全文
摘要:
declare @count3 int,@count7 int,@count int,@countMore int;select @count3=count(*) from Exam_QuesContent where DateDiff(d,addDate,getdate())<3 --最近三天select @count7=count(*) from Exam_QuesContent where DateDiff(d,addDate,getdate())<7 --最近七天select @count=count(*) from Exam_QuesContent where DateD 阅读全文
摘要:
Call me Ishmael. Some years ago – never mind how long precisely – having little or no money in my purse, and nothing particular to interest me on shore, I thought I would sail about a little and see the watery part of the world. It is a way I have of driving off the spl... 阅读全文
摘要:
create FUNCTION fn_GetSimilar ( @StrA As Varchar(255), --传入的待比较的字符 @StrB As Varchar(255) --期望字符)RETURNS int ASBEGIN DECLARE @Result int declare @lenA int declare @lenB int declare @lenSameA int declare @lenSameB int set @lenA=len(@StrA) set @lenB=len(@StrB) -... 阅读全文