﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Stephen Schaff  / Not working / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Mon, 20 May 2013 22:28:31 GMT</lastBuildDate><ttl>20</ttl><item><title>Not working</title><link>http://www.sqlservercentral.com/Forums/Topic701352-1518-1.aspx</link><description>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)ASBEGIN	SET NOCOUNT ON;	INSERT INTO [Demo] (		[Street]	) VALUES ( 		/* Street - varchar(50) */ @Street ) ENDNow rename the column Street in the table and try your report, no error at all...........</description><pubDate>Tue, 21 Apr 2009 06:04:24 GMT</pubDate><dc:creator>Danny Springer</dc:creator></item></channel></rss>