随笔分类 -  Sql

SQL Server Cast and Convert
摘要：CAST and CONVERT have similar functionality. CONVERT is specific to SQL Server, and allows for a greater breadth of flexibility when converting betwee 阅读全文
posted @ 2016-01-28 14:43 腻害的小笼包 阅读(132) 评论(0) 推荐(0)
Query runs slow via .NET
摘要：Slow in the Application, Fast in SSMS?Understanding Performance Mysteries An SQL text by Erland Sommarskog, SQL Server MVP. Last revision: 2013-08-30. 阅读全文
posted @ 2016-01-22 17:35 腻害的小笼包 阅读(301) 评论(0) 推荐(0)
SQL command
摘要：DBCC DROPCLEANBUFFERS DBCC FREEPROCCACHE select arithabort from SYS.DM_EXEC_REQUESTS where session_id = *** 阅读全文
posted @ 2016-01-22 17:30 腻害的小笼包 阅读(121) 评论(0) 推荐(0)
Sql 注入 学习笔记
摘要：以下是MSDN Magazine 里面的一段文章：http://msdn.microsoft.com/zh-cn/magazine/cc163523.aspx我很好奇这样到底能不能够注入SQL，所以我建了个 console 程序 static void Main(string[] ar... 阅读全文
posted @ 2014-05-09 14:25 腻害的小笼包 阅读(147) 评论(0) 推荐(0)