asp.netsqlsql-serverstored-proceduresidentity-insert
Stored Procedure IDENTITY_INSERT
I'm recently change my data table, I remove column and add a new column that define as identity = True and identity seed = 1, identity increment = 1. When i tried to insert data to this table by STORE PROCEDURE i get this exception:
An explicit value for the identity column in table 'AirConditioner' can only be specified when a column list is used and IDENTITY_INSERT is ON.
I saw that i need to add this lines: SET IDENTITY_INSERT [dbo].[AirConditioner] ON and finally OFF I added and its still throw an exception...
My store procedure is attached as a picture
Solution
SQL Server will take care of assigning a value to your identity column. You should remove @ID from the insert statement and remove the IDENTITY_INSERT statements.
- search is not working, SQL query doesn`t replace GridView data
- Converting GUID to Integer and Back
- Can the app permission/verification be bypassed for Dropbox API?
- asp.net c# scan application for code duplication - utility
- MudDataGrid not showing filter options in Blazor app despite Filterable set to true
- SMTP Email error with port 465
- ExecuteNonQuery() returns -1 always
- Can't open page in browser from Visual Studio
- Dependency injection approach for object used only in a single method
- IIS server error .Server Error in '/' Application
- Configure Docker to use a proxy server
- Read connection string from web.config
- If a folder does not exist, create it
- Azure Active Directory passing empty GUID for tenantId with default template
- Preventing overwriting values one from another of the same application but different windows/tabs with different ID as query string
- Update multiple rows in datatable without loop
- The named 'CommandType' does not exist in the current context
- Can you test whether a function is actually running Asynchronously?
- Service not available, closing transmission channel. The server response was: Cannot connect to SMTP server
- Should project.lock.json file be checked into source control? (ASP.NET Core 1.0)
- Downloaded audio file by "SSH" and returned by the "Service" but API cannot return to user
- How to manage user claims?
- How can I use Dependency Injection in an ASP.NET Core ActionFilterAttribute?
- How can I display a messagebox in ASP.NET?
- Sending IMs through an API
- Get url without querystring
- Blazor components and OnInitialized() inside another method
- Icon Doesn't Appear for MAUI Blazor App on Windows if Taskbar Icons are Combined
- inserting data into SQL DB from C# ASP.NET
- string.Format with variable names instead of numbers