CREATE TABLE NumAsVar (Num nvarchar(50)) INSERT INTO NumAsVar VALUES (

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

Question Posted / mohammad saddam

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

Please Help Members By Posting Answers For Below Questions

explain extended properties

560

What is query parameter in ssrs?

118

What is difference between rownum and rowid?

503

Tell me what do we need queues in sql service broker?

512

Can I disable or restrict ssrs export formats (rendering formats)?

108

What is named calculation? : sql server analysis services, ssas

527

what is datawarehouse?

644

What are the properties of the relational tables?

486

How do you delete a data source?

535

Is natural join and equi join same?

519

What is subreport?

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

666

What are transactions and its controls?

610

What type of Index will get created after executing the above statement?

633

What is nonclustered index with included columns ?

544