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 the different types of collation sensitivities in sql server?

972

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1067

Tell me the phases a transaction has to undergo?

917

What are the properties of sub-query?

1023

What is data set in report?

121

How do I make a resultset scrollable?

908

How do I setup a sql server database?

1001

How to get a list of columns in a view using the "sp_help" stored procedure?

987

Can you explain what is indexed view? How to create it?

850

What is the difference between drop table and truncate table?

872

explain different types of backups avaialabe in sql server? : Sql server database administration

919

What are the different types of collation sensitivity in sql server?

1034

How many clustered indexes there can be on table ?

987

What is the native system stored procedure to execute a command against all databases?

968

What is acid mean in sql server?

1035