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
What are different types of constraints?
How do I find query history in sql server?
Why use identity in sql server?
How to provide default values to function parameters?
What are the kinds of subquery?
Why we use the openxml clause?
Can sql servers link to other servers like oracle?
What is self contained sub query?
How raid can influence database performance?
Can we do dml on views?
Where can you add custom error messages to sql server?
Can one drop a column from a table?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is sql or structured query language?
Explain “row_number()” in sql server with an example?