DataSet Usage In SQL statements
Posted on 2004-08-02
so I have a database that contain's a table called accounts. The table's schema is:
ID Username Password
I also have an XML file which lists a bunch of ID's in it;
ID = "dasdfds"
ID = "asdfda"
Thus the xml file contains a bunch of ID's that I gather into a dataset, or datatable. My question is whether there is an easy way with SQL or MSSQL to acquire all the row's in the "accounts" table whose ID colum matches the ID values in the XML dataset?
Any help on this would be greatly appreciated :)