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

Answer Posted / sandeep modapathi

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What the different components of Replication and what is their use?

550


Explain transaction server auto commit?

531


Can you explain what are commit and rollback in sql?

483


What is standby servers? Explain types of standby servers.

508


Explain datetimeoffset data type in sal server 2008?

527






Do you know what is similarity and difference between truncate and delete in sql?

572


Explain candidate key, alternate key, and composite key?

586


What is 4nf in normalization form?

558


How to create sub reports?

192


What are the tools available in market as an alternative to sql server reporting services?

88


Can group functions be used in the order by clause in ms sql server?

584


What languages bi uses to achieve the goal?

507


How to get nth highest salary from employee table.

613


What is built-in function?

541


Explain about analysis services?

569