Click here to Skip to main content
11,641,971 members (65,464 online)
   

ASP.NET

 
AnswerRe: What is the web.config for the <smtp> ? Pin
CommDev28-Dec-12 21:38
memberCommDev28-Dec-12 21:38 
QuestionImage album category wise Pin
Member 776731127-Dec-12 7:30
memberMember 776731127-Dec-12 7:30 
AnswerRe: Image album category wise Pin
Sandeep Mewara28-Dec-12 21:24
mvpSandeep Mewara28-Dec-12 21:24 
QuestionCapsLock detection Pin
tpkpradeep27-Dec-12 0:04
membertpkpradeep27-Dec-12 0:04 
AnswerRe: CapsLock detection Pin
AnalogNerd27-Dec-12 3:56
memberAnalogNerd27-Dec-12 3:56 
AnswerRe: CapsLock detection Pin
CommDev28-Dec-12 21:50
memberCommDev28-Dec-12 21:50 
QuestionApplication Layering Pin
Omersayeed26-Dec-12 2:31
memberOmersayeed26-Dec-12 2:31 
QuestionSyntax error in store procedure Pin
anubhaw.gupta25-Dec-12 22:06
memberanubhaw.gupta25-Dec-12 22:06 
here is my piece of code

alter procedure mdi_anu
(
@entry_date varchar(20),
@updated_date varchar(20),
@status varchar(20),
@cno varchar(20),
@eno varchar(20))

as

declare @SQL varchar(max)
set @SQL='SELECT * FROM anu123 where 1=1 '

if (@status='ALL')
begin
set @status='ALL'
end

if (@status='A')
begin
set @status='A'
end

if (@status='R')
begin
set @status='R'
end

if (@status='D')
begin
set @status='D'
end

if (@status='P')
begin
set @status='P'
end






if (@entry_date<>'' and @updated_date<>'')
begin

set @entry_date =CONVERT (datetime, @entry_date, 103)
set @updated_date= CONVERT(datetime, @updated_date, 103)
set @SQL=@SQL+'and entry_date>=''' +@entry_date+'''and updated_date<='''+@updated_date+''''
end

if (@cno<>'')
begin
set @cno=@cno
set @SQL=@SQL+'and cno=''' +@cno
end


if (@eno<>'')
begin
set @eno=@eno
set @SQL=@SQL+'and eno=''' +@eno
end

exec (@SQL)
End


Can anyone tell me,where am wrong? stuck from 2 hr. Saying incorrect syntax near the last end Hmmm | :|
AnswerRe: Syntax error in store procedure Pin
Sravanthid2825-Dec-12 22:21
memberSravanthid2825-Dec-12 22:21 
GeneralRe: Syntax error in store procedure Pin
anubhaw.gupta25-Dec-12 22:40
memberanubhaw.gupta25-Dec-12 22:40 
AnswerRe: Syntax error in store procedure Pin
anubhaw.gupta25-Dec-12 22:45
memberanubhaw.gupta25-Dec-12 22:45 
GeneralRe: Syntax error in store procedure Pin
sathish s26-Dec-12 1:39
membersathish s26-Dec-12 1:39 
GeneralRe: Syntax error in store procedure Pin
Zafar Sultan26-Dec-12 3:31
memberZafar Sultan26-Dec-12 3:31 
Questionid or guid.. which one? Pin
Jassim Rahma25-Dec-12 7:22
memberJassim Rahma25-Dec-12 7:22 
AnswerRe: id or guid.. which one? Pin
Sandeep Mewara25-Dec-12 19:14
mvpSandeep Mewara25-Dec-12 19:14 
AnswerRe: id or guid.. which one? Pin
CommDev25-Dec-12 19:25
memberCommDev25-Dec-12 19:25 
Questionwhy should I care about ExecuteScalar Pin
Jassim Rahma25-Dec-12 5:57
memberJassim Rahma25-Dec-12 5:57 
AnswerRe: why should I care about ExecuteScalar Pin
Sandeep Mewara25-Dec-12 19:30
mvpSandeep Mewara25-Dec-12 19:30 
AnswerRe: why should I care about ExecuteScalar Pin
CommDev25-Dec-12 19:33
memberCommDev25-Dec-12 19:33 
AnswerRe: why should I care about ExecuteScalar Pin
CommDev25-Dec-12 19:40
memberCommDev25-Dec-12 19:40 
GeneralRe: why should I care about ExecuteScalar Pin
Jassim Rahma28-Dec-12 9:40
memberJassim Rahma28-Dec-12 9:40 
GeneralRe: why should I care about ExecuteScalar Pin
Naveen Katta26-Dec-12 0:10
memberNaveen Katta26-Dec-12 0:10 
Questiona control that should contain html elements Pin
Ali Al Omairi(Abu AlHassan)23-Dec-12 23:01
memberAli Al Omairi(Abu AlHassan)23-Dec-12 23:01 
QuestionRe: a control that should contain html elements Pin
jkirkerx24-Dec-12 13:09
memberjkirkerx24-Dec-12 13:09 
AnswerRe: a control that should contain html elements Pin
Ali Al Omairi(Abu AlHassan)25-Dec-12 19:51
memberAli Al Omairi(Abu AlHassan)25-Dec-12 19:51 

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
Web01 | 2.8.150731.1 | Last Updated 30 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid