Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT View results to file
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01505424
Message ID:
01505425
Vues:
38
>Hello,
>
>I am writing an import utility that will ultimately query another company's SQL database so that information already typed into that other company's database does not have to be retyped into my software.
>
>The other company has written a read only view and installed it in a common client's sandbox SQL database.
>
>How do I run the SQL View and have it export data in a format that I can import into a table on my development machine so that I can test the import utility?
>
>I would like to get several records from the view and put them in a table on my development machine so that I can test to ensure everything that I am getting in the view will work properly during the import.
>
>Thanks,
>
>TFISHER

Assuming you have an access to the view, you just need

select * from myView -- using the right database

to get the information.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform