SQL Server for Starters

SQL Server for Starters Archief

  • ▼  2008 (89)
    • ►  december (45)
      • ►  dec 31 (1)
      • ►  dec 30 (5)
      • ►  dec 29 (5)
      • ►  dec 23 (2)
      • ►  dec 22 (4)
      • ►  dec 19 (1)
      • ►  dec 16 (7)
      • ►  dec 15 (4)
      • ►  dec 12 (6)
      • ►  dec 11 (2)
      • ►  dec 09 (1)
      • ►  dec 05 (1)
      • ►  dec 04 (4)
      • ►  dec 01 (2)
    • ▼  november (44)
      • ►  nov 28 (1)
      • ►  nov 27 (5)
      • ►  nov 26 (2)
      • ►  nov 25 (6)
      • ►  nov 24 (2)
      • ▼  nov 21 (1)
        • Get sqlcmd output into a table?
      • ►  nov 20 (7)
      • ►  nov 19 (4)
      • ►  nov 17 (6)
      • ►  nov 14 (2)
      • ►  nov 13 (4)
      • ►  nov 12 (4)

Over mij

SQL Server for Satrters
Mijn volledige profiel tonen

vrijdag 21 november 2008

Get sqlcmd output into a table?

CREATE TABLE ServerList_SSIS([Server] NVARCHAR(512),
[Connect] bit,
[DMZ] bit);
INSERT INTO ServerList_SSIS([Server])
EXEC master..xp_cmdshell 'sqlcmd /Lc';

Delete from ServerList_SSIS where [Server] IS NULL;
Select * from ServerList_SSIS
Gepost door SQL Server for Satrters op 17:12 Geen opmerkingen:
Labels: Get sqlcmd output into a table?
Nieuwere posts Oudere posts Homepage
Abonneren op: Posts (Atom)