paul_cheung

导航

随笔分类 -  DB

convert return char from sql server 2008 r2 or below version to c#
摘要：C# string.Replace((char)13, ' ') //newline char; string.Replace((char)10, ' ') //return char; 阅读全文

posted @ 2015-04-20 20:54 paul_cheung 阅读(109) 评论(0) 推荐(0)

backup all sql server databases
该文被密码保护。

posted @ 2014-09-17 18:02 paul_cheung 阅读(1) 评论(0) 推荐(0)

sql 分页
摘要：最简单的分页（没考虑效率） SELECT TOP 10 [Id],[ReflectionId],[CreatorUserId],[Type],[Text],[AttachmentsJson],[CreatedTime] FROM [LeadersCorporationDB].[dbo].[ReflectionLog] WHERE [ReflectionId]='2769D3CB-BB5C-47A1-9BF3-00C16614C4EB' AND Id NOT IN(SELECT TOP ((2-1)*10+1) Id FROM [LeadersCorporationDB].[db 阅读全文

posted @ 2014-02-14 11:23 paul_cheung 阅读(99) 评论(0) 推荐(0)

sql server restore DB issue
摘要：error occurs when restoring the backup file of sql server(DB.bak)to run the above t-sql will shoot this issue! nothing else to do!原文内容引用：http://www.cnblogs.com/adandelion/archive/2006/09/30/519534.html 阅读全文

posted @ 2013-12-19 23:22 paul_cheung 阅读(153) 评论(0) 推荐(0)

datetime is null
摘要：本文转载自阿单《datetime is null》datetime 以'YYYY-MM-DD HH:MM:SS'格式检索和显示DATETIME值同时当datetime 为 null时，选取相关数据使用：SELECT * FROM process WHERE date_inserted is null;并不是使用：SELECT * FROM process WHERE date_inserted =null; 阅读全文

posted @ 2013-07-15 17:09 paul_cheung 阅读(178) 评论(0) 推荐(0)