How to save array of integer numbers in a column in SQL Server 2005

Posted by hamed on Stack Overflow See other posts from Stack Overflow or by hamed
Published on 2010-12-26T05:34:06Z Indexed on 2010/12/26 7:53 UTC
Read the original article Hit count: 232

Filed under:
|

I have a table in SQL Server 2005 with the following properties:

Users (UserID, Username, Password)   where UserID is primary key

I want to save an array of integer numbers in the password attribute in the Users table.

--------------------
 0    1    2    3  
--------------------
1543 6543 7658 8765
--------------------

I plan to save this into the password column.

On the other hand I use pictures instead of texts for password and each picture has a code (4 digit) and a password include 4 picture that produce 16 digit. I want to save these 16 digits (array of Ints) into the Password column

please help me.

thanks

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005