Click here to Skip to main content
15,920,896 members
Home / Discussions / Database
   

Database

 
AnswerRe: add new user to sql server database 2005 Pin
Giorgi Dalakishvili15-Oct-07 4:02
mentorGiorgi Dalakishvili15-Oct-07 4:02 
GeneralRe: add new user to sql server database 2005 Pin
Hesham Amin16-Oct-07 3:49
Hesham Amin16-Oct-07 3:49 
QuestionTimeout problem Pin
gratisaccount15-Oct-07 3:46
gratisaccount15-Oct-07 3:46 
AnswerRe: Timeout problem Pin
kubben15-Oct-07 3:54
kubben15-Oct-07 3:54 
AnswerRe: Timeout problem Pin
Mike Dimmick15-Oct-07 3:56
Mike Dimmick15-Oct-07 3:56 
AnswerRe: Timeout problem Pin
gratisaccount15-Oct-07 18:51
gratisaccount15-Oct-07 18:51 
GeneralRe: Timeout problem Pin
kubben16-Oct-07 2:48
kubben16-Oct-07 2:48 
QuestionProblem with ISNULL Pin
braj yadav15-Oct-07 2:02
braj yadav15-Oct-07 2:02 
Hi all,

I have written a stored proc for searching in DB.For this purpose i have used ISNULL where in check whether the parameter is null or not.But when i use logical statement such as or in between sql statements it fails miserably.
for eg:

@skill1 varchar(50)=null,
@skill2 varchar(50)=null

select skill from JOBS
where
skill like '%'+ISNULL(@skill1,skill)+'%' or
skill like '%'+ISNULL(@skill2,skill)+'%'

here if i don`t enter skill2, @skill2 becomes null and hence the other part returns 1 and thus the query returns all data from table .

Pls help me for going about this


Thankx in Adv
AnswerRe: Problem with ISNULL Pin
kubben15-Oct-07 2:45
kubben15-Oct-07 2:45 
AnswerRe: Problem with ISNULL Pin
Frank Kerrigan15-Oct-07 3:07
Frank Kerrigan15-Oct-07 3:07 
AnswerRe: Problem with ISNULL Pin
Michael Potter15-Oct-07 5:44
Michael Potter15-Oct-07 5:44 
Questionexception Pin
Trustapple15-Oct-07 0:32
Trustapple15-Oct-07 0:32 
AnswerRe: exception Pin
Andy_L_J15-Oct-07 2:54
Andy_L_J15-Oct-07 2:54 
AnswerRe: exception Pin
Mike Dimmick15-Oct-07 4:02
Mike Dimmick15-Oct-07 4:02 
QuestionJOINS Pin
karoitay14-Oct-07 23:53
karoitay14-Oct-07 23:53 
AnswerRe: JOINS Pin
John-ph14-Oct-07 23:56
John-ph14-Oct-07 23:56 
Generalthanks Pin
karoitay15-Oct-07 0:26
karoitay15-Oct-07 0:26 
QuestionHow do I pass DB name as parameter to stored procedure? Pin
Steven J Jowett14-Oct-07 22:22
Steven J Jowett14-Oct-07 22:22 
AnswerRe: How do I pass DB name as parameter to stored procedure? Pin
Marek Grzenkowicz14-Oct-07 23:43
Marek Grzenkowicz14-Oct-07 23:43 
GeneralRe: How do I pass DB name as parameter to stored procedure? Pin
Steven J Jowett14-Oct-07 23:54
Steven J Jowett14-Oct-07 23:54 
QuestionUnable to complete login process due to delay in opening server connection Pin
Anilkumar K V14-Oct-07 20:39
Anilkumar K V14-Oct-07 20:39 
QuestionDatabase is suspect Pin
Phan Van Thao14-Oct-07 16:19
Phan Van Thao14-Oct-07 16:19 
AnswerRe: Database is suspect Pin
Pete O'Hanlon15-Oct-07 2:01
mvePete O'Hanlon15-Oct-07 2:01 
GeneralRe: Database is suspect Pin
Phan Van Thao15-Oct-07 15:03
Phan Van Thao15-Oct-07 15:03 
QuestionWindows authentication - not prompted? [modified] Pin
dandy7214-Oct-07 11:36
dandy7214-Oct-07 11:36 

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.