- 博客(5)
- 收藏
- 关注
RSS订阅原创 Mysql和Sql Service语法和关键字区别
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需要为表指定存储类型
2013-07-16 14:15:31
660
原创 Linq基本筛选
DataTable dtDecAccep = Syswin.Include.Helper.DBHelper.Common.SqlHelper.GetDataTable(this.CurrentUser, strDecAccepSql);int Result = (from item in dtDecAccep.AsEnumerable() where item.GetString("Audit
2013-07-15 23:40:55
434
原创 Sql转意拼接
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) +(ca
2013-07-15 23:30:32
547
原创 函数和游标
if exists(select 1 from sysobjects where id=object_id('St_FunPostDayTimeout')) drop Function St_FunPostDayTimeoutgoCreate Function St_FunPostDayTimeout()returns varchar(2000)as
2013-07-15 23:27:18
608
原创 文件上传下载
客户端：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 StarWin
2013-07-15 23:24:04
653
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人