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

This article introduces the relevant knowledge of "the usage of sql grammar Set IDENTITY_INSERT". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Syntax SET IDENTITY_INSERT [database. [owner.]] {table} {ON | OFF} parameter database, which is the name of the database where the specified table resides. Owner is the name of the table owner. Table is the name of the table that contains the identity column. Using an example, insert 1 million records into the database.

The copy code is as follows:

Set identity_insert sosuo8database on declare @ count int set @ count=1 while @ count

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.