Click here to Skip to main content
15,916,293 members
Home / Discussions / Database
   

Database

 
AnswerRe: Pivot? Pin
Mycroft Holmes28-Oct-10 13:56
professionalMycroft Holmes28-Oct-10 13:56 
GeneralRe: Pivot? Pin
mark_w_28-Oct-10 21:42
mark_w_28-Oct-10 21:42 
GeneralRe: Pivot? Pin
Mycroft Holmes28-Oct-10 22:20
professionalMycroft Holmes28-Oct-10 22:20 
GeneralRe: Pivot? Pin
mark_w_28-Oct-10 22:32
mark_w_28-Oct-10 22:32 
GeneralRe: Pivot? Pin
Jörgen Andersson28-Oct-10 23:26
professionalJörgen Andersson28-Oct-10 23:26 
GeneralRe: Pivot? Pin
mark_w_29-Oct-10 4:28
mark_w_29-Oct-10 4:28 
GeneralRe: Pivot? Pin
Jörgen Andersson29-Oct-10 5:42
professionalJörgen Andersson29-Oct-10 5:42 
GeneralRe: Pivot? Pin
Mycroft Holmes29-Oct-10 0:27
professionalMycroft Holmes29-Oct-10 0:27 
Questionzip file Pin
tan87327-Oct-10 23:42
tan87327-Oct-10 23:42 
AnswerRe: zip file Pin
Simon_Whale28-Oct-10 5:13
Simon_Whale28-Oct-10 5:13 
GeneralRe: zip file Pin
jschell28-Oct-10 8:11
jschell28-Oct-10 8:11 
AnswerRe: zip file Pin
jschell28-Oct-10 8:14
jschell28-Oct-10 8:14 
QuestionCheck the database for existency. Pin
T.RATHA KRISHNAN27-Oct-10 21:30
T.RATHA KRISHNAN27-Oct-10 21:30 
AnswerRe: Check the database for existency. Pin
Andy_L_J27-Oct-10 21:50
Andy_L_J27-Oct-10 21:50 
QuestionRe: Check the database for existency. [modified] Pin
T.RATHA KRISHNAN28-Oct-10 0:14
T.RATHA KRISHNAN28-Oct-10 0:14 
AnswerRe: Check the database for existency. Pin
jschell28-Oct-10 8:22
jschell28-Oct-10 8:22 
T.RATHA KRISHNAN wrote:
If I use LIKE key word,it doesn't fully serve my purpose.


It does however answer your first question.

With the additional detail that you have added then something like the following would be want you want. (Unless there are other yet unstated requirements.)

select lower(name) from profile WHERE name LIKE 'sri%"


T.RATHA KRISHNAN wrote:
I've to restrict the number of records in a table. i.e I don't want to update the table if it already has 10 records in it. How to do this?


Odd requirement.

But do you know what 'count' does?

You might want to get a book or use the online documentation and read through all of the functions that are available as part of the database.

And if this system is part of a commercial/publicly available system you should look up sql injection attacks and ways to prevent that. Sql injection attacks are still a significant security problem.
Questionparameter with the In function Pin
Tamimi - Code26-Oct-10 22:55
Tamimi - Code26-Oct-10 22:55 
AnswerRe: parameter with the In function Pin
Blue_Boy26-Oct-10 23:11
Blue_Boy26-Oct-10 23:11 
GeneralRe: parameter with the In function Pin
Tamimi - Code26-Oct-10 23:47
Tamimi - Code26-Oct-10 23:47 
GeneralRe: parameter with the In function Pin
Blue_Boy26-Oct-10 23:50
Blue_Boy26-Oct-10 23:50 
GeneralRe: parameter with the In function Pin
Tamimi - Code27-Oct-10 0:05
Tamimi - Code27-Oct-10 0:05 
GeneralRe: parameter with the In function Pin
jschell28-Oct-10 8:29
jschell28-Oct-10 8:29 
AnswerRe: parameter with the In function Pin
John Gathogo27-Oct-10 0:01
John Gathogo27-Oct-10 0:01 
GeneralRe: parameter with the In function Pin
Tamimi - Code27-Oct-10 0:18
Tamimi - Code27-Oct-10 0:18 
GeneralRe: parameter with the In function Pin
David Mujica27-Oct-10 3:26
David Mujica27-Oct-10 3:26 

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.