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
- 9585 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 to control the amount of free space in your index pages? : Sql server database administration
What is cursors? And what are the different types of cursor?
What are the different types of subquery?
What is the native system stored procedure to execute a command against all databases?
What are the new scripting capabilities of ssms? : sql server management studio
If a table does not have a unique index, can a cursor be opened on it?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Explain ranking functions?
How to configure and test odbc dsn settings?
What does executeupdate return?
What is policy management?
what is bit datatype? : Sql server database administration
Is it important for a database administrator to understand the operating system and file access?
How to use old values to define new values in update statements in ms sql server?
What is difference between clustered index and non clustered index?
