UPDATE [APPPARAM] SET [APPPARAM_VALUE] = Replicate('0', 3

how we can store the value like that 001,003,023 etc in sql
server 2005

Question Posted / laxman r

7 Answers
9354 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

Please Help Members By Posting Answers For Below Questions

Explain Geometry datatype in sql server 2008 with example

991

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1011

How to automatically create a log when an exception is being received into SQL Server?

1289

What are the types of processing and explain each? : sql server analysis services, ssas

1150

How to use subqueries with the exists operators in ms sql server?

1119

What are horizontal and vertical scaling?

172

What are the benefits of normalization?

1109

Explain trigger classes i.e. Instead of and after trigger?

877

System variable and temporary variables

2253

What is model database in sql server?

1054

How to find Duplicate Records In table?

1018

What is report server project?

147

How to create a dml trigger using create trigger statements?

1035

What is table-valued sub query?

970

How to generate create view script on an existing view?

988