Make SQL select statement to get same row multiple times

If I get your meaning then a very simple way is to cross join on a derived query on a table with more than 1000 rows in it and put a top 1000 on that. This would duplicate your results 1000 times.

SELECT

    MyTable.*

FROM

    MyTable

CROSS JOIN

(

    SELECT TOP 1000

        *

    FROM

        sysobjects

) [BigTable]

WHERE

    MyTable.ID = 1234

 

Get List of Triggers from Database

SELECT

     sysobjects.name AS trigger_name

    ,USER_NAME(sysobjects.uid) AS trigger_owner

    ,s.name AS table_schema

    ,OBJECT_NAME(parent_obj) AS table_name

    ,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate

    ,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete

    ,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert

    ,OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS isafter

    ,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isinsteadof

    ,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]

FROM sysobjects

/*

INNER JOIN sysusers

    ON sysobjects.uid = sysusers.uid

*/ 

INNER JOIN sys.tables t

    ON sysobjects.parent_obj = t.object_id

INNER JOIN sys.schemas s

    ON t.schema_id = s.schema_id

WHERE sysobjects.type = 'TR'