how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 8231 Views
- I also Faced
- E-Mail Answers
Answer Posted / nadeem
create table t(NUM int(22))
insert into t values(001)
insert into t values(002)
insert into t values(023)
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
Do you know what is a linked server in sql server?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is the benefit of normalization?
please differentiate between delete and truncate?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What do you mean by an execution plan? How would you view it?
How do I know if localdb is running?
What is trace flag in sql server?
What is the purpose of sql profiler in sql server? : sql server database administration
Can the “if update (colname)” statement be used in a delete trigger?
How to generate create procedure script on an existing stored procedure?
What is explicit mode in sql server?
What is the purpose of grouping data in a report?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are the differences between union, intersect, and minus operators?
