MSSQL – CONCAT

Problem:

Spajanje dvaju polja u jedno npr. prilikom SELECTA, dakle MSSQL verzija MySql funkcije CONCAT

http://systasis.biz/blog/?p=45

Rješenje:

 SELECT ime + ' ' + prezime as korisnik FROM tbl_osobe
This entry was posted on Friday, November 25th, 2011 at 10:14 pmand 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.