Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to insert a column in a specified location in SQL2000". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to insert a column in a specified location in SQL2000"!

How to insert a column at a specified location in SQL2000:

The processing of the system is very simple. Create a new table Tmp_test, insert all the data of the old table test into the new table, then delete the test, and rename the Tmp_test to test. The code is as follows:

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET ARITHABORT ON

SET NUMERIC_ROUNDABORT OFF

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

COMMIT

BEGIN TRANSACTION

CREATE TABLE dbo.Tmp_test

(

A char (10) NULL

B char (10) NULL

C char (10) NULL

D char (10) NULL

) ON [PRIMARY]

GO

IF EXISTS (SELECT * FROM dbo.test)

EXEC ('INSERT INTO dbo.Tmp_test (a, c, d)

SELECT a, c, d FROM dbo.test (HOLDLOCK TABLOCKX)')

GO

DROP TABLE dbo.test

GO

EXECUTE sp_rename Neighdbo.Tmpspeak testworthy, Narctestorium, 'OBJECT'

GO

COMMIT

At this point, I believe you have a deeper understanding of "how to insert a column in a specified location in SQL2000". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.