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
- 9042 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 are wait types?
What are Row versions of DataRow?
How to throw custom exception in Stored Procedure?
What is the difference between clustered index and primary key?
Is the log file is a part of file group?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How you provide security to cube? : sql server analysis services, ssas
What languages bi uses to achieve the goal?
Distinguish between nested subquery and correlated subquery?
New concepts of sql server 2005 use in your project.
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to generate create function script on an existing function?
How real and float literal values are rounded?
What is normalization process?
How to configure and test odbc dsn settings?
