Vipin Tyagi
Sql related
By Vipin Tyagi in SQL Server on Feb 28 2014
  • Khan Abrar Ahmed
    May, 2014 8

    Hi, you can use the seperator to insert the address as string. or create a new table with refrence of person id and store the address on this table.

    • 0
  • Naitik  Jani
    Apr, 2014 10

    You can do that by one way..Person which have 3 addresses you can store that address into Address column only with some special kind of separator "|]|" Address1|]|Address2|]|Address3 and for all other records only Address1 and with help of separator you can identify the same. for your easiness.Hope this can help you..

    • 0
  • Vipin Tyagi
    Feb, 2014 28

    if there are some column in a table 

    one column is for address 
    there are 50 people in table 
    we want to store 3 address for a person and other 49 have only single address 
    how we write the query

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS