08 2013 档案
摘要:客户端:using System;using System.Collections.Generic;using System.Linq;using System.Text;using Syswin.Control;using System.Windows.Forms;using StarWind;using StarWind.Lang;using StarWind.Controls;using StarWind.Window;using Syswin.Property.Include.Cache.Common;using System.Data;using System.IO;using Sy
阅读全文
摘要:GetWorkPosNameselect b.ID,((select OrganizationName from :EOPDBName..vw_All_Organization c where c.ID=b.OrgID)+'_'+(case when b.GrpName is null then '' else b.GrpName+'_' end) +(case when b.BudName is null then '' else b.BudName+'_' end)+(case when b.UnitNo is
阅读全文
摘要:if exists(select 1 from sysobjects where id=object_id('St_FunPostDayTimeout'))drop Function St_FunPostDayTimeoutgoCreate Function St_FunPostDayTimeout()returns varchar(2000)asbegindeclare MyCursor cursorfor (select distinct count(budid) countBudid ,budid,budname from vw_WorkOrdWarning a inne
阅读全文
摘要:1. MySQL支持enum,和set类型,SQL Server不支持2. MySQL不支持nchar,nvarchar,ntext类型3. MySQL的递增语句是AUTO_INCREMENT,而MS SQL是identity(1,1)4. MS SQL默认到处表创建语句的默认值表示是((0)),而在MySQL里面是不允许带两括号的5. MySQL需要为表指定存储类型6. MS SQL识别符是[],[type]表示他区别于关键字,但是MySQL却是 `,也就是按键1左边的那个符号7. MS SQL支持getdate()方法获取当前时间日期,但是MySQL里面可以分日期类型和时间类型,获取当前日
阅读全文
摘要:DataTable dt=SqlHelp.DataSource(strsql); var vardt = from t in dt.AsEnumerable() group t by t.Field("sclass") into g where g.Count()>1 select g; var query = from t in dt.AsEnumerable() ...
阅读全文