Welcome to Sign in | Help

Re: Tabele din alta baza de date?

  •  11-19-2007, 10:52 PM

    Re: Tabele din alta baza de date?

    Personal as face o procedura stocata ceva gen:

    CREATE PROC usp_GETTableT1 @DB1 bit

    AS
    BEGIN

    IF @DB1=1 SELECT MyColumn FROM BD1..T1

    ELSE SELECT MyColumn FROM BD2..T2

    END


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems