how we can store the value like that 001,003,023 etc in sql
server 2005
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 do you mean by an execution plan? How would you view it?
What are the types of stored procedures in an sql server?
how many clustered indexes can be created on a table? : Sql server database administration
Explain the etl (extraction, transformation, and loading)?
What is difference between order by and group by?
What is a trace frag?
What factors you will consider calculating the storage requirement for that view?
What is the difference between function and stored procedure in sql server?
What is transaction server distributed transaction?
What are the properties and different types of sub-queries?
How to bind a view to the schema of the underlying tables?
How do I shrink an ldf file?
Explain table valued parameters in sql server? Why tvp used?
What is transact-sql ddl trigger?
Can We Use Data-grids For Our Report In Ssrs?