06 2015 档案
摘要:不能传入out或ref public IEnumerable GetShop() { for (int i = 1; i < 11; i++) { yield return new Shop ...
阅读全文
摘要:ALTER FUNCTION [dbo].[fu_GetCaption](@Stage nvarchar(50),@T_stage_weeks int,@S_stage_months int,@RowNum int --第几行)RETURNS nvarchar(260)ASBEGINDeclare ...
阅读全文
摘要:/*SELECT dbo.fn_PadLeft('8', '0', 6) */create function fn_PadLeft(@num nvarchar(16),@paddingChar char(1),@totalWidth int)returns nvarchar(16) asbegin...
阅读全文
摘要:DROP TABLE #MTDDECLARE @startDate date = '20150601' ,@endDate date = cast(getdate() as date)CREATE TABLE #MTD(bydate date)DECLARE @count int = D...
阅读全文