Database

CREATE PROCEDURE sp_Update
(
@col1 varchar(20)
@ValuePassed varchar(50),
)
AS

declare @Id int
EXEC sp_Insert @ValuePassed, @Id OUTPUT

Update SomeTable
(col1, col2)
VALUES
(@col1, @Id)
RETURN
GO 


CREATE PROCEDURE sp_Insert

(
@ValuePassedIn varchar(50),
@Id smallint OUTPUT
)
 AS

INSERT INTO LookUpTable(column1) 
VALUES(@ValuePassedIn)
    
    SET @Id = Scope_Identity()
END
GO

Regards
J O H N

"Even eagles need a push." David McNally

---

bhattiprolu wrote:

i have one one registration page.
in that if user chooses his own question for security(while signup in yahoo also we will get security question like that) then the table field must b updated and question flag should be "yes"
if i take the custom question option else not.

Regards
J O H N

"Even eagles need a push." David McNally

---

Tuanhung189 wrote:

I have some trouble.so I want to ask how to do that ?

Regards
J O H N

"Even eagles need a push." David McNally

---

never.reply wrote:

What datatype would be best to use varbinary for the hex or varchar for the base64?

never.reply wrote:

Is there any difference between them in memory usage?

Suresh R.. wrote:

how to delete a perticular row from a table in SQL Server 2005

DELETE FROM TABLE WHERE ID = VALUE

DELETE FROM TABLE WHERE ID IN (VALUE1, VALUE2, VALUE3)

DELETE FROM TABLE WHERE ID (SELECT TOP 100 ID FROM TABLE ORDER BY ID)

DELETE FROM TABLE A
WHERE EXISTS
  ( SELECT ID
     FROM TABLE B
     where B.ID = A.ID)

DELETE FROM TABLE A
WHERE NOT EXISTS
  ( SELECT ID
     FROM TABLE B
     where B.ID = A.ID)

TRUNCATE TABLE TABLENAME --(not reccommended if you 
--don't know the exact use of truncate stmt)

Regards
J O H N

"Even eagles need a push." David McNally

---