摘要：SELECT 'private '+A.MyDataType+' '+A.COLUMNNAME+';' FROM ( Select A.name COLUMNNAME, B.name, CASE WHEN CHARINDEX('bigint',B.name)>0 then 'Long' WHEN CHARINDEX('int',B.name)>0 then 'Integer' ... 阅读全文

摘要：SELECT '| '+A.column_name+' | '+A.column_type+'('+cast(A.max_length as nvarchar(40))+')' +' | ' + CASE WHEN A.is_nullable = 1 THEN '是' ELSE '否' END +'| | |' FROM ( SELECT name AS c... 阅读全文

摘要：SELECT name AS column_name,TYPE_NAME(system_type_id) AS column_type, max_length,is_nullable FROM sys.columns WHERE object_id=OBJECT_ID(N'functions') 阅读全文

摘要：获取一段时间内所有月份 阅读全文