14 jiatongtong

尚未进行身份认证

我要认证

暂无相关简介

等级
TA的排名 2w+

VSS->TFS(SVN)->Git

VSS(Visual Source Safe)文件基本以独占的形势进行锁定。如果A在修改的时候B没有办法进行修改。 VSS只支持Windows版本,支持的开发工具仅支持微软系。 基于文件存储,服务器必须共享文件夹。安全性值得考虑。以前一般用于内网开发环境。 收费TFS(Team Foundition Server)centralized source controlTFS d...

2020-04-24 16:53:18

一定要用Entity Framework吗?

答案是不一定,即不一定要用EF;如果你是一个接触编程的时候,就是通过ef进行Database数据持久化的人来说,你就用ef,因为你对ef的一切都是感觉很自然的;而你是从ado,ado.net一路走过来的人,真的不一定要用EF;而且EF还是建立在ADO.net之上的框架,为什么我们要舍本逐末呢?EF是什么?有什么用?为什么要用EF?Entity Framework Co...

2020-04-24 15:41:25

关于ADO中ConnectionObject的理解

如果ADO的AdoConnection是直接通过赋值connectionObject获取的连接话,连接串里是没有包含密码信息的,这个时候试图通过这个对象获取密码是徒劳的,因为connectionObject本身就已经是一个连接的,即已经通过用户+密码创建好的连接了,这个时候理论上是不需要再保存密码了,所以这个对象里是没有密码的。但是用这个方式获取连接的方式有一个不好的地方就是:会...

2020-03-12 14:57:14

SQL Server Connection flow under DMV

2020-03-06 11:29:16

SQL SERVER中获取错误号

使用ERROR_NUMBER函数;Return TypesintReturn ValueWhen called in a CATCH block,ERROR_NUMBERreturns the error number of the error that caused the CATCH block to run.ERROR_NUMBERreturns NULL when...

2019-11-21 17:30:21

SQL SERVER中的几种连接,以及各自的最终效果

SqlServer中包含以下几种连接:Inner Join:要求指定字段的值,必须在关联的两个数据中同时存在; Left Join:要求指定字段的值,在两个数据集中同时存在,或者在左边数据集中存在,但是在右边数据集中不存在的; Right Join:要求指定字段的值,在两个数据集中同时存在,或者在右边数据集中存在,但是在左边数据集中不存在的; Full Join :最终结果是,指定字段值...

2019-10-17 11:39:42

明明字符串完全一样,为什么条件不执行?

在sqlserver中检查字符串的时候,切忌使用select输出的表格中数据(这些数据有时会误导你);如下面脚本:DECLARE @tmpVar1 VARCHAR(200)='55057400@WARM ORANGE 011 SP09 011'DECLARE @tmpVar2 VARCHAR(200)='55057400@WARM ORANGE 011 SP09 011'SELEC...

2019-09-27 16:41:34

Why SQL Updates Fail – Five Reasons(为什么SQL SERVER更新失败-五个原因)

"The SQL command ran, there's no error message but nothing changed! What's going on? Do you think it's a virus? Maybe there's a bug in .NET!"The junior programmer was almost in tears when he came to...

2019-09-25 17:31:38

LEN() vs DATALENGTH() in SQL Server

When usingT-SQLinSQL Server(or Azure) theLEN()andDATALENGTH()functions will often return the same result, but not always. There are some cases where these functions will return completely diff...

2019-08-17 20:27:59

Converting Between Base 2, 10 and 16 in T-SQL

There are manynumeral systems, the most common ones in computer science beingbinary(base 2),decimal(base 10) andhexadecimal(base 16). All numbers can be expressed in either system and you may n...

2019-08-17 20:25:59

Hash Algorithms – How does SQL Server store Passwords?

https://sqlity.net/en/2460/sql-password-hash/IntroductionI am often asked how SQL Server protects the passwords for SQL Logins. We know already that the passwords are hashed and that the hashed va...

2019-08-17 20:21:33

Is Sybase DB Syntax Same As Sql Server Database

原文地址:https://www.mypassionfor.net/2016/04/21/is-sybase-db-syntax-same-as-sql-server-database/Sybase is another Relational Database Management System (RDBMS), it has long well established history. T...

2019-07-26 11:35:46

Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared

原文:https://docs.oracle.com/cd/B10501_01/win.920/a97248/ch2.htmThis chapter contains information comparing the Microsoft SQL Server and Sybase Adaptive Server database and the Oracle database. It ...

2019-07-26 11:29:57

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

ermrlehkara,2015-12-30(first published:2015-12-17)Hi Guys,When you generate ascript to create a Stored Procedure, belowthree statements are generate by default.SET ANSI_NULLS onSET NOCOU...

2019-07-24 18:16:31

SET Statements (Transact-SQL)

APPLIES TO:SQL ServerAzure SQL DatabaseAzure SQL Data WarehouseParallel Data WarehouseThe Transact-SQL programming language provides several SET statements that change the current session handli...

2019-07-24 18:13:56

Understanding SET QUOTED_IDENTIFIER ON/OFF and SET ANSI_NULLS ON/OFF

Written by Ranjith inSQL ServerThese are the two widely used SET options in SQL Server. Most developers explicitly set these options while creating Stored Procedures, Triggers and User Defined Func...

2019-07-23 20:54:19

SELECT 失败,因为下列 SET 选项的设置不正确: 'QUOTED_IDENTIFIER'。问题处理

错误提示:SELECT 失败,因为下列 SET 选项的设置不正确: 'QUOTED_IDENTIFIER'。请确保 SET 选项正确无误,可以用于 计算列上的索引视图和/或索引和/或筛选的索引和/或查询通知和/或 XML 数据类型方法和/或空间索引操作。。错误再现:--SET QUOTED_IDENTIFIER ON --GOCREATE PROCEDURE usp_tes...

2019-07-23 20:46:59

SQL Server Rounding Methods

byGeorge Mastros (gmmastros)on December 11, 2008 in categoryData Modelling and Designhttps://blogs.lessthandot.com/index.php/datamgmt/datadesign/sql-server-rounding-methods/There are various wa...

2019-07-12 17:51:19

Data types (Transact-SQL)

APPLIES TO:SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data WarehouseParallel Data WarehouseIn SQL Server, each column, local variable, expression, and parameter has a related dat...

2019-07-10 11:02:28

Newtonsoft.Json高级用法,json序列号,model反序列化,支持序列化和反序列化DataTable,DataSet,Entity Framework和Entity,字符串

原文地址:https://www.cnblogs.com/yanweidie/p/4605212.html 手机端应用讲究速度快,体验好。刚好手头上的一个项目服务端接口有性能问题,需要进行优化。在接口多次修改中,实体添加了很多字段用于中间计算或者存储,然后最终用Newtonsoft.Json进行序列化返回数据,经过分析一个简单的列表接口每一行数据返回了16个字段,但是手机APP端只用到了其中7...

2019-07-05 09:51:52

查看更多

勋章 我的勋章
  • 持之以恒
    持之以恒
    授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里,不积小流无以成江海,程序人生的精彩需要坚持不懈地积累!
  • 勤写标兵Lv1
    勤写标兵Lv1
    授予每个自然周发布1篇到3篇原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。