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
9045 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

What are the options which must be set to allow the usage of optimistic models?

915

What is spid in sql server profiler?

1026

Tell me about joins in database system and explain each in detail.

1005

What are the different sql server versions?

931

What is compound operators?

975

Can foreign key be deleted?

871

Differentiate between a having clause and a where clause.

925

How can I tell if sql server is 32 or 64 bit?

901

Where cross join is used?

904

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

895

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

997

Define left outer join in sql server joins?

906

What does it mean to normalize data?

895

How to create percentile function?

139

What the different components of Replication and what is their use?

1015