Collections:
Concatenating Two Character Strings in SQL Server
How To Concatenate Two Character Strings Together in SQL Server Transact-SQL?
✍: FYIcenter.com
Concatenating two character strings together is most commonly used string operation. SQL Server 2005 allows to concatenate two character strings into a single string with the (+) operator. The following tutorial exercise shows you some string concatenation examples:
DECLARE @site VARCHAR(40); SET @site = 'FYIcenter.com'; SELECT 'Welcome to '+@site; SELECT 'Current date and time is ' +CONVERT(VARCHAR(20), GETDATE()); GO Welcome to FYIcenter.com Current date and time is May 19 2007 5:18PM DECLARE @start INT, @end INT, @total INT; SET @start = 21; SET @end = 30; SET @total = 728; SELECT 'Search result ' + CONVERT(VARCHAR(20),@start) + ' - ' + CONVERT(VARCHAR(20),@end) + ' of ' + CONVERT(VARCHAR(20),@total); GO Search result 21 - 30 of 728
⇒Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-11, 830👍, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...