Click here to Skip to main content
       

Database

 
GeneralRe: SQL Select Where query PinmemberEddy Vluggen15-Oct-12 1:26 
AnswerRe: SQL Select Where query PinmemberAadhar Joshi16-Oct-12 20:47 
AnswerRe: SQL Select Where query PinmemberHiteshDR23-Oct-12 1:06 
QuestionMS SQL didn't allow to store apostrophe( ' ) in name PinmemberAzher.Cybertech15-Oct-12 0:04 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name PinmemberEddy Vluggen15-Oct-12 0:55 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name PinmemberHiteshDR23-Oct-12 1:08 
GeneralRe: MS SQL didn't allow to store apostrophe( ' ) in name PinmemberAzher.Cybertech27-Oct-12 23:34 
QuestionError Running SP [SOLVED] [modified] Pinmemberjojoba201113-Oct-12 21:53 
Hi ,
When i run this Stored Procedure I get this error :
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'Pages'.

 
AND my SP is :
 
declare @ModuleSettings NVarChar(max) = N'<Article type=''Pages''><Ucl name=''~/UserControls/ModuleSettings/ArticleModuleSettings.ascx''></Ucl><Election>0</Election><IsPaging>False</IsPaging><PageSize>5</PageSize><PagingLocation>Top</PagingLocation><Title>توليد کنندگان مواد اوليه / Suppliers of raw materials</Title><ThumbNail location=''3''>True</ThumbNail><ContentTitle>True</ContentTitle><ContentAbbr>True</ContentAbbr><Icon address=''''>False</Icon><Category>429</Category><All><item align="right" visible="true" order="1" block="true" navigateUrl="~/Management/Modules/Details/">Title</item><item align="right" visible="true" order="2" block="true">Abbr</item><item align="left" visible="true" order="4" block="true">CreateDate</item><item align="right" visible="false" order="5" block="false">Content</item><item align="right" visible="false" order="6" block="false">Keyword</item><item align="right" visible="false" order="7" block="false">Category</item><item align="right" visible="false" order="8" block="false">File</item><item align="right" visible="false" order="9" block="false">Icon</item><item align="right" visible="false" order="10" block="false">writer</item><item align="right" visible="false" order="11" block="false">Source</item></All></Article>' 
 
declare @param nvarchar(max)= N'update [Management].[PageModules] set '
if 100 is not NULL
BEGIN
set @param = @param + '[AreaId]=''' + cast(100 as nvarchar(3)) + ''',' 
End
if @ModuleSettings is not NULL
BEGIN
set @param = @param + '[ModuleSettings]=''' + @ModuleSettings + ''',' 
END
if 0 is not NULL
BEGIN
set @param = @param + '[Election]=''' + cast(0 as nvarchar(3)) + ''',' 
End
if 'sdfg' is not NULL
BEGIN
set @param = @param + '[Title]=''' + 'sdfg' + ''',' 
End
if 418 is not NULL
BEGIN
set @param = @param + '[CategoryId]=''' + cast(418 as nvarchar(17)) + ''',' 
End
if NULL is not NULL
BEGIN
set @param = @param + '[DepartmentId]=''' + cast(NULL as nvarchar(9)) + ''',' 
End
if 38 is not NULL
BEGIN
set @param = @param + '[CultureId]=''' + cast(38 as nvarchar(5)) + ''',' 
End
if 15 is not NULL
BEGIN
set @param = @param + '[ModuleId]=''' + cast(15 as nvarchar(5)) + ''',' 
End
if 1 is not NULL
BEGIN
set @param = @param + '[PageId]=''' + cast(1 as nvarchar(9)) + ''',' 
End
set @param= substring(@param,0,len(@param))
set @param = @param + ' Where Id=''' + cast( 68 as nvarchar(17)) + ''' ' 
 
exec sp_executesql @param
 


modified 6-Nov-12 4:38am.

AnswerRe: Error Running SP PinmemberEddy Vluggen14-Oct-12 3:06 
AnswerRe: Error Running SP PinmemberRichard Deeming15-Oct-12 3:38 
QuestionRe: Error Running SP Pinmemberjojoba201115-Oct-12 4:52 
NewsRe: Error Running SP [Solved] Pinmemberjojoba20115-Nov-12 22:37 
QuestionBug in SQLBulkCopy? Truncates decimal digits after 26 records PinmemberAllan Watkins12-Oct-12 14:25 
AnswerRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pinmemberjschell13-Oct-12 11:05 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records PinmemberAllan Watkins13-Oct-12 13:02 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pinmemberjschell14-Oct-12 6:51 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records PinmemberMycroft Holmes14-Oct-12 15:06 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records PinmemberAllan Watkins14-Oct-12 19:36 
GeneralThe "bug" is actually in the Fill() method PinmemberAllan Watkins16-Oct-12 16:09 
AnswerRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records PinmemberAadhar Joshi17-Oct-12 1:31 
QuestionConfigure SQL Server 2005 Remote Access [modified] PinmemberKevin Marois11-Oct-12 11:35 
AnswerRe: Configure SQL Server 2005 Remote Access PinmemberMarcus Kramer11-Oct-12 12:06 
AnswerRe: Configure SQL Server 2005 Remote Access PinmemberEddy Vluggen11-Oct-12 12:37 
AnswerRe: Configure SQL Server 2005 Remote Access PinmemberBernhard Hiller12-Oct-12 3:24 
QuestionGlobal Database Design for example to store Addresses PinmemberLiQuick10-Oct-12 21:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid