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
⇒ String Type Conversion During Concatenation in SQL Server
⇐ Character Strings and Binary Strings in SQL Server Transact-SQL
⇑ Character Strings and Binary Strings in SQL Server Transact-SQL
2017-03-11, 1510🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...