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

Can we take the full database backup in log shipping?

993

Write an sql query to find first weekday of the month?

975

What options are available to audit login activity? : sql server security

1196

Do you know what is similarity and difference between truncate and delete in sql?

1061

Please explain what is “asynchronous” communication in sql server service broker?

979

Where to find ntwdblib.dll version 2000.80.194.0?

1007

Do you know what is bit data type and whats the information that can be stored inside a bit column?

996

What is ms sql server reporting services?

1122

Explain Reporting Life Cycle?

132

What is data block and how to define data block size?

1077

What are different types of raid levels?

1235

How to list all objects in a given schema?

1103

What is the use of partition by in sql server?

968

How to assign new column names in a view?

957

Explain the various types of concurrency problem?

1238