http://aspnet.4guysfromrolla.com/articles/103002-1.2.aspx
I would like to know how to create a 'password' column where the data type is a binary type of length 16
This is my table:
CREATE TABLE Staff
(
Namevarchar (50)PRIMARYKEY,
Password ?? NOT NULL,
Role varchar (50)NOT NULL
)
Please review my code. Thanks in advance for helping me out here!
-Gabian-binary(16)
Check SQL Server's Books Online that's installed with Sql Server for reference. It has a lot of knowledgebase.|||Hi,
Thanks man. I realised the mistake in the create table was in the Primary key. Because of that, I thought that there was a problem with the statement with binary. (First time creating a table with binary value here)
I have downloaded the online book. Thanks for your advice!
-Gabian-sql
No comments:
Post a Comment