Click here to Skip to main content
15,908,776 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Regaring asp.net Login Controls Pin
Amit Kumar G1-Feb-07 18:07
Amit Kumar G1-Feb-07 18:07 
GeneralRe: Regaring asp.net Login Controls Pin
SwaSubhaVijju1-Feb-07 18:45
SwaSubhaVijju1-Feb-07 18:45 
QuestionPath of a file Pin
nxde20001-Feb-07 15:36
nxde20001-Feb-07 15:36 
AnswerRe: Path of a file Pin
Christian Graus1-Feb-07 20:01
protectorChristian Graus1-Feb-07 20:01 
GeneralRe: Path of a file Pin
nxde20001-Feb-07 20:28
nxde20001-Feb-07 20:28 
Questionerror can be caused by a virtual directory not being configured as an application in IIS. Pin
red60mans1-Feb-07 15:28
red60mans1-Feb-07 15:28 
AnswerRe: error can be caused by a virtual directory not being configured as an application in IIS. Pin
Amit Kumar G1-Feb-07 17:42
Amit Kumar G1-Feb-07 17:42 
QuestionCheck if record exists Pin
shapper1-Feb-07 12:59
shapper1-Feb-07 12:59 
Hello,

I created the following SQL script to check if a record exists:

IF (EXISTS (SELECT LevelName FROM dbo.by27_Levels WHERE LOWER(@LevelName) = LOWER(LevelName)))
Return (1)
ELSE
Return (0)

And I also found in a web page another solution:
IF EXISTS(SELECT 1 FROM TABLENAME WHERE LevelName=@LevelName)
SELECT 1
ELSE
SELECT 0

- Which approach should I use?
- Why "SELECT 1 FROM"?
- And when should I use SELECT or RETURN?

All I need is to know if the record exists ... nothing else.

I will use this procedure on an ASP.NET 2.0 / C# web site.
I am not sure if this important but anyway ...

Thank You,
Miguel
AnswerRe: Check if record exists Pin
Alexandru Lungu2-Feb-07 2:09
professionalAlexandru Lungu2-Feb-07 2:09 
Questioncompare database Pin
saravanan051-Feb-07 11:27
saravanan051-Feb-07 11:27 
QuestionHow to add a Linked image in DataGrid Pin
nour1231-Feb-07 10:21
nour1231-Feb-07 10:21 
QuestionWhen to use Server.Transfer? Pin
robert1101-Feb-07 9:38
robert1101-Feb-07 9:38 
AnswerRe: When to use Server.Transfer? Pin
Software_Guy_1231-Feb-07 16:51
Software_Guy_1231-Feb-07 16:51 
GeneralRe: When to use Server.Transfer? Pin
Amit Kumar G1-Feb-07 17:47
Amit Kumar G1-Feb-07 17:47 
QuestionASP.net application from VB.net Pin
Keith Jenkins1-Feb-07 9:14
Keith Jenkins1-Feb-07 9:14 
AnswerRe: ASP.net application from VB.net Pin
Christian Graus1-Feb-07 9:39
protectorChristian Graus1-Feb-07 9:39 
QuestionHai,frnds..what are the New technologies that can be used in asp.net Pin
suriee1-Feb-07 7:50
suriee1-Feb-07 7:50 
AnswerRe: Hai,frnds..what are the New technologies that can be used in asp.net Pin
Pradipta Basu1-Feb-07 8:08
Pradipta Basu1-Feb-07 8:08 
GeneralRe: Hai,frnds..what are the New technologies that can be used in asp.net Pin
suriee1-Feb-07 8:14
suriee1-Feb-07 8:14 
GeneralRe: Hai,frnds..what are the New technologies that can be used in asp.net Pin
Pradipta Basu1-Feb-07 9:03
Pradipta Basu1-Feb-07 9:03 
GeneralRe: Hai,frnds..what are the New technologies that can be used in asp.net Pin
suriee2-Feb-07 1:16
suriee2-Feb-07 1:16 
QuestionPost Back Problem( Smart Navigation) Pin
kishore19@hotmail.com1-Feb-07 7:45
kishore19@hotmail.com1-Feb-07 7:45 
AnswerRe: Post Back Problem( Smart Navigation) Pin
Pradipta Basu1-Feb-07 8:12
Pradipta Basu1-Feb-07 8:12 
AnswerRe: Post Back Problem( Smart Navigation) Pin
Amit Kumar G1-Feb-07 17:53
Amit Kumar G1-Feb-07 17:53 
QuestionClicking on a GridView Pin
dptalt1-Feb-07 7:27
dptalt1-Feb-07 7:27 

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

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