adspace


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 different types of constraints?

1007


How do I find query history in sql server?

1034


Why use identity in sql server?

1210


How to provide default values to function parameters?

1273


What are the kinds of subquery?

1118


Why we use the openxml clause?

1088


Can sql servers link to other servers like oracle?

928


What is self contained sub query?

1148


How raid can influence database performance?

1127


Can we do dml on views?

1042


Where can you add custom error messages to sql server?

1220


Can one drop a column from a table?

1098


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083


What is sql or structured query language?

1235


Explain “row_number()” in sql server with an example?

1086