create table t(NUM int(22)) insert into t values(001) insert into t value

how we can store the value like that 001,003,023 etc in sql
server 2005

Question Posted / nadeem

Answer Posted / nadeem

create table t(NUM int(22))
insert into t values(001)
insert into t values(002)
insert into t values(023)

Is This Answer Correct ?

1 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What are the steps to follow to configure SQL*Net?

654

Define primary key?

764

Tell me what is de-normalization and what are some of the examples of it?

659

What are acid properties of transaction?

628

Do you know what is openxml in sql server?

691

What are the types of joins in sql?

655

Define msdb database?

680

What stored by the master? : sql server database administration

653

What is normalization? Describe its different types.

672

What is sql server locking?

619

what types of replication are supported in sql server? : Sql server database administration

559

What is snapshot report?

132

How can you set the threshold at which sql server will generate keysets asynchronously?

657

What is transaction server explicit transaction?

643

What is data mart? : sql server analysis services, ssas

687