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

Answer Posted / sathish kondaveeti

create table value(num int(3))
insert into value values(001)
insert into value values(003)
insert into value values(023)

to see this table
select * from value

Is This Answer Correct ?    0 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the transaction properties?

644


What is meant by referential integrity?

676


A trigger can reference objects outside the current database? State true or false.

640


You want to use a perspective in an mdx query. How do you select the perspective?

172


What is tempdb in sql server?

612






What are the limitations in ssrs on sql server express edition?

150


What is SQL Azure?

93


Explain following error properties?

636


What is bit data type? What's the information that can be stored inside a bit column?

609


What is a group function explain with an example?

619


How to loop through result set objects using mssql_fetch_array()?

651


Why people hate cursor?

808


What happens if date-only values are provided as date and time literals?

643


How to update multiple rows with one update statement in ms sql server?

739


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

584