<div>
update dbo.Products <br />
set ProName=1000+ProName
</div>


update dbo.Products
set ProName=1000+ProName

<div>
soryy<br />
what abhot if i have in the ProName :<br />
XXX<br />
YYY<br />
SSS<br />
now how can fix that to :<br />
1001<br />
1002<br />
1003<br />
???
</div>


soryy
what abhot if i have in the ProName :
XXX
YYY
SSS
now how can fix that to :
1001
1002
1003
???

<div>
UPDATE dbo.Products<br />
&nbsp; &nbsp;SET [ProName] = cast((cast(ProName as numeric)+1000) as varchar)
</div>


UPDATE dbo.Products
   SET [ProName] = cast((cast(ProName as numeric)+1000) as varchar)

<div>
Error converting data type nvarchar to numeric.
</div>


Error converting data type nvarchar to numeric.

<div>
i want to set a numeric from number to number<br />
to this fild<br />
even if the fild are filled whit string
</div>


i want to set a numeric from number to number
to this fild
even if the fild are filled whit string

<div>
to make a runing number to all rows in the table<br />
if i have 10 rows and i want if to strat from the number 5000<br />
its end in the last row 5009<br />

</div>


to make a runing number to all rows in the table
if i have 10 rows and i want if to strat from the number 5000
its end in the last row 5009


<div>
<div class="content wysiwyg-content">
hi there ,<br />
i have this col that i want to update <br />
proName (nvarhcar type)<br />
1<br />
2<br />
3<br />
4<br />
i want to update its to :<br />
1001<br />
1002<br />
1003<br />
1004<br />
i try to do this :<br />
update dbo.Products set ProName=1001+1<br />
but its not working<br />
how can i fix that ?<br />
<br />

</div>
</div>


hi there ,
i have this col that i want to update 
proName (nvarhcar type)
1
2
3
4
i want to update its to :
1001
1002
1003
1004
i try to do this :
update dbo.Products set ProName=1001+1
but its not working
how can i fix that ?



update col numbers

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.