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
What the different components of Replication and what is their use?
Explain transaction server auto commit?
Can you explain what are commit and rollback in sql?
What is standby servers? Explain types of standby servers.
Explain datetimeoffset data type in sal server 2008?
Do you know what is similarity and difference between truncate and delete in sql?
Explain candidate key, alternate key, and composite key?
What is 4nf in normalization form?
How to create sub reports?
What are the tools available in market as an alternative to sql server reporting services?
Can group functions be used in the order by clause in ms sql server?
What languages bi uses to achieve the goal?
How to get nth highest salary from employee table.
What is built-in function?
Explain about analysis services?