replicate('0',3-len(field_name))+field

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

Question Posted / sandeep modapathi

Answer Posted / sandeep modapathi

replicate('0',3-len(field_name))+field_name

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is transaction server auto commit?

1066

How do you rename a table in sql server?

1026

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1327

Can we call future method from queueable?

1052

Explain different types of Normalization.

1835

What is left outer join in sql server joins?

1042

explain the storage models of olap? : Sql server database administration

959

What is command parameter in ssrs?

161

Can two tables have the same primary key?

1209

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

942

What are the disadvantages of indexes?

1090

What is importing utility?

986

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

979

Explain the difference between function and stored procedure?

945

Mention what are the core components of ssrs?

323