TSQL: Concatenate Multiple Rows into String
use Northwind declare @CategoryList varchar(1000) select ‘Results = ‘ + @CategoryList
select @CategoryList = coalesce(@CategoryList + ‘, ‘, ”) + CategoryName from Categories
Showing posts with label SQL SERVER. Show all posts
Showing posts with label SQL SERVER. Show all posts
Computed Column Specification
Posted in Labels: SQL SERVER | at 8:52 PM
Ex :
(((isnull([AuthorizedQtyU1],isnull([InvoiceQtyU1],(0)))-isnull([ReceivedQtyU1],(0)))-isnull([DamagedQtyU1],(0)))-isnull([MissingQtyU1],(0)))
Is Persisted = no
(datediff(minute,[StartTime],[EndTime]))
Is Persisted = no
filter sql
Posted in Labels: SQL SERVER | at 9:31 PM
WHERE convert (datetime, convert (varchar, datecol, 101), 101) = @yourdate
Subscribe to:
Posts (Atom)