数据库
文章平均质量分 60
_iorilan
10年以上软件工程经验,先后从事在线教育/IT金融/即时通信/政府/物流平台/零售/门禁/监控等领域。专注夯实基础/项目成本与架构平衡/框架调研/团队高效协同工作
展开
-
sql 连接字符串大全
原文:http://blog.csdn.net/tjvictor/article/details/4726027自己看吧。市面上能找到的大部分数据库都在这里了。 http://www.connectionstrings.com/附个图。无图无真相。转载 2011-08-02 09:57:49 · 1119 阅读 · 0 评论 -
SQL server replication的三种方式
SQL server replication的三种方式原创 2016-10-31 22:32:34 · 2898 阅读 · 0 评论 -
Sql server Group by 统计数量 order by时间
Sql server Group by 统计数量 order by时间原创 2016-07-14 18:09:23 · 4070 阅读 · 0 评论 -
修改Sql Server ISOLATION LEVEL的3种方式
修改ISOLATION LEVEL的3种方式原创 2016-05-25 17:14:40 · 7303 阅读 · 0 评论 -
查看实时Mongodb query 命令
查看实时Mongodb query原创 2015-12-21 11:36:27 · 2177 阅读 · 0 评论 -
C# 操作MongoDb 错误Element '_v' does not match any field or property of class XXX
C# 操作MongoDb 错误Element '_v' does not match any field or property of class XXX原创 2015-01-06 20:47:05 · 5135 阅读 · 0 评论 -
本地配置 MongoDb
本地配置 MongoDb原创 2015-01-04 20:09:56 · 1699 阅读 · 0 评论 -
Sql Server查询远程db 表数据到本地
Sql Server查询远程db 表数据到本地原创 2014-10-20 14:37:09 · 1748 阅读 · 0 评论 -
No Sql Db Introduction
No Sql Db 简介原创 2014-03-28 23:00:25 · 1365 阅读 · 0 评论 -
Sql Server递归查询实例
Sql Server递归查询实例原创 2017-01-02 21:20:51 · 1632 阅读 · 0 评论 -
SQL -- 使用PARTITION和RANK函数完成统计
SQL -- 使用PARTITION和RANK函数完成统计原创 2017-01-02 21:58:42 · 7503 阅读 · 0 评论 -
MSSQL Group by 年月日
MSSQL Group by 年月日原创 2017-11-18 21:33:47 · 1651 阅读 · 0 评论 -
MS sqlserver数据库恢复出错 database is in use can not be restored
MS sqlserver数据库恢复出错 database is in use can not be restored原创 2017-11-18 21:19:05 · 4459 阅读 · 3 评论 -
SSIS DSN contains an architecture mismatch between the Driver and Application
SSIS DSN contains an architecture mismatch between the Driver and Application原创 2017-11-18 20:39:34 · 6568 阅读 · 0 评论 -
SQL批处理 导入excel数据到表
SQL批处理 导入excel数据到表原创 2017-10-18 18:25:41 · 1420 阅读 · 0 评论 -
SQL SERVER - 使用MERGE语句完成单向表同步
SQL SERVER - 使用MERGE语句完成单向表同步原创 2017-04-16 20:42:02 · 1278 阅读 · 0 评论 -
导入EXCEL到sql server
导入EXCEL到sql server原创 2017-04-06 17:34:45 · 1522 阅读 · 2 评论 -
SQL Server 2014 查询大全
SQL Server 2014 查询大全原创 2017-02-05 16:13:19 · 2966 阅读 · 0 评论 -
SQL SERVER 2014 进行Trouble Shooting的一些查询
SQL SERVER 2014 进行Trouble Shooting的一些查询原创 2017-03-17 10:10:24 · 878 阅读 · 0 评论 -
Unit Of Work Pattern(ORM Transaction Controller) Implementation Sample
1. Transaction Unit Entity public class TransactionUnitBase { public ActionType ThisActionType { get; set; } } public class TransactionUnit : TransactionUnitBase {原创 2013-11-18 16:31:48 · 1588 阅读 · 0 评论 -
Data Row To TEntity Mapping
Data Row and Entity Mapping SummaryDataRow to Entity public static TEntity DataRowToTEntity(IDataReader reader) where TEntity : new() { var props = typeof(TEntity).GetPropert原创 2013-11-18 16:17:05 · 1346 阅读 · 0 评论 -
get table info by column name
in sql server .if you only know the column name but forget the table name(ussally in large systems ) , try this :SELECT COLUMN_NAME,* FROM INFORMATION_SCHEMA.COLUMNSwhere COLUMN_NAME = 'Task原创 2013-02-15 12:38:02 · 1214 阅读 · 0 评论 -
Loop and Temp Table usage in SQL SERVER
Loop and Temp Table usage in SQL SERVER Target :To use Loop(may also use nested loop when needed) to fetch data then save into result table ,return result tablesteps :1.declare a resul原创 2013-06-21 12:27:16 · 1591 阅读 · 0 评论 -
sql server store procedure summary part1
1.ISNULL() function select ISNULL(AgentCode,'-') as AgentCode from cm.FrmAddressForService order by CreatedDate desc;if agentcode is null , then replace by '-'2.assigned value from a query原创 2013-01-02 18:01:22 · 1117 阅读 · 0 评论 -
Sql server 2008 R2 Forget Password for Sa
Open the command prompt (Right-Click on and select "Run As Administrator")From the command prompt type net stop MSSQLSERVERNext type net start MSSQLSERVER /mOpen SQL Server Management Studio. Do not l原创 2013-06-05 17:50:12 · 1561 阅读 · 0 评论 -
Create Job in Sql server
step 1: Enable Sql server Agent Servicestep 2 : Start Sql Server , you will see the Agent step 3: right click "jobs" folder ,add new job give a name to the job . step 4 : add your原创 2013-03-22 14:47:22 · 1596 阅读 · 0 评论 -
sql server return xml result
forward from :http://www.simple-talk.com/sql/learn-sql-server/using-the-for-xml-clause-to-return-query-results-as-xml/SQL Server lets you retrieve data as XML by supporting the FOR XML转载 2013-01-03 15:59:53 · 1281 阅读 · 0 评论 -
Row_Number usage
Row_Number() over(partition , order by) usage .foward form :http://msdn.microsoft.com/en-us/library/ms186734.aspxA. Returning the row number for salespeopleThe following exa转载 2013-01-02 15:39:28 · 1143 阅读 · 0 评论 -
sql 2005 用户 sa 登录失败,该用户与可信SQL Server连接无关联 错误18452
转自:http://www.cnblogs.com/sjrhero/articles/1814442.html解决方案'用户 'sa' 登录失败。该用户与可信 SQL Server 连接无关联问题一、忘记了登录Microsoft SQL Server 2005 的sa的登录密码解决方法:先用windows身份验证的方式登录进去,然后在‘安全性’-‘登录’转载 2012-09-04 18:34:50 · 1066 阅读 · 0 评论 -
how to execute sql script in c#
A . Creating a Visual C# SMO project in Visual Studio.NETStart Visual Studio 2008 (or Visual Studio 2005).On the File menu, click New Project. The New Project dialog box appears.原创 2013-03-09 22:31:02 · 1704 阅读 · 0 评论 -
get table names and table columns from db
private const string SqlGetAllTables = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' "; private string SqlGetAllColumns = "SELECT COLUMN_NAME,DATA_TYPE原创 2013-03-09 22:28:31 · 1307 阅读 · 0 评论 -
Db Attribute(Custom ORM ) Usage
Db Attribute Usage 1. Attribute DefinationDb [AttributeUsage(AttributeTargets.Class | AttributeTargets.Struct, AllowMultiple = false, Inherited = true)] public class DataBaseAttribute : Sys原创 2013-11-18 16:23:29 · 1455 阅读 · 0 评论 -
Ado.net Provider Summary
Ado.Net Provider Summary //=======================================================================================Data Set Operation using System.Data;using System.Data.SqlClient;using DotData原创 2013-11-18 16:11:38 · 1477 阅读 · 0 评论 -
sql server 数据库语句
一、基础1、说明:创建数据库Create DATABASE database-name2、说明:删除数据库drop database dbname3、说明:备份sql server--- 创建 备份数据的 deviceUSE masterEXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind转载 2012-01-31 17:44:19 · 1211 阅读 · 0 评论 -
ms sql常用语句汇总
转自:http://www.cnblogs.com/Dlonghow/archive/2009/05/19/1460179.html--聚合函数use pubsgoselect avg(distinct price) --算平均数from titleswhere type='business'go use pubsgose转载 2012-01-31 15:17:28 · 1194 阅读 · 0 评论 -
sql 选择两列中最大的那列
sql忘完了,最近要好好补补了。从表table中取出A和B两列中值最大的那列。select A = (case when A > B then A else B end )from Table_1;原创 2012-01-31 15:14:23 · 5078 阅读 · 0 评论 -
sql find out record one-to-one
one case can has multiple classes case : class = 1:nfind out the case number which has only one class.select * from hm.[Class] where CaseFK in(select CaseFK clsCount from hm.[Class] group原创 2013-01-02 14:20:45 · 1006 阅读 · 0 评论 -
create store procedure error: invalid object name
my procedure is :SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [HM].[prInsertClass](@Id uniqueidentifier, @CaseFK uniqueidentifier, @ClassNbr varchar(2),原创 2012-12-28 19:12:16 · 1332 阅读 · 0 评论 -
sql server call c# assembly
reference :http://www.codeproject.com/Articles/19954/Execute-NET-Code-under-SQL-Server-2005in some situations , will need to make a call from sql server back to the c# code .if not , will原创 2013-02-18 14:26:24 · 1936 阅读 · 0 评论 -
SSIS 获取当天日期
SSIS 获取当天日期原创 2017-11-18 21:49:52 · 4339 阅读 · 0 评论