how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 7846 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
What is the data tier application?
How to list all field names in the result set using mssql_field_name()?
Explain filestream storage of sql server 2008?
Explain following error properties?
what protocol both networks use? : Sql server database administration
What is data source object?
What are a scheduled jobs?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are orphan records?
Can primary key be null?
What are the advantages of user defined function?
How to link tables in sql server?
what is a traditional network library for sql servers? : Sql server database administration
What is a file group?
How to populate a table in sql server?
