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 is the difference between value type and reference type?
When is update_statistics command used?
What is the difference between local and global temporary tables?
Which is better statement or preparedstatement?
What are the different sql server versions?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is table value parameters (tvp)?
Explain the dbcc pintable command when would you use it?
Explain about thread and memory management process of SQL?
Explain the use of containers in ssis and also their types?
How to drop an existing table?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Explain alternate key, candidate key and composite key in sql server?
Tell me what are cursors and when they are useful?