Ability to generate insert/update stored-procedures for given table
I like to right click a table name and dbforge should produce a stored procedure for insert/update out of it, like
CREATE PROCEDURE tblTest1_IU
@id Int,
@[user] Int,
@stamp DateTime2(6) AS
BEGIN
IF EXISTS ( SELECT * FROM dbo.tblTest1 WHERE id = @id)
UPDATE dbo.tblTest1 SET
[user] = @[user],
stamp = @stamp
WHERE
id = @id
ELSE
INSERT INTO dbo.tblTest1 (
id,
[user],
stamp)
VALUES (
@id,
@[user],
@stamp)
END
41
votes
Anonymous
shared this idea
-
Anonymous commented
I think this would be a great time saver, I prefer to use stored procedures for all my apps, (keeps the database queries out of my code)
-
Neolisk commented
Very specific/limited use - most people would never need this feature.