aiwukou4718-CSDN博客

转载 SQL Server 2008 中使用SQLDMO 备份数据还原数据等

http://blog.csdn.net/yanzhibo/article/details/21485343 转载于:https://www.cnblogs.com/Vlaner/p/3981772.html

2014-09-19 16:31:00 101

转载每个分类取5条, Sql解决方法

一。select * from(select ID,ShopClient_ID,Name,Icon,HitCount,Class1_ID,row_number() over(partition by Class1_ID order by HitCount desc)as rowindex from tab_Goods)awhere rowindex<=5 二。SELECT * ...

2014-06-26 13:51:00 375

转载 sqlserver2008R2 尚未注册 OLE DB 访问接口...

http://wenku.baidu.com/link?url=7ZBtIEQr6iAdQrpx2O7Z6s-gPwatltWsPwWY74qyBiJYiyZI5aGQ7wJNsnt5IRicb2d8C0upAnoqtXTOBMyrqnRwlscx9-o5sYmz6namGJW 转载于:https://www.cnblogs.com/Vlaner/p/3804083.html...

2014-06-23 15:21:00 83

转载 sql行列互转

--=================行专列=======================--if object_id('tb')is not null drop table tb--go--create table tb(姓名 varchar(10),课程 varchar(10),分数 int)--insert into tb values('张三','语文',74)--insert ...

2014-05-18 16:57:00 95

转载用户角色权限设计思路

http://blog.csdn.net/fmx121586/article/details/8025268 转载于:https://www.cnblogs.com/Vlaner/p/3564769.html

2014-02-24 15:52:00 75

转载树节点类型数据的Datatable转Json

private static string GetTasksString(int TaskId, DataTable dt) { DataRow[] rows = dt.Select("ParentID=" + TaskId.ToString()); if (rows.Length == 0) return string.Em...

2014-02-24 15:48:00 84

转载 [C#]最简单的Base64加密解密

/// <summary>/// Base64加密，解密方法/// </summary>/// <paramname="s">输入字符串</param>/// <paramname="c">true-加密,false-解密</param>static public string base64(string s, bo...

2014-02-20 11:35:00 122

转载 WEB打印控件Lodop(V6.x)使用说明及样例

WEB打印控件Lodop(V6.x)使用说明及样例:http://www.hbsszx.com/lodop/PrintSampIndex.html 转载于:https://www.cnblogs.com/Vlaner/p/3544860.html

2014-02-11 17:58:00 106

转载 js代码设为首页加入收藏

// JavaScript Document // 加入收藏 <a onclick="AddFavorite(window.location,document.title)">加入收藏</a> function AddFavorite(sURL, sTitle) { try { window.external.ad...

2014-01-15 10:22:00 82

转载 Json字符转化成对象

//后台 string jsonArray ="";//此处json对象的属性必须和类库一样JavaScriptSerializer json = new JavaScriptSerializer();List<payParameter> list = new List<Reconciliation.payParameter>();payPar...

2014-01-06 19:26:00 71

转载函数和游标

if exists(select 1 from sysobjects where id=object_id('St_FunPostDayTimeout'))drop Function St_FunPostDayTimeoutgoCreate Function St_FunPostDayTimeout()returns varchar(2000)asbeginde...

2013-08-16 21:03:00 77

转载 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-08-16 21:02:00 73

aiwukou4718的博客