STUFF ile istenilen alana ait değerleri “,” ile bir araya getirme

DECLARE @cols AS NVARCHAR(MAX); DECLARE @query AS NVARCHAR(MAX); select @cols = STUFF((SELECT distinct ‘,’ + QUOTENAME(Name) FROM property FOR XML PATH(”), TYPE ).value(‘.’, ‘NVARCHAR(MAX)’) , 1, 1, ”); SELECT @query = ‘SELECT * FROM ( SELECT o.object_id, p.Name, o.value FROM propertyObjects AS o INNER JOIN property AS p ON o.Property_Id = p.Id ) AS t […]

SELECT LAG(p.FirstName) OVER (ORDER BY p.BusinessEntityID) PreviousValue, p.FirstName, LEAD(p.FirstName) OVER (ORDER BY p.BusinessEntityID) NextValue FROM Person.Person p       Kaynak: sqlauthority.com

DECLARE @TableName NVARCHAR(128)=’TabloAdi’ BEGIN TRAN DECLARE @NextId NUMERIC = CASE WHEN (IDENT_CURRENT(@TableName) = 1) THEN 1 ELSE 0 END DECLARE @Sql NVARCHAR(MAX) = ‘DELETE FROM [‘ + @TableName + ‘]’ EXECUTE sp_executesql @Sql IF (@@ERROR = 0) BEGIN DBCC CHECKIDENT (@TableName, RESEED, @NextId) COMMIT TRAN END ELSE BEGIN ROLLBACK END     Kaynak: Eduardo Cuomo