how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 8222 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohammad saddam
CREATE TABLE NumAsVar (Num nvarchar(50))
INSERT INTO NumAsVar VALUES ('001')
INSERT INTO NumAsVar VALUES ('002')
INSERT INTO NumAsVar VALUES ('021')
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the properties of primary key?
What is the temp table?
Explain different types of locks in sql server.
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Is sql server difficult to learn?
Can group functions be used in the order by clause in ms sql server?
Define master database?
What is report server project?
What is the distinction amongst delete and truncate?
What are types of subqueries?
What is the order in which the sql query is executed?
What is a unique index?
What is meant by indexing?
List the types of recovery model available in sql server?
Can you get second highest salary from the table?
