Using Character Datatypes See this CREATE TABLE NumAsVar (Num VARCHAR(50)

how we can store the value like that 001,003,023 etc in sql
server 2005

Question Posted / gopi muluka

7 Answers
9572 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

Please Help Members By Posting Answers For Below Questions

How to connect sql server management studio express to sql server 2005 express?

1090

Tell me what is difference between clustered and non clustered index?

981

Can we delete data from a view?

976

Can an automatic recovery be initiated by a user?

1065

Can you force a query to use a specific index?

985

What is difference between rownum and row_number?

1019

How to get a list of columns using the "sys.columns" view in ms sql server?

1003

Can you tell me some of the common replication dmv's and their use? : sql server replication

972

What is sql view?

1108

How do I run sql server 2014?

1051

What is collation sensitivity?

1131

What are the different SQL Server Versions you have worked on?

1055

What is the difference between osql and query analyzer?

1044

what is dbcc? : Sql server database administration

1075

What is the difference between dbcc indexdefrag and dbcc reindex?

1030