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

List some advantages and disadvantages of stored procedure?

1016

How to disable a login name in ms sql server?

1134

Explain linked server in sql?

1220

Do you know what is user defined datatypes and when you should go for them?

968

What are system databases into sql server (2005/2008)?

999

What is isolation levels?

1029

How do clustered indexes store data?

1106

What is the purpose of a table?

959

what method you can use to reduce the overhead of Reporting Services data sources?

255

How to use transact-sql statements to access the database engine?

1067

Explain syntax for disabling triggers?

1040

How much does sql server 2016 cost?

1071

Can I use sql azure as a backup with log shipping or database mirroring?

156

Tell me the phases a transaction has to undergo?

962

How do I make a resultset scrollable?

960