Click here to Skip to main content
15,348,239 members
Home / Discussions / Database
   

Database

 
QuestionSQL Injection - String replace best practice Pin
RCoate16-Jun-08 20:51
MemberRCoate16-Jun-08 20:51 
AnswerRe: SQL Injection - String replace best practice Pin
Colin Angus Mackay16-Jun-08 21:43
MemberColin Angus Mackay16-Jun-08 21:43 
GeneralRe: SQL Injection - String replace best practice Pin
RCoate17-Jun-08 15:59
MemberRCoate17-Jun-08 15:59 
GeneralRe: SQL Injection - String replace best practice Pin
Colin Angus Mackay18-Jun-08 23:13
MemberColin Angus Mackay18-Jun-08 23:13 
QuestionMonth and Year Pin
trilokharry16-Jun-08 19:07
Membertrilokharry16-Jun-08 19:07 
AnswerRe: Month and Year Pin
Alsvha16-Jun-08 19:54
MemberAlsvha16-Jun-08 19:54 
GeneralRe: Month and Year Pin
trilokharry16-Jun-08 20:41
Membertrilokharry16-Jun-08 20:41 
QuestionHow to search word starting with character 'a' Sql Full Text Indexing Pin
abhinish16-Jun-08 2:12
Memberabhinish16-Jun-08 2:12 
Hi guys,

need some help.
i am trying to create a Full text index query for searching all the records having words starting with a particular character for eg. 'A'
i tried using Contains Clause with '*' wild card
my query is :-

select * from table where contains (columname,'"A*"');


results are coming fine but the problem is that it returns all the records in which there is any word between the string starting with A .
I need only those records in which the starting char of the column is 'A'

similar to the query -
select * from table where columname like 'A%'
but i dont want to use like query as it will slower the results ..

any help will be appreciated

abhinav

AnswerRe: How to search word starting with character 'a' Sql Full Text Indexing Pin
SomeGuyThatIsMe16-Jun-08 7:44
MemberSomeGuyThatIsMe16-Jun-08 7:44 
Questionsql query help Pin
csp16-Jun-08 0:42
Membercsp16-Jun-08 0:42 
AnswerRe: sql query help Pin
A Wong16-Jun-08 2:46
MemberA Wong16-Jun-08 2:46 
QuestionSP Transaction isolation level locking SQL 2005 [modified] Pin
pmpdesign15-Jun-08 21:56
Memberpmpdesign15-Jun-08 21:56 
AnswerRe: SP Transaction isolation level locking SQL 2005 Pin
Alsvha16-Jun-08 2:21
MemberAlsvha16-Jun-08 2:21 
GeneralRe: SP Transaction isolation level locking SQL 2005 Pin
Ashfield16-Jun-08 4:27
MemberAshfield16-Jun-08 4:27 
GeneralRe: SP Transaction isolation level locking SQL 2005 Pin
pmpdesign16-Jun-08 19:21
Memberpmpdesign16-Jun-08 19:21 
GeneralRe: SP Transaction isolation level locking SQL 2005 Pin
Alsvha16-Jun-08 19:45
MemberAlsvha16-Jun-08 19:45 
QuestionSOLVED Bumb SQL question - WHER AND syntax? [modified] Pin
Vaclav_14-Jun-08 13:50
MemberVaclav_14-Jun-08 13:50 
AnswerRe: Bumb SQL question - WHER AND syntax? Pin
Blue_Boy14-Jun-08 18:22
MemberBlue_Boy14-Jun-08 18:22 
GeneralRe: Bumb SQL question - WHER AND syntax? Pin
Vaclav_14-Jun-08 18:43
MemberVaclav_14-Jun-08 18:43 
GeneralRe: Bumb SQL question - WHER AND syntax? Pin
Blue_Boy14-Jun-08 18:46
MemberBlue_Boy14-Jun-08 18:46 
GeneralRe: Bumb SQL question - WHER AND syntax? Pin
Vaclav_14-Jun-08 19:03
MemberVaclav_14-Jun-08 19:03 
GeneralRe: Bumb SQL question - WHER AND syntax? Pin
Blue_Boy14-Jun-08 19:04
MemberBlue_Boy14-Jun-08 19:04 
Questionproblem with web user control Pin
sabaMCA14-Jun-08 10:00
MembersabaMCA14-Jun-08 10:00 
AnswerRe: problem with web user control Pin
Christian Graus14-Jun-08 10:09
mveChristian Graus14-Jun-08 10:09 
GeneralRe: problem with web user control Pin
Blue_Boy14-Jun-08 10:49
MemberBlue_Boy14-Jun-08 10:49 

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.