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

What are the types of table?

919

What is acid mean in sql server?

1036

How we create SQL Server 2005 Reporting Services ? Give me Sample

1938

Is null in sql server?

939

How much does sql server 2016 cost?

988

What is a covering index?

920

Explain relational data?

856

What factors you will consider calculating the storage requirement for that view?

895

what is unique and xaml nonclustered index

996

How to rebuild indexes with alter index ... Rebuild?

1033

How and why use sql server?

953

What is explicit cursors?

988

What are various limitations of the views?

997

How do I start sql server 2017?

887

What are distributed partitioned views?

1006