数据库
paranoid_luo
这个作者很懒,什么都没留下…
展开
-
解析IP地址连接SQL数据库速度慢的原因
错误现象当安装 Microsoft 数据访问组件 (MDAC) 版本 2.6 后,每次尝试使用 IP 地址(而不是服务器名称)连接到 SQL Server 7.0 或 SQL Server 2000 数据库时所花的时间可能比预期的要长。在某些报告的情况中,其表现为向客户端应用程序报告“超时已过期”错误,而且连接尝试失败。请注意,如果您使用的是映射到 TCP/IP 地址的服务器别名,则可原创 2010-04-14 15:55:00 · 235 阅读 · 0 评论 -
Using self join in Update statement
Using self join in Update statement原创 2011-03-30 11:47:00 · 225 阅读 · 0 评论 -
About SQL Server 'GO'
About SQL Server 'GO'原创 2010-11-25 11:16:00 · 311 阅读 · 0 评论 -
Using Raiserror to fail 'execute script task' in SSIS
Using Raiserror to fail 'execute script task' in SSIS原创 2010-12-08 18:17:00 · 280 阅读 · 0 评论 -
What Every DBA Ought to Know About SQL Server Cursors (and Their Alternatives)
Cursors provide a means of processing through a set of records row-by-row. However, many companies have a policy against using cursors in their SQL Server standards. This article examines the problem with cursors and alternatives to using them.转载 2010-09-23 15:55:00 · 200 阅读 · 0 评论 -
Sql中NOT IN对于null值的处理
表T1(C1 int)C1------102030执行查询1:select * from T1 where C1 in(10, 20,null)返回:C1------1020结果没问题如果执行查询2:select * from T1 where C1 not in(10, 20,null)则返回空结果集原因如下:sql对in操作符在逻辑上原创 2010-05-04 11:09:00 · 723 阅读 · 0 评论 -
Build Query for multiple fields filter
Requirement: Build one filter query based on input parameter(s), if input=v1, filter no records, else return rows which satisfy column=inputImplementation:select * from t1where (v1=@input1 or c1原创 2012-08-28 11:17:48 · 305 阅读 · 1 评论