Ask someone to write a .NET stored procedure. I don't know where to start ...

ggggex

The function is to determine whether the data already exists in the database`

Update count + 1 if available

If not, insert data

The syntax of my .net calling stored procedure has not been understood, so ask for help

ggggex

C#`

linhanerror

Boss, do you want a stored procedure, or call a stored procedure, or both
^^^^^^^^^^^^^^^^^^
Bangding

pengw1015

The stored procedure does not matter C# and VB, both are SQL SERVER
Write successfully, call with C#

Do it with a name

create proc proc1
@prod_id varchar(10)
as
if exists(select prod_id from prod where prod_id = @prod_id)
--Perform update operation
begin
update prod set num = num + 1
end
else
- Perform an insert operation
begin
insert into prod(prod_id,num) values(@prod_id,1)
end

ggggex

All`

Are stored procedures written in SQL?

Is the write call in the .CS file?

ggggex

I don’t quite understand where to write the stored procedure ofpengw1015?

SQL?

Can .NET be called by itself?

Amazing

lzy2001

Stored procedures are written in SQL language, not C#
Can be called with C#
Supportpengw1015solution

ggggex

Give an example
I have a table and the table has 2 columns
Key varchar(50)
Count int

I have a method in the .CS file
protected void Sea(string key)
{
   //Here I need to use this key to substitute in the database to find if the Key column has this key or Count+1
   //If not, insert a new key
}

I can't write the middle part. "Everyone, please help me write it." Let me know the meaning of it. I don't want to never."

bastard

Stored procedures are written in the database.

ggggex

pengw1015


Why is your statement showing an error in my SQL