how we can store the value like that 001,003,023 etc in sql
server 2005
- 7 Answers
- 8223 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
How to link tables in sql server?
Can you explain what are commit and rollback in sql?
Does full backup break log chain?
Describe the left outer join & right outer join. : sql server database administration
What is surrogate key? : sql server analysis services, ssas
How to delete exactly duplicate records from a table?
What command do we use to rename a database?
What is a transact-sql statement?
what is sql server? : Sql server database administration
what is the system function to get the current user's user id? : Sql server database administration
How to connect to a sql server using odbc_connect()?
How to list all dsn entries on your local machine using odbc_data_source()?
What’s the distinction between dropping a info and taking a info offline?
Can we use having clause without group by?
What is table-valued sub query?
