C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
iOS
Java
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
3
Reply
Sql related
Vipin Tyagi
11y
1k
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
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.
Khan Abrar Ahmed
11y
0
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..
Naitik Jani
11y
0
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
Vipin Tyagi
11y
0
Message