Just for completeness – in SQL 2008 you would use the plus +
operator to perform string concatenation.
Take a look at the MSDN reference with sample code. Starting with SQL 2012, you may wish to use the new CONCAT function.
More Related Contents:
- Comma separated results in SQL
- How to check if a column exists in a SQL Server table
- Understanding PIVOT function in T-SQL
- Using T-SQL, return nth delimited element from a string
- Get first day of week in SQL Server
- Using RegEx in SQL Server
- How do you view ALL text from an ntext or nvarchar(max) in SSMS?
- Confused about UPDLOCK, HOLDLOCK
- INSERT INTO vs SELECT INTO
- SQL Server 2008 Empty String vs. Space
- How to set a default value for an existing column
- Select / Insert version of an Upsert: is there a design pattern for high concurrency?
- TSQL: How to convert local time to UTC? (SQL Server 2008)
- SQL Server: combining multiple rows into one row
- How do I find a stored procedure containing ?
- SQL Recursive CTE: Finding objects linked by property
- How to convert number of minutes to hh:mm format in TSQL?
- Convert decimal time to hours and minutes
- SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
- How do I move a table into a schema in T-SQL
- Instead of trigger in SQL Server loses SCOPE_IDENTITY?
- How Can I Detect and Bound Changes Between Row Values in a SQL Table?
- How to wait for 2 seconds?
- What are row, page and table locks? And when they are acquired?
- Generate MD5 hash string with T-SQL
- Max Nbr of Months W/ No Activity in Past 12 Months
- Export from SQL Server to Excel
- tsql returning a table from a function or store procedure
- How do you determine what SQL Tables have an identity column programmatically
- TSQL – How to use GO inside of a BEGIN .. END block?