Interested to Buy Any Domain ? << Click Here >> for more details...
how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 9357 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
Explain about analysis services?
What are drillthrough reports?
How to update muliple row in single query?
How you trouble shoot when any job fails
What is triggers in ms sql server?
can a database be shrunk with users active? : Sql server administration
How do we know if any query is retrieving a large amount of data or very little data?
why would you call update statistics? : Sql server database administration
Why truncate is ddl command?
What does it mean to manipulate data?
Describe different Processing Modes offered by SSRS?
Which trace flags are enabled in sql server?
How to verify a login name with sqlcmd tool?
What are the reporting services components?
What is ms sql server reporting services?
