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 difference between unique and primary key?

972

What is indexed view? How to create it?

1068

How to rebuild master databse?

1127

What is lock escalation? : sql server database administration

1198

What is the advantage of sql server?

1080

What is the difference between a unique key and primary key?

1004

What is command parameter in ssrs?

166

What is the recursive stored procedure in sql server?

1076

Can we take the full database backup in log shipping?

995

Explain what are magic tables in sql server?

1046

Do you know what is openxml in sql server?

1113

What is the difference RDBMS and Graph Database?

1091

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

977

How to view existing indexes on an given table using sp_help?

1205

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1993