Database

UPDATE t SET num=num+1
  WHERE name='abc'
  AND age=20
  AND job='worker'
IF (@@ROWCOUNT = 0) BEGIN
  INSERT INTO t(id,name,age,job,num)
     VALUES(NEWID(),'abc',20,'worker',1)
END

CREATE UNIQUE INDEX t_idx1 ON t (name, age, job)

CREATE PROCEDURE dbo.Insert_t
@Name VARCHAR(40),
@Age SMALLINT,
@Job VARCHAR(40)
AS BEGIN
  SET NOCOUNT ON
  UPDATE t SET num = num+1
    WHERE name = @Name
    AND age = @Age
    AND job = @Job
  IF (@@ROWCOUNT = 0) BEGIN
    INSERT INTO t (id, name, age, job, num)
      VALUES (NEWID(), @Name, @Age, @Job, 1)
  END
  RETURN 0
END

laziale wrote:

what if I don't have any password?? What should I use for password??

laziale wrote:

When I am writing the data source like this: "Data Source=.\SQLEXPRESS" it gives me a error and it says: "Unrecognized escape sequence", and when I am turning the slash otherway: "Data Source=./SQLEXPRESS" it says is ok. Does that make any difference???

yogesh_kumar_agarwal wrote:

i want to know did you are using msaccess as backend???

yogesh_kumar_agarwal wrote:

i think you didn't read the connection string properly he tries to connect with a mdb database file means Access

Jacquers wrote:

I could do it in code, but it seems inefficient as it would be a two step process.