Interested to Buy Any Domain ? << Click Here >> for more details...
how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 9576 Views
- I also Faced
- E-Mail Answers
Answer Posted / laxman r
UPDATE [APPPARAM] SET [APPPARAM_VALUE] = Replicate('0', 3 -
Len(convert(varchar, (@DATABASE_IDENTITY_NO + 1)))) +
convert(varchar, (@DATABASE_IDENTITY_NO + 1)) FROM
[APPPARAM] a WHERE a.[APPPARAM_KEY] = @AppParamKey
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is logshipping and its purpose?
What are differences in between sql server 2012 and sql server 2016?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is importing utility?
What do you mean by a Composite primary key?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
How to locate and take substrings with charindex() and substring() functions?
What is the difference between function and stored procedure in sql server?
How many tables can be joined in SQL Server?
Tell me about the approaches which you used to counter the DI problems.
What is policy based management (pbm)? : sql server database administration
What are the advantages of policy management?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Explain foreign key in sql server?
Differentiate between a having clause and a where clause.
