Page 2 of 20 FirstFirst 123412 ... LastLast
Results 11 to 20 of 197

Thread: IT Professionals

  1. #11
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,330
    Post Thanks / Like
    Quote Originally Posted by Raikkonen
    i don't have any servers installed at my home..

    i will try to read and understand this at office
    enNa try paneenghala

    r u SQL server Developer?? I am one
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. #12
    Banned Veteran Hubber
    Join Date
    Mar 2006
    Location
    Camp Arawak
    Posts
    3,322
    Post Thanks / Like
    ileeng sorry..

    i'm more into network/web programming.

    just got the mcse cert.. but not very familiar with sql server.

  4. #13
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,330
    Post Thanks / Like
    Quote Originally Posted by Raikkonen
    ileeng sorry..

    i'm more into network/web programming.

    just got the mcse cert.. but not very familiar with sql server.
    Oh cool. so u can do java scripting and .net programming right , if i have any doubts i shall ask, cos .Net & sql server are highly integrated , they work very closley
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  5. #14
    Banned Veteran Hubber
    Join Date
    Mar 2006
    Location
    Camp Arawak
    Posts
    3,322
    Post Thanks / Like
    cool..

    i haven't worked with java for some years now. i can do the applets etc.. almost in advanced stage.

    ya. i'm working in net environment.

  6. #15
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,330
    Post Thanks / Like
    Raiks

    aama neenga enna 'Diamon' smuggling busniess panrEla?? Diamon hubber nu title kudithirukuranga
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  7. #16
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,330
    Post Thanks / Like
    Hi

    I have SQL table with a customer table in SQL server , having columns (name, lastname)
    the last name contains values like (o'corner, o'brian) how would i search for these records iusingT-SQL

    Select * from customers
    where lastname like 'O'coner%'

    it does not work cause of the single quote bewteen O and C... any way round it?

    Raiks??
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  8. #17
    Senior Member Diamond Hubber Nerd's Avatar
    Join Date
    Mar 2005
    Posts
    5,981
    Post Thanks / Like
    Add another apostrophe. Something like,

    Code:
    select * from customers
    where lastname like 'O''CORNER%'

  9. #18
    Senior Member Platinum Hubber
    Join Date
    Oct 2004
    Posts
    12,702
    Post Thanks / Like

  10. #19
    Senior Member Platinum Hubber
    Join Date
    Oct 2004
    Posts
    12,702
    Post Thanks / Like
    To add to Nerd's post, if you're going to call the sql from a webpage etc, this kind of concatenation could pose sql-injection threat and this link gives a solution for that :
    http://it.toolbox.com/wiki/index.php...SQL_queries%3F

  11. #20
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,330
    Post Thanks / Like
    Quote Originally Posted by Nerd
    Add another apostrophe. Something like,

    Code:
    select * from customers
    where lastname like 'O''CORNER%'
    Danks Nerd
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

Page 2 of 20 FirstFirst 123412 ... LastLast

Similar Threads

  1. IT Professionals
    By Raghu in forum Miscellaneous Topics
    Replies: 206
    Last Post: 19th July 2007, 09:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •