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 is transaction server auto commit?
How do you rename a table in sql server?
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?
Can we call future method from queueable?
Explain different types of Normalization.
What is left outer join in sql server joins?
explain the storage models of olap? : Sql server database administration
What is command parameter in ssrs?
Can two tables have the same primary key?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the disadvantages of indexes?
What is importing utility?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain the difference between function and stored procedure?
Mention what are the core components of ssrs?