how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 8220 Views
- I also Faced
- E-Mail Answers
Answer Posted / gopi muluka
Using Character Datatypes
See this
CREATE TABLE NumAsVar (Num VARCHAR(50))
INSERT INTO NumAsVar VALUES ('001')
INSERT INTO NumAsVar VALUES ('002')
INSERT INTO NumAsVar VALUES ('021')
SELECT * FROM NumAsVar
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
How many triggers you can have on a table?
How can you check the level of fragmentation on a table?
Name the different type of indexes in sql?
Explain sql server authentication modes?
Do you know hot add cpu in sql server 2008?
Why Master database is required?
Can foreign key be deleted?
Define full outer join?
Explain about merge replications?
How to insert stored procedure result into temporary table?
What is left outer join in sql server joins?
What is data file in computer?
How is foreign key related to primary key?
Explain the steps to create and execute a user-defined function in the sql server?
Tell me what is sql profiler?
