Insert into with max+1 value declared

Goran Bibic

I worn somesthing

string saveStaff = "declare @maxNo integer = 0 select @maxNo = isnull(max(redni_broj), 0) from[dbo].[drzave] INSERT into [dbo].[drzave] (redni_broj, Ime, Valuta, Poziv_na_broj, A2, A3, Num) VALUES (@maxNo+1,@Ime,@Valuta,@Poziv_na_broj,@A2,@A3,@Num)";

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sai Sherlekar8y ago
Accepted answer
declare @maxNo integer = 0 select @maxNo = isnull(max(redni_broj), 0) from[dbo].[drzave] ; Set @maxNo=@maxNo+1; INSERT into [dbo].[drzave] (redni_broj) VALUES (@maxNo)";
+1
Goran Bibic8y ago
Insert
declare @maxNo integer = 0 select @maxNo = isnull(max(redni_broj), 0) from[dbo].[drzave] ; Set @maxNo=@maxNo+1; INSERT into [dbo].[drzave] (redni_broj) VALUES (@maxNo)";
Update code?
UPDATE [dbo].[drzave] UPDATE redni_broj=@maxNo WHERE id=" + idTextBox;
??
0
Goran Bibic8y ago
Work. Thank you
0
Goran Bibic8y ago
Becose I must find max value from column redni_broj
0
Sai Sherlekar8y ago
Why don't you use stored procedure? You can easily do it. Just write below code Set @maxno=@maxno+1;
+1
Goran Bibic8y ago
Comadnd is for MS sql
0
Goran Bibic8y ago
Yes in c#
0
Sai Sherlekar8y ago
Are you writing this in c#?
+1
Goran Bibic8y ago
Short...problem is in VALUES (@maxNo+1)...not good declared..c# no cache error
string saveStaff = "declare @maxNo integer = 0 select @maxNo = isnull(max(redni_broj), 0) from[dbo].[drzave] INSERT into [dbo].[drzave] (redni_broj) VALUES (@maxNo+1)";
0
Sai Sherlekar8y ago
What error you are getting? Please send me error detail
+1