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

This article shows you how to insert the logo column manually in SQL Server, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

The code is as follows:

Insert member (id,username) values (10)

Then an error message is returned in the query analyzer: [plain] reference content server: message 544, level 16, status 1, row 1 when IDENTITY_Insert is set to OFF, explicit values cannot be inserted into the identity column in the table 'member'. In some cases, we need to insert the value of the identity column manually, for example, after deleting some records, the identity column is not contiguous, and we want to make it up. We can use a switch to make the wish come true: copy the code as follows: SET IDENTITY_Insert [TableName] ON

Write this in the query analyzer:

The code is as follows:

SET IDENTITY_Insert member ON insert member (id,username) values (1) SET IDENTITY_Insert member OFF

The above is how to insert the logo column manually in SQL Server. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.