SQL Server

Original address: http://dufei.blog.51cto.com/382644/1384210/SQL Server AlwaysOn Architecture and principlesDuffyThe AlwaysOn technology supported by SQL Server2012 centralizes the benefits of failover clustering, database mirroring, and log

1. Read the Excel data to the dataset Public StaticSystem.Data.DataSet Excelsqlconnection (stringFilePathstringtableName) { stringStrcon ="Provider=Microsoft.Jet.OLEDB.4.0;Data source="+ filepath +"; Extended properties= ' Excel 8.0;

View the port number background for SQL ServerThese days you want to write a database connection test program that uses Java to connect to SQL Server. However, after viewing the database connection character format, you find the port number that

Dirty reads: When a transaction begins to update the data, but the transaction is not fully committed, this time the second transaction begins to read the data and reads the data changed by the first firm.The second transaction reads the data

Enter the table name to generate the INSERT statementdrop proc Proc_insert//delete if presentGoCreate proc Proc_insert (@tablename varchar (256))AsBeginSET NOCOUNT ONDECLARE @sqlstr varchar (4000)DECLARE @sqlstr1 varchar (4000)DECLARE @sqlstr2

create PROCEDURE [dbo].[GetPageDataOutRowNumber](@tn nvarchar(30),--表名称@idn nvarchar(20),--表主键名称@pi int = 1,--当前页数 @ps  int = 7,--每页大小 @wh nvarchar(255) = ‘‘,--wehre查询条件@oby nvarchar(255) = ‘‘,--orderby 排序@rc int output,--总行数(传出参数)@pc int

Recently in the study of SSRS deployment issues, because previously also used the SSRS report, but the report was developed at that time there is a dedicated integrated system, do not need my own deployment, so the deployment of this piece is not

Query all database names and their sizes on the machine where the database is located2. Query the names and sizes of all tables under the databasePlease expert guidance! 1. View all database related information, parcel storage path, etc.Use

As you can see from Paul White's Twitter, in SQL Server 2014, for table variables (tables Variables), it is supported for non-unique clustered indexes (Non-unique Clustered Indexes) and nonclustered indexes (non-clustered Indexes). Seeing this, I

Reprinted from: http://www.blogjava.net/allen-zhe/archive/2010/07/23/326927.html1. Request fields on demand, say goodbye to "select *"The extraction of a field must be based on the principle of "how much to use" and avoid using "SELECT *". To do

A trigger is a special type of stored procedure that differs from the stored procedure we described earlier. Triggers are triggered primarily by an event that is automatically invoked to execute. The stored procedure can be called by the name of the

A Scripts for full backups, differential backups, and transaction log backups--Full backup DatabaseBACKUP DATABASE to DISK = ' E:\20150609_75\bak\Test_bak_full.bak ' with Init--Differential BACKUP DatabaseBACKUP DATABASE to DISK = ' E:\20150609_75

First, write it in front.In the blink of an eye is Monday, recalling the days of double Hugh, short and happy, in the sunny afternoon, can do their own to do anything, comfortable comfort, or reading, or sports, or music, when we calm down to slowly

First, write it in front.Following the last SQL Server Learning Note Series 1http://www.cnblogs.com/liupeng61624/p/4354983.html, continue to learn SQL Server, step by step, I believe that efforts will eventuallyHave a harvest! Always believe that

InstanceMD5 Encryption "123456":Hashbytes (' MD5 ', ' 123456 ')Result: 0xe10adc3949ba59abbe56e057f20f883e (hint: After the end, the result is converted. ）Function Function Describe return value Hashbytes

form of SQL Server data store Pre-read: Use the estimated information to go to the hard disk to read the data to the cache. Pre-read 100 times, which is estimated to read 100 pages of data from the hard disk to the cache. Physical reads:

Let's take a look at a basic concept of replication. What is replication? replication is the distribution of multiple copies (replicas) of data to each server in the company, providing the same data for multiple servers through replication. This

The result set of the outermost query is returned to the caller, called an external query. The result of an internal query is used by an external query, also known as a subquery. Sub-queries can be divided into independent subqueries and correlated

OpeningYounger brother is very yearning for those technical Daniel articles, every day to see the blog feel very advanced Daniel, in order to become a technical Daniel, younger brother today also began to write a blog, hope that the elder brother

　A. Select into  1.  uses SELECT INTO to automatically generate temporary tables without the need to create   SELECT * into #temp the from sysobjects  01.  save Stored procedure result set SELECT INTO to Temp table   SELECT * FROM #temp   2.  if a