philzhou

导航

2011年12月15日 #

Programmatically Retrieving a Stored Procedure's Parameters 获取Sql Server 存储过程参数

摘要： 原文 IntroductionStored procedures in SQL Server are similar to methods in C# and Visual Basic code. They encapsulate one or more statements into a single, parameterized construct. Both stored procedur... 阅读全文

posted @ 2011-12-15 19:23 philzhou 阅读(356) 评论(0) 推荐(0) 编辑

Convert DateTime To Varchar with multiple Styles

摘要： 原文 What are the valid styles for converting datetime to string? I wrote this little table and procedure to help me remember what style 112 did, or how to get HH:MM AM/PM out of a DATETIME column. Bas... 阅读全文

posted @ 2011-12-15 09:27 philzhou 阅读(285) 评论(0) 推荐(0) 编辑