how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 7847 Views
- I also Faced
- E-Mail Answers
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
Can a function call a stored procedure in sql server?
how would you troubleshoot blocking? : Sql server database administration
What are the database objects? : SQL Server Architecture
Explain “not null constraint” in sql server?
How do I make a resultset scrollable?
Can we insert data into a view?
Write a sql query to sort on different column name according to the parameters passed in the function?
How to concatenate two strings in SQL Server.
How to change the data type of an existing column with "alter table" statements in ms sql server?
What are basics of policy management?
What are the ways available in sql server to execute sql statements?
what are the three command line utilities and what are their primary functions?
how to trace the traffic hitting a sql server? : Sql server database administration
How to create a large table with random data for index testing in ms sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
