Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Not working Expand / Collapse
Author
Message
Posted Tuesday, April 21, 2009 6:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 11:28 AM
Points: 809, Visits: 332
I was very enthousiastic when I saw your query, yesterday I had a problem that could have been prevented, but it does not work.
Create a table and a stored procedure:
CREATE TABLE [dbo].[Demo](
[Street] [varchar](50) NULL
) ON [PRIMARY]

CREATE PROCEDURE [dbo].[ProcDemo]
@Street VARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;

INSERT INTO [Demo] (
[Street]
) VALUES (
/* Street - varchar(50) */ @Street )
END

Now rename the column Street in the table and try your report, no error at all...........
Post #701352
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse