SQL Server

1. TRUNCATE TABLE TableName2. The DBCC checkident (tablename,reseed,1) Truncate command not only clears all data, but also restores the value of the identity's seed to its original value.DBCC CHECKIDENT is more convenient, and you can specify the

One, the creation of an instance of a COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from IClassFactory failed.Respect the original works: reproduced in this article from http://www.haogongju.net/art/2061733Problem descriptionError:

When you install SQL Server, "a previous program installation has created a pending file operation on the installation computer." You must restart the computer before you run Setup "error. Can't go on. After referring to the relevant information,

Requirements scenario: The data structure of an organization in SQL SERVER is a hierarchical relationship that now needs to capture all of the organizational information above each organization node, with the following examples:adorg_id--------------

Some days before the SQL where to write to where, a mess, today tidied up a bit, to make a backup (although the blog has been eight months, but today is the first time to publish blog, so nervous AH ~ ~)--2014.08.27 SQL statements 1: Enter

1. Get the database backup file, how to get it, [can see here]~2. Add a. bak suffix to the backup file, for example:3. Open SQL, you can create a new empty database, or use the original database, right-click >> Tasks >> Restore >> Database4. The

Today, a netizen came to me to give him the original system database optimization query speed, personal summary of several points to the optimization of SQL Server1, SQL query statement optimization, such as: can use external connection query out as

BEGINWith TX as(SELECT a.object_id, B.name as Schema_name, A.name as table_name, C.name as Ix_name, C.is_unique as Ix_unique, C.type_desc as Ix_type_desc, d.index_column_id, D.is_included_column, E.name as column_name, F.name as Fg_name,

from: http://www.jb51.net/article/29162.htm--1. Create a test tableCreate Table#score (Namevarchar( -), subjectvarchar( -), scoreint ) --2. Inserting test dataInsert into#score (Name,subject,score)Values('Zhang San','language',98) Insert

The primary key in the table must be an identity column, [ID] int identity (+)1. Paging Scenario One: (using not in and select top paging) select top page size *from Testtablewhere (ID not in select top (page size * (page -1)) ID from table order by

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

In SQL SERVER 2005, a synonym has finally appeared, which makes it much easier to use. Here's a small example to illustrateSynonyms are database objects that are used to achieve the following purposes:Provides alternate names for another database

Simple to use:Private voidupdatetitle (DataTable dt) {if(dt! =NULL&& dt. Rows.Count >0) { using(SqlBulkCopy SBC =NewSqlBulkCopy (sqlhelper.connectionstring)) {SBC. BatchSize= dt. Rows.Count;//Number of operations per

First look at a concept:A database transaction is a series of operations performed as a single logical unit of work, either completely or Transaction. Then adding a transaction to the stored procedure ensures that all the SQL code in the transaction

Reprinted from: http://hi.baidu.com/pigarmy/blog/item/109894c445eab0a28326ac5a.htmlRecently, you need to export data from one table and generate an INSERT statement, discovering that SQL Server's own tools and meters have this capability. Baidu to

http://xwqlzjtu.blog.163.com/blog/static/124185339201172354655857/In project development, it is common for LAN to simulate remote access SQL Server database, but always fail. Strangely, there is no problem with the computers deployed on site, so why

A stored procedure in Transact-SQL, very similar to a method in the Java language, can be called repeatedly. After the stored procedure executes once, the statement can be cached so that the statements in the cache are used directly at the next

When I first installed SqlServer2008 on the server (Win2008), there was an error--must use"Role management Tools"Install or configureMicrosoft. NET Framework 3.5 SP1。 At first thought it was not installed 3.5, later looked at the server has

1. DATEADD returns a new datetime value based on adding a period of time to the specified date. The syntax DateAdd (datepart, number, date) parameter datepart is a parameter that specifies which part of the date should be returned to the new value.

In the development of the hotel management system, we will create the room table and the room type table (room type table) These two tables, as shown in:Room Type table: RoomtypeRoom Table: RoomsFirst, the relationship between the two tables: The