SQL Server

When you connect to a database, you can listen to SQL statements to maximize the debugging progress.1. Create a listener to listen to the database information I want to know.I want to know the details of the SQL statements currently executed, the

  Import data to the SQL server data table in batches from the text ================================ ============================ Author: locker (http://locker.itpub.net) Posted on: 2004.11.26 Category: SQL Server Source:

To improve the security of the SQL Server database system and improve the database's ability to defend against intrusions, we need to take several steps to achieve this goal. For example, installing the latest patch for SQL Server is only part of

I did not pay too much attention to the table name when designing the database. I designed a user, order, and modify table. I think there is no problem, you can find a problem only when using exported SQL to generate a database.   These table

Trigger:A trigger is a database table trigger. It is a piece of code executed when you insert, modify, or delete a table. It is used as a constraint for this table.Instance description:In a problem report case, when a problem event is reported to

Document 1 (zhujian)   -- Create a Test DatabaseCreate Database DBGo -- Back up the databaseBackup database dB to disk = 'C:/DB. Bak' with formatGo -- Create a test tableCreate Table dB. DBO. tb_test (id int) -- Delay 1 second, and then perform

  Step 1: Put the Microsoft SQL Server 2000 installation CD into the optical drive. The installation program runs automatically and the version selection page appears.Select Enterprise Edition (note that Enterprise Edition cannot be installed on XP)

-- Instance Description: Two Methods for SQL Server multi-Table cascade deletion   -- 1. Trigger-based cascade DeletionIf object_id ('tablec') is not null drop table tablecGoIf object_id ('tableb') is not null drop table tablebGoIf object_id

Use [Master]GoSet ansi_nulls onGoSet quoted_identifier onGo/* | **************************************** ************************************Software name: May Flower ERPCopyright: (c) 2005-2006 may flower ERP development teamObject Name:

Microsoft SQL Server 2000 comprehensive application this series of articles mainly write to cute GGT teachers, hope she can feel at ease on the platform, and then teach this series of articles. SQL Server is a high-end database system packaged by

1. xml: Recognition of elements, attributes, and values2. XPath: Addressing language, similar to Windows Directory Search (go to the wall without using the Dir command) Syntax format. These syntaxes can be combined into conditions: "." Indicates

Abstract: In a world where key data of a task is stored in different heterogeneous sources, the Extensible Markup Language (XML) A standard format provides a powerful mechanism for data exchange between different applications and integration between

What is the auto-increment field in SQL Server (like the serial number sequence in Oracle? How to use it? 1. Create Table Name (Field name [int] identity (1, 1) not null,...) 2. in SQL Server, All Integer columns can be defined as self-incrementing

When using a database, you often encounter database migration or data migration problems, or sudden database damage. In this case, you need to directly recover from the database backup. However, a problem may occur at this time. Here are several

For SQL Server versions earlier than 2000, for example, 7.0 generally does not have multiple versions. Only the standard version and the desktop version are available. If you do not know what version to install, you can install it according to the

--- Obtain the occupied capacity of tables in the SQL Server database Create procedure get_tableinfo   If not exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [tablespaceinfo] ') and OBJECTPROPERTY (id, n' isusertable') =

1. MySQL supports enum, set, and SQL Server.2. MySQL does not support nchar, nvarchar, and ntext types.3. the incremental Statement of MySQL is AUTO_INCREMENT, while that of ms SQL is identity)4. ms SQL does not support replace into statements, but

1. start or stop the SQL Agent service in the query analyzer.　　StartUse masterGoXp_cmdshell 'net start sqlserveragent'　　Stop Use masterGoXp_cmdshell 'net stop sqlserveragent'　　Change the service start mode from manual to automatic start ModeExec

SQL 2005 how to modify the architecture of tables and stored procedures in batches* ** First, you need to add a new architecture owner to the architecture item in the security selection of the database to be modified.1. Let's talk about it first.How

[51CTO.com exclusive Article] In fact, it is not complicated to delete the data in the database. Why should I do this? First, I will introduce how to delete all the data in the database, because the data may form a constrained relationship between