Hab das ganze schonmal in einem Anderen Forum gefragt, aber leider keine Antwort drauf bekommen... {Ja ich weiß, ist auf Englisch}
I have a table in SQL Server.
I have a function for Refresh (SELECT) and DeleteRow (DELETE).
Now I want to do a Change Button, where I can INSERT/ UPDATE whatever is need.
My table's columns are:
- {Number (Integer) [this isn't ID autoincrement, its based on the Objects I got in a map]
- ARBPL (nvarchar(max))
- Area (nvarchar(Max))
- X_Koordinate (Integer)
- Y_Koordinate (Integer)}
I found in the internet something like
INSERT INTO {WHERE NOT ID IN (SELECT ID FROM dbo.Table)}
I don't got it working. My Idea was doing the INSERT like above and than do an FULL Update or an Update where the rows/ cells changed.
For example I have data like this:
1, ARB4875, LAK, 50, 70
72, ARB8879, MON, NULL, NULL
I need to get another Case where some Values could be NULL.
I just build a method before where the INSERT/ UPDATE is changed if anything changed on Worksheet but that isn't perfomant and it's not working if I copy-paste a lot of values so I want to do it with a button.
PS: is there a way too, how can I change the values to NULL if needed, maybe if one of the objects get deleted. and there isn't any coordinates finally