Database

VK-Cadec wrote:

Is there a way I can select out this value from across all the tables in a particular database

SELECT * FROM Table1
UNION
SELECT * FROM Table2
UNION
SELECT * FROM Table3

DECLARE @sql nvarchar(4000);
DECLARE EventCursor CURSOR
FOR
SELECT 'SELECT * FROM ['+TABLE_SCHEMA+'].['+TABLE_NAME+'] WHERE eventNum= @eventNum' 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME = 'EventNum'
OPEN EventCursor
FETCH NEXT FROM EventCursor INTO @sql
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC sp_executesql @stmt = @sql,
         @params = N'@eventNum int',
         @eventNum = 4 -- Replace this number with the desired event number
                       -- or a parameter that represents it.
    FETCH NEXT FROM EventCursor INTO @sql
END
CLOSE EventCursor
DEALLOCATE EventCursor

Ennis Ray Lynch, Jr. wrote:

Don't listen to the naysayers. Using T-SQL you can

DECLARE @sql nvarchar(4000);
DECLARE EventCursor CURSOR
FOR
SELECT 'SELECT * FROM ['+TABLE_SCHEMA+'].['+TABLE_NAME+'] WHERE eventNum= @eventNum' 
FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'EventNum'
OPEN EventCursor
FETCH NEXT FROM EventCursor INTO @sql
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC sp_executesql @stmt = @sql, 
        @params = N'@eventNum int', 
        @eventNum = 4 -- Replace this number with the desired event number 
                      -- or a parameter that represents it.
    FETCH NEXT FROM EventCursor INTO @sql
END
CLOSE EventCursor
DEALLOCATE EventCursor

ma_refay wrote:

how i check the sysindexs table of database doesn't connected to sqlserver

TheEagle wrote:

Ofcourse your first respond helped me to go in the right way..Thank you very much..I hope that we meet again in another exciting conversation