摘要：begin try--SQL end trybegin catch --sql (处理出错动作)end catch我们将可能会出错的sql 写在begin try...end try 之间，若出错，刚程序就跳到紧接着的begin try...end try 的beign catch...end catch中，执行beign catch...end catch错误处理SQL。try..catch 是... 阅读全文

摘要：1.查询特殊表达式所在的存储过程：select * from sys.sql_modules where definition like '%1900017%' and object_id in (select object_id from sys.objects where type='P')2.查询一个表被哪些存储过程使用：exec sp_depends 'ffunit'3.通过表找找字段:s... 阅读全文

摘要：C#编程之路（牛人之作）：http://www.cnblogs.com/BeginnerClassroom/archive/2009/09/23/1572948.html 阅读全文

摘要：select max(case when a < 1 then '' else '1*'+cast(a as varchar)+'='+cast(a*1 as varchar) end) as [1], max(case when a < 2 then '' else '2*'+cast(a as varchar)+'='+cast(a*2 as varchar) end) as [... 阅读全文