Inserting email address to sql server table

Posted by Cibin under ASP.NET on 4/14/2014 | Points: 10 | Views : 455 | Status : [Member] | Replies : 3
Hi all,

How to insert an email address into a sql table. Please help me out.


Regards,

Cibin




Responses

Posted by: A2H on: 4/14/2014 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can declare a VarChar column in your table and use it just like another string variable.
CREATE TABLE SampleTable
(
EmailAddress VARCHAR(250)
);

Are you facing any issues while try to insert data into sql table.

Thanks,
A2H
My Blog

Cibin, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A2H on: 4/14/2014 [Member] [MVP] Silver | Points: 25

Up
0
Down
If you want an advanced mechanism to save the Email address then you can take a look at the below link
Storing E-mail addresses more efficiently in SQL Server
http://www.mssqltips.com/sqlservertip/2657/storing-email-addresses-more-efficiently-in-sql-server/

Thanks,
A2H
My Blog

Cibin, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Cibin on: 4/14/2014 [Member] Starter | Points: 25

Up
0
Down
yes, when am inserting the address, the multi-part identifier "example@dmn.com" could not be bound.

Cibin, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response