how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 8221 Views
- I also Faced
- E-Mail Answers
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
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?
Explain try...catch with sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the properties of sub-query?
How to link tables in sql server?
How to call stored procedure using http soap?
How to find which stored procedure is currently running in sql server?
how can a database be repaired? : Sql server administration
What are acid properties of transaction?
What are the differences between union, intersect, and minus operators?
How to encrypt data between dialogs?
How do you create type- insensitive operator?
How can I track the changes or identify the latest insert-update-delete from a table?
Explain differentiate between a having clause and a where clause?
What is a view and what are its advantages?
