摘要：1.由于最近用到mongodb但查询时前十分左右，用压力测试不太稳定，所以换成第三方引擎试试，但效果还是一样。具说第三方引擎比较给力，但在使用没有发现。现将mongodb切换wiredtiger引擎的配置如下； destination: file path: /soft/mongodb/log/lo... 阅读全文

摘要：set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGO/** create by huang qing* modify by chaoxueling* modify date 2013-05-15*/ALTER PROCEDURE [dbo].[sp_GetPropsTop_ByPropsCount]@PageIndexint,@PageSizeint,@OrderTypeintASBEGINif(@OrderType=1)beginwith Mem_TbUserPropsTop as(select A.*,b.PropsCountB,ROW_NUMBER() 阅读全文

摘要：在dataBase 菜单下Edit current DBMS-在Script\Objects\Table\TableComment和Script\Objects\Column\ColumnComment位置的直修改如下表的修改如下:EXECUTE sp_addextendedproperty N'MS_Description', N'%COMMENT%', N'user', N'dbo', N'table', N'%TABLE%', NULL, NULL列的修改如下:EXECUTE sp_addex 阅读全文

摘要：Select o.name AS tableName, c.name AS columnName, p.[value] AS DescriptionFROM sys.extended_properties p inner JOIN sysobjects oON o.id = p.major_id inner JOIN syscolumns c ON p.minor_id = c.colid and o.id=c.idAND (o.name = 'ActualReturnMoney')order BY o.name 阅读全文

摘要：//**创建临时表,用于存储批量准备的供应商信息 准入日期是按部门经理审批的时间**//if exists (select * from tempdb.dbo.sysobjects where id = object_id(N'tempdb..#Suppliertemp') and type='U') drop table #Suppliertempcreate table #Suppliertemp( ProjectId varchar(50), Supplierid varchar(50), SuplierAllowdate datetime)DECLARE 阅读全文