SQL Server

articles directory continuous integration of database development-SQL Server deployment and upgrade tool continuous integration of database development-SQL Server database structure comparison continuous Database Development

Recently, in vs2005 Professional Tutorial network, some people often ask how to restore a database that has not yet been established through backup files. Therefore, I wrote this tutorial in particular. The following is the original article:

Error 8101 Severity 16 Message Body Only when the list of columns is used and identity_insert is on can the list be '% 1! ''Specifies an explicit value for the ID column. ExplanationAn attempt is made to insert a row containing a specific

Diversity of business logicIt is often necessary to query data in different databases in SQL server.Therefore, distributed query is required. Now I will summarize several types of queries encountered in development as follows: 1. access Version --

Add SQL Server statements and stored procedures to favorites -- ===================================================== ==================== -- List all SQL SERVER tables, field names, primary keys, types, lengths, decimal places, and other

[Post] www.inbaidu.com Some undisclosed extended stored procedures in SQL Server The extended storage process (xp) is a Dynamic Linked Library that runs directly in the SQL Server address space. It is developed by using the SQL Server Open Data

This is the fifth article in the series and a supplement to the previous log series. If you do not know the basic concepts of logs, refer to the articles earlier in this series: Transaction logs in SQL Server (I)-physical and logical architecture of

I. Cause With the increasing number of database files, the storage space on the disk becomes increasingly insufficient. To improve the performance of the database, migration of database log files is particularly important, that is, the primary and

I. Available when viewing the Instance name 1. Service-SQL Server (Instance name), default instance: (MSSQLSERVER) Or you can view the local instance when you connect to enterprise management. 2. Through the notebooks

There are several processing methods for the result set, which are worth explaining. 1. union (Union, union all)This is simple. It combines two result sets horizontally. For example SELECT * FROM UNION SELECT * FROM B [Note] union deletes duplicate

This is a question from my colleagues in the QQ group. At the same time, the problems he encountered also change over time, but they are all related to a large amount of data. 1. delete problems in large data volumes 2. update problems with large

SQL Server Index Structure and usage (2)Author: freedk I. An in-depth understanding of the index structure Improve SQL statements Many people do not know how SQL statements are executed in SQL server. They are worried that the SQL statements they

JIU Xue training network-the largest training platform in China!Free course release, demand, search for courses, lecturers, institutionsTraining courses: Computer, English, Japanese, enterprise management, occupational, French, software, driving,

What is a transaction?A: A transaction is a series of operations performed as a single logical unit of work. A logical unit of work must have four attributes: atomicity, consistency, isolation, and persistence. Only in this way can a transaction be

Take MySQL and SQL Server 2000 for a simple performance comparison test. MySQL 5.0 is used to test the program. It uses the Provider of ByteFX for MySQL. 1. Insert a record (No transaction) each time using parameterization ).   Number of

Working Machine (ASP. net Program ,. net Framework 1.1) in the domain, the SQL 2000 server is not in the domain, and suddenly the SQL Enterprise Manager and query analyzer can be connected to the SQL 2000 Server. if the SQL Server does not exist or

  SQL Server database design I. Necessity of Database Design2. What is database design?Iii. Importance of Database DesignIv. Data ModelEntity-relationship (E-R) Data ModelEntity)Attribute)Relationship)5. Database Design Steps1. Demand analysis stage2

Vulnerability Extension: xp_dirtree Stored Procedure Beforehand: I recently discovered a vulnerability that was caused by an SQL Server. Just a few days ago, I used a SQL injection tool to inject my server's website, by accident, we found that mssql

The first problem is database rename: In the Enterprise Manager, you cannot rename the database directly. You can only perform operations in the query analyzer. Code highlighting produced by Actipro CodeHighlighter

SQL Server also rolls forward committed transactions and does not write changes to the hard disk. When the recovery process is completed, SQL Server writes the following information to the SQL Server Error Log File: Recovery Complete During the