how we can store the value like that 001,003,023 etc in sql
server 2005
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
Explain sql delete command?
Who is the owner of a schema in ms sql server?
Can you explain various data region available in ssrs with their use?
What is exporting utility?
When we should use and scope of @@identity?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is dknf in normalization form?
How to create a user name in a database?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are various aggregate functions that are available?
What is an identity?
What is the difference between writing data to mirrored drives versus raid5 drives
What are the types of containers in ssis?
what are the new features in SSRS?
What is the stored procedure?