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

wudi1982

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

dukang520

Run the above stored procedure in query analysis and call it in .cs

ggggex

Ah `Go crazy!

Mine is ms Sql Server ManageMent Studio
I wrote `Such a paragraph` in query analysis
CREATE PROCEDURE searchkey @key varchar(50) output AS
IF (SELECT * FROM aspnet_HotSearch WHERE KEY = @key) BEGIN
    UPDATE aspnet_HotSearch
     SET Count = Count + 1
     WHERE KEY = @key END ELSE BEGIN
                                INSERT
                                 INTO aspnet_HotSearch(KEY, Count)
VALUES (@key, 1) END GO

When the result is validated in the grammar, the query containing the function cannot be verified