<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[topcool（狂热者）的专栏]]></title><description><![CDATA[嗨！欢迎来到topcool（狂热者）专栏]]></description><link>https://blog.csdn.net/topcool</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; topcool]]></copyright><item><title><![CDATA[判断SQL是否区分大小写？？]]></title><link>https://blog.csdn.net/topcool/article/details/263563</link><guid>https://blog.csdn.net/topcool/article/details/263563</guid><author>topcool</author><pubDate>Sat, 22 Jan 2005 11:09:00 +0800</pubDate><description><![CDATA[select case   when (a=A) then 不区分大小写 else 区分大小写 endgo ]]></description><category></category></item><item><title><![CDATA[快速查询表中各字段的长度？]]></title><link>https://blog.csdn.net/topcool/article/details/263553</link><guid>https://blog.csdn.net/topcool/article/details/263553</guid><author>topcool</author><pubDate>Sat, 22 Jan 2005 11:05:00 +0800</pubDate><description><![CDATA[select object_name(id) as 表名      ,c.name as 字段名      ,t.name 数据类型      ,c.prec as 长度from syscolumns c      inner join       systypes t       on c.xusertype=t.xusertype  where object_name(id)=Table ]]></description><category></category></item><item><title><![CDATA[如何才能快速知道数据库中每个表的大小？]]></title><link>https://blog.csdn.net/topcool/article/details/263546</link><guid>https://blog.csdn.net/topcool/article/details/263546</guid><author>topcool</author><pubDate>Sat, 22 Jan 2005 10:56:00 +0800</pubDate><description><![CDATA[sp_spaceused显示行数、保留的磁盘空间以及当前数据库中的表所使用的磁盘空间，或显示由整个数据库保留和使用的磁盘空间。语法sp_spaceused [[@objname =] objname]    [,[@updateusage =] updateusage]参数[@objname =] objname是为其请求空间使用信息（保留和已分配的空间）的表名。objname 的数据]]></description><category></category></item><item><title><![CDATA[在sql server中怎样求本月天数？]]></title><link>https://blog.csdn.net/topcool/article/details/263543</link><guid>https://blog.csdn.net/topcool/article/details/263543</guid><author>topcool</author><pubDate>Sat, 22 Jan 2005 10:53:00 +0800</pubDate><description><![CDATA[注意：2月份有闰有平！select 本月天数=day(dateadd(dd,-1,cast(convert(varchar(6),dateadd(mm,1,getdate()),112)+01 as datetime))) ]]></description><category></category></item></channel></rss>