Click here to Skip to main content
14,970,019 members
Home / Discussions / Database
   

Database

 
GeneralRe: Migrate Access Db to SQL Server. Pin
Wendelius23-Sep-08 11:09
mveWendelius23-Sep-08 11:09 
GeneralRe: Migrate Access Db to SQL Server. Pin
VentsyV23-Sep-08 12:09
MemberVentsyV23-Sep-08 12:09 
QuestionADO recordset.open connection.execute concurrent problem Pin
followait23-Sep-08 3:57
Memberfollowait23-Sep-08 3:57 
AnswerRe: ADO recordset.open connection.execute concurrent problem Pin
Ashfield23-Sep-08 5:00
MemberAshfield23-Sep-08 5:00 
QuestionDefault date format Pin
mikobi23-Sep-08 3:23
Membermikobi23-Sep-08 3:23 
AnswerRe: Default date format Pin
NeverHeardOfMe23-Sep-08 3:59
MemberNeverHeardOfMe23-Sep-08 3:59 
QuestionHow to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
JUNEYT23-Sep-08 1:54
MemberJUNEYT23-Sep-08 1:54 
AnswerRe: How to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
Ashfield23-Sep-08 4:58
MemberAshfield23-Sep-08 4:58 
This is the sort of thing you need

select {column list}
from {table}
where (name = @name or postcode = @postcode)


Of course its up to you to decide whether to use OR or AND, and you also need to deal with nulls.


Hope this helps

Bob
Ashfield Consultants Ltd

AnswerRe: How to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
nelsonpaixao23-Sep-08 13:13
Membernelsonpaixao23-Sep-08 13:13 
AnswerRe: How to perform a search in a table with given more than one paramaters (SQL SERVER EXPRESS 2008)? Pin
Kevin Horgan23-Oct-08 9:53
MemberKevin Horgan23-Oct-08 9:53 
Questionarray of string in procedure Pin
Shaista Shafiq23-Sep-08 0:59
MemberShaista Shafiq23-Sep-08 0:59 
AnswerRe: array of string in procedure Pin
Ashfield23-Sep-08 1:21
MemberAshfield23-Sep-08 1:21 
Questionhug database Pin
mahmoudinirat23-Sep-08 0:39
Membermahmoudinirat23-Sep-08 0:39 
AnswerRe: hug database Pin
ChandraRam23-Sep-08 1:06
MemberChandraRam23-Sep-08 1:06 
AnswerRe: hug database Pin
Ashfield23-Sep-08 1:22
MemberAshfield23-Sep-08 1:22 
QuestionRe: hug database Pin
nelsonpaixao23-Sep-08 14:49
Membernelsonpaixao23-Sep-08 14:49 
QuestionMemory Occupied by a table of a database Pin
sailesh_gupta22-Sep-08 20:02
Membersailesh_gupta22-Sep-08 20:02 
AnswerRe: Memory Occupied by a table of a database Pin
N a v a n e e t h22-Sep-08 20:12
MemberN a v a n e e t h22-Sep-08 20:12 
QuestionHow to find the latest Pin
krishnan.s22-Sep-08 19:27
Memberkrishnan.s22-Sep-08 19:27 
AnswerRe: How to find the latest Pin
Ashfield22-Sep-08 21:24
MemberAshfield22-Sep-08 21:24 
GeneralRe: How to find the latest Pin
krishnan.s22-Sep-08 21:46
Memberkrishnan.s22-Sep-08 21:46 
GeneralRe: How to find the latest Pin
Ashfield23-Sep-08 1:19
MemberAshfield23-Sep-08 1:19 
AnswerRe: How to find the latest Pin
Wendelius23-Sep-08 8:11
mveWendelius23-Sep-08 8:11 
GeneralRe: How to find the latest Pin
nelsonpaixao23-Sep-08 13:34
Membernelsonpaixao23-Sep-08 13:34 
AnswerRe: How to find the latest Pin
shiva.kore6-Sep-10 21:58
Membershiva.kore6-Sep-10 21:58 

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.