![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql server
zhangqihua0
这个作者很懒,什么都没留下…
展开
-
sql server 2005 存储分页
CREATE PROCEDURE [dbo].[P_GridViewPager] ( @recordTotal INT OUTPUT, --输出记录总数 @viewName VARCHAR(800), --表名 @fieldName VARCHAR(800) = '*', --查询字段 @keyName VARCHAR(200) = 'Id',原创 2012-05-31 15:42:14 · 341 阅读 · 0 评论 -
sql server 函数显示方形
declare @count int set @count=1 while @count begin print space(5-@count) + replicate('*', @count*2 -1) set @count = @count + 1 end set @count = 5 while @count >= 0原创 2012-05-15 09:51:16 · 263 阅读 · 0 评论 -
查询表中的总字段数、空字段与非空字段
select count(*) 总字段数, ISNULL(ISNULL(sum(case when isnullable=0 then 1 end),null),null) as 非空字段数 from syscolumns where id=object_id( 't_User ') //空字段总数 SELECT原创 2012-05-25 16:09:32 · 1551 阅读 · 0 评论 -
sql多表分组查询
select * from ( select t0=CONVERT(VARCHAR(10),[TimeStamp],120) from table0 S INNER JOIN ACDGroupMember M on S.LoginID=M.AgentID WHERE M.A原创 2012-11-14 12:07:17 · 728 阅读 · 0 评论 -
sql server 函数显示方形
declare @count int set @count=1 while @count begin print space(5-@count) + replicate('*', @count*2 -1) set @count = @count + 1 end set @count = 5 while @count >= 0原创 2012-11-14 12:10:39 · 257 阅读 · 0 评论