vbfeeds.com/Date

The content of the postings is owned by the respective author. vbfeeds.com is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on vbfeeds.com, please contact us at abuse@vbfeeds.com and we will remove it. Designated trademarks and brands are the property of their respective owners. vbfeeds.com Copyright © 2005 Serge Baranovsky. All rights reserved.

Monday, February 19, 2007

Determining the table updated inside of a SqlTrigger

by Maurice via Maurice de Beijer on 2/19/2007 3:48:15 PM

SQL CLR is pretty cool and lets you quickly do lots of things that are hard, if not impossible, to code in TSQL. But if you want to create generic code you sometimes need to know the context that the code is running under. The problem I had was creating a generic table update trigger and knowing the table that was updated. During the execution of an update trigger you can get your hands on the new data using the Inserted temporary table so the data is there but there is no way of knowing ... [ read more ]

Enabling CLR Integration in SQL Server 2005

by Maurice via Maurice de Beijer on 2/19/2007 8:49:39 AM

SQL Server CLR integration is pretty cool allowing me to write .NET code and have it execute in SQL Server, for example as a stored procedure. Not that I would want to write every stored procedure using .NET code but for some of them it sure is a lot easier. To enable it you need to reconfigure SQL Server a bit though. You need to enable CLR integration using the sp_configure sproc. Just don’t forget to execute a Reconfigure when done. Just use: sp_configure 'clr enabled', 1 go ... [ read more ]

© 2005 Serge Baranovsky. All rights reserved.
All feed content is property of original publisher. Designated trademarks and brands are the property of their respective owners.

This site is maintained by SubMain(), a division of vbCity.com, LLC