Modifying the insert, create and delete scripts

[dom]

Hi

If I right click on a table, select Generate Scripts and then Insert (or update or delete) I will end up with a script that looks something like this:

Code: Select all

USE FishTrackerProfessional
GO

INSERT INTO Landings.SeaFishLevyRates
(
  Description
 ,LevyRate
 ,ModifiedDate
)
VALUES
(
  N'' -- Description - nvarchar(50)
 ,0 -- LevyRate - numeric(8, 4)
 ,GETDATE() -- 'YYYY-MM-DD hh:mm:ss[.nnn]'-- ModifiedDate - datetime
)
GO

I want to create Insert, update and delete procedures for all tables , turn them into stored procedures and then import those into Entity Developer for use in my application. So ideally I would like a set of relevant Parameters at the top of the stamen and have the values line(s) use those parameters. Something like the example below

Code: Select all

CREATE PROCEDURE Landings.SeaFishLevyRatesInsert 

@Description nvarchar(50) = NULL,
@LevyRate numeric(8, 4) = NULL,
@ModifiedDate datetime = NULL
AS

BEGIN

  SET NOCOUNT ON

  INSERT INTO Landings.SeaFishLevyRates (Description
  , LevyRate
  , ModifiedDate)
    VALUES (@Description,
    @LevyRate,
    GETDATE());

END
GO

Is there a way to do this in DB forge at present, if not is it on your roadmap?

Regards

Dom

[alexa]

Unfortunately, there is no such a possibility. However, you can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/1770 ... sql-server

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.