Not working

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stephen Schaff » Not working

Not working

Rate Topic

Display Mode

Topic Options

Author

Message

Danny Springer

Posted Tuesday, April 21, 2009 6:04 AM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 740, Visits: 305

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 »

Permissions