Assign value to Variable within Dynamic Query

 
DECLARE @SQLString nvarchar(500);
DECLARE @Count int;
SET @SQLString = N'SELECT @CountOUT = Count(1)
FROM M_Location WHERE SeqID =' + cast (1 as varchar(20));

EXECUTE sp_executesql @SQLString, N'@CountOUT int OUTPUT', @CountOUT = @Count OUTPUT;
SELECT @Count;
00:29 | Category: | 0 comments

Key Contraints Columns Of Table
SELECT 
        i.name AS IndexName,
        OBJECT_NAME(ic.OBJECT_ID) AS TableName,
        COL_NAME(ic.OBJECT_ID,ic.column_id) AS ColumnName
FROM   
        SYS.INDEXES AS i INNER JOIN
        SYS.INDEX_COLUMNS AS ic ON  i.OBJECT_ID = ic.OBJECT_ID                                 AND i.index_id = ic.index_id WHERE   i.is_primary_key = 1
02:51 | Category: | 0 comments