MSSQL int to string

Problem: pretvoriti int u string unutar stored procedure

 

Rješenje:

 


DECLARE @broj_narudzbe nvarchar(50)
 DECLARE @Godina int
 DECLARE @broj int

SELECT @broj_narudzbe = CAST(@broj as varchar(10))+'-'+CAST(@Godina as varchar(10))
This entry was posted on Tuesday, September 25th, 2012 at 6:08 amand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.