Click here to Skip to main content
15,065,644 members
Home / Discussions / Database
   

Database

 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 2:48
professionalPIEBALDconsult17-Aug-11 2:48 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes17-Aug-11 5:40
professionalMycroft Holmes17-Aug-11 5:40 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 14:11
professionalPIEBALDconsult17-Aug-11 14:11 
GeneralRe: Searching with optional parameters Pin
S Douglas20-Aug-11 7:53
professionalS Douglas20-Aug-11 7:53 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult20-Aug-11 13:01
professionalPIEBALDconsult20-Aug-11 13:01 
QuestionRe: Searching with optional parameters Pin
Shameel16-Aug-11 4:52
professionalShameel16-Aug-11 4:52 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 6:02
MemberPascal Ganaye16-Aug-11 6:02 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 18:04
professionalPIEBALDconsult16-Aug-11 18:04 
Pascal Ganaye wrote:
I am trying to stay database agnostic


Then don't use stored procedures; not all databases support them.


(@ContactType IS NULL OR Contacts.ContactType = @ContactType)


How about
Contacts.ContactType = COALESCE(@ContactType,Contacts.ContactType)
Big Grin | :-D

(Not that that is necessarily agnostic either. Sigh | :sigh: )
QuestionSQL bit to bool conversion [moved] Pin
5fingers16-Aug-11 0:37
Member5fingers16-Aug-11 0:37 
GeneralRe: SQL bit to bool conversion Pin
Nagy Vilmos16-Aug-11 0:39
professionalNagy Vilmos16-Aug-11 0:39 
GeneralRe: SQL bit to bool conversion Pin
Shameel16-Aug-11 4:53
professionalShameel16-Aug-11 4:53 
GeneralRe: SQL bit to bool conversion Pin
5fingers17-Aug-11 0:59
Member5fingers17-Aug-11 0:59 
GeneralRe: SQL bit to bool conversion Pin
Dalek Dave16-Aug-11 0:39
professionalDalek Dave16-Aug-11 0:39 
GeneralRe: SQL bit to bool conversion Pin
5fingers17-Aug-11 0:57
Member5fingers17-Aug-11 0:57 
GeneralRe: SQL bit to bool conversion Pin
chriselst16-Aug-11 0:40
Memberchriselst16-Aug-11 0:40 
GeneralRe: SQL bit to bool conversion Pin
CPallini16-Aug-11 0:45
mveCPallini16-Aug-11 0:45 
GeneralRe: SQL bit to bool conversion Pin
PompeyBoy316-Aug-11 0:45
MemberPompeyBoy316-Aug-11 0:45 
GeneralRe: SQL bit to bool conversion Pin
Richard MacCutchan16-Aug-11 1:15
mveRichard MacCutchan16-Aug-11 1:15 
GeneralRe: SQL bit to bool conversion Pin
5fingers17-Aug-11 0:56
Member5fingers17-Aug-11 0:56 
GeneralRe: SQL bit to bool conversion Pin
Richard MacCutchan17-Aug-11 1:27
mveRichard MacCutchan17-Aug-11 1:27 
GeneralRe: SQL bit to bool conversion Pin
Smithers-Jones16-Aug-11 1:03
MemberSmithers-Jones16-Aug-11 1:03 
GeneralRe: SQL bit to bool conversion Pin
5fingers17-Aug-11 0:56
Member5fingers17-Aug-11 0:56 
QuestionLocal Variable Ntext Probelm sql 2005 Pin
md_refay14-Aug-11 1:10
Membermd_refay14-Aug-11 1:10 
Answercross-post Pin
Wendelius14-Aug-11 1:45
mveWendelius14-Aug-11 1:45 
QuestionCheck Different Select query result Pin
Naunt11-Aug-11 18:17
Member Naunt11-Aug-11 18:17 

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.