Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cathryn

    Passing variables in an XML String

    Yes! Thank you so much! It worked perfectly!
  2. Cathryn

    Passing variables in an XML String

    Actually it's something like this... SELECT @XML = '<SearchParameters Param1=&quot;123456&quot; Param2=&quot;1&quot; Param3=&quot;cabin&quot;/>' The SQl Exec string is... EXEC spStoredProc @Xml The the stored proc would take the parameters in the XML string and assign them to variables to...
  3. Cathryn

    Passing variables in an XML String

    We're trying to pass an XML string to a stored proc instead of multiple parameters. How do you take that XML string and just assign what is passed to different variables without creating a table to insert them or doing a plain SELECT * FROM OpenXML... The only examples I can find return a...
  4. Cathryn

    Restoring a Database

    I have a question along these lines. Our server went down so we weren't able to 'detach' the database files. Can I copy them to another server and create a database for them?

Part and Inventory Search

Back
Top