This question is locked. New answers and comments are not allowed.
Hi,
I've been told this cannot be changed but I thought I'd mention it anyway.
The TSQL generated is pretty unreadable when you open the stored procedure in SQL management studio, the example below I generated from the nothwind category table.
Our DBA has already said it's not compliant, parameters should be on seperate lines etc. Something more readable is shown below.
We have 600+ tables, there could be over 1000 stored proced generated, as it stands we have to manually modify ever SP before we update the database from the model, can't the designer do this ? surely you could just have a template you could edit ?
Regards,
Norman.
I've been told this cannot be changed but I thought I'd mention it anyway.
The TSQL generated is pretty unreadable when you open the stored procedure in SQL management studio, the example below I generated from the nothwind category table.
USE [Northwind]
GO
/****** Object: StoredProcedure [dbo].[sp_oa_ins__categories] Script
Date
: 03/18/2011 16:32:52 ******/
SET
ANSI_NULLS
ON
GO
SET
QUOTED_IDENTIFIER
ON
GO
ALTER
PROCEDURE
[dbo].[sp_oa_ins__categories] ( @Picture image =
NULL
, @Description ntext =
NULL
, @CategoryName nvarchar(15) )
AS
INSERT
INTO
[Categories] ( [Picture] , [Description] , [CategoryName] )
VALUES
( @Picture , @Description , @CategoryName )
select
scope_identity()
Our DBA has already said it's not compliant, parameters should be on seperate lines etc. Something more readable is shown below.
USE [Northwind]
GO
/****** Object: StoredProcedure [dbo].[sp_oa_ins__categories] Script
Date
: 03/18/2011 16:32:52 ******/
SET
ANSI_NULLS
ON
GO
SET
QUOTED_IDENTIFIER
ON
GO
ALTER
PROCEDURE
[dbo].[sp_oa_ins__categories]
(
@Picture image =
NULL
,
@Description ntext =
NULL
,
@CategoryName nvarchar(15)
)
AS
INSERT
INTO
[Categories]
(
[Picture],
[Description],
[CategoryName]
)
VALUES
(
@Picture,
@Description,
@CategoryName
)
SELECT
scope_identity()
We have 600+ tables, there could be over 1000 stored proced generated, as it stands we have to manually modify ever SP before we update the database from the model, can't the designer do this ? surely you could just have a template you could edit ?
Regards,
Norman.