----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SriSamp Message 2 in Discussion Hi, Stored procedures in SQL Server can only take on simple parameters. These parameters can be any of the simple data types supported in SQL Server (like INT, VARCHAR etc), or a more complex type such as XML (which you would need to get through a TEXT parameter). SQL Server 2000 does not have the intelligence to take on business objects (it will be possible through some extent via Yukon). There are a couple of solutions that I can think of: (1) Have a business stored procedure that can take in an XML document and then work off it to insert into the various tables through the use of the OPENXML command. I would not recommend this method though, since each stored procedure should ideally work against a single entity. (2) Have a business component (.NET) that understands your business entity and then forms the necessary stored procedure calls to be submitted to SQL Server. This way, SQL Server does what it is good at (which is to work on table(s)) and .NET does what it is good at (which is object oriented programming and encapsulation). In the long run, (2) will be more beneficial since you can change your business entities without affecting the underlying stored procedures. HTH, SriSamp MVP - SQL Server http://www32.brinkster.com/srisamp ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
