SQL Server

Preface : Before SQL Server 2005 and SQL Server 2008. If you want to encrypt sensitive data, such as financial information, payroll, or identity card numbers, you must use an external application or algorithm. SQL Server 2005 introduces the ability

SummaryThe use of 1,execThe use of 2,sp_executesqlMSSQL provides us with two commands for dynamically executing SQL statements, namely, exec and sp_executesql; Typically, sp_executesql has the advantage of providing an input-output interface that

One of the most important new features of the offset and fetch is the paging, since to analyze pagination, it is certainly to and before the paging way to compare, especially row_number (), in the comparison process, found quite a lot, but the most

This article applies to Microsoft SQL Server Reporting Services Brief introduction This white paper describes how to design a chart in a Microsoft SQL Server Reporting Services report. This article is divided into several sections and refers to

Original: A small SQL Server DBA wants to talk about the capabilities of SQL ServerA small SQL Server DBA wants to talk about the capabilities of SQL ServerBaidu has not yet searched for relevant individuals to write more valuable articles, at least

SQL Server dedicated Administrator connection (dedicated admin Connection (DAC))Only members of the SQL Server sysadmin role can use a DAC connection. By default, connections can only be established from clients running on the server.Open SSMs, in

Reprint Address: http://blog.csdn.net/rjc20098022/article/details/26958105At this URL http://www.microsoft.com/zh-cn/download/details.aspx?id=8961#filelist ...DescriptionNote: You must have administrative rights on the computer to install SSMSE.Step

Differences between text and varchar (max) data types in SQL ServerIt was only known that text and image were data types that could be retired by SQL Server, but it was not clear why the difference between text and varchar (max) and nvarchar (max)

This article will describe the SQL Server session for you to kill, has been in the Killed/rollback State Situation analysis, tutorial how to:Today, a very strange situation, found a session exception, this session is simply executing a simple stored

Microsoft has introduced many highly available technologies for SQL Server, such as early replication, later log shipping, database mirroring, SQL Server clustering, and so on. In SQL Server 2012 There is also a killer, and Oracle has a fight! SQL

The teammate gave me the statement to modify the data. Always fails to execute. I wonder. For example:Look carefully at this column, and there is nothing special. such as:But it does have a constraint: ' df__his_drug___all_i__04e4bc85 '. Why do we

OverviewSQL Server 2014 is known as a revolutionary version of Microsoft's database, and its performance has been boosted to the greatest extent ever.The updatable Columnstore index, as one of the key features of SQL Server 2014, is a significant

Original: http://www.cnblogs.com/yun_shuai/archive/2010/09/20/1831546.html/*1. Minor error (Severity level 0-10): By default, the client program is not sent an error message to continue working. Which means it can't be caught in a catch.2. Medium

Unique indexIf the primary key is not set to a clustered index when it is created, it must be a unique nonclustered index. In fact, the unique index, the name Incredibles, is that it requires the value on that column to be unique. A unique index

Original: SQL Server 2012:SQL Server architecture--The life cycle of a query (part 3rd) (end)A simple update queryYou should now know the query life cycle of reading only the data, and next determine what happens when you need to update the data.

  SQL Server database synchronization question sharing [unfinished, To be continued] (1) SQL Server database synchronization problem sharing (2) --- operation steps [unfinished, To be continued]    (1)ModifyFTPConnection During data

Ref: http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-precision-and-scale-problems   SQL Server precision and scale problemsby George mastros 24 Nov 2008,Categories:Data Modelling & design, Microsoft SQL Server Specified

The following articles mainly describe that the guid value is used as the row identifier in the SQL server data table. The GUID (Global unique identifier) is a globally unique identifier) it is a 16-byte binary value generated by the ID number on

Differences between varchar and nvarchar: Varchar (n)Variable-length and non-Unicode character data with a length of n Bytes. N must be a value between 1 and 8,000. The storage size is the actual length of the input data bytes, rather than n Bytes

When installing SQL Server 2008 or SQL Server, Microsoft SQL Server Native Client 10.0 is installed at the same time. If SQL Server 2005 of SQL Server Native Client is installed on the computer, SQL Server Native Client 10.0 will be installed in