SQL Server

This category contains 2 posts

Creating and managing User Defined Functions in SQL Server 2008:

download PDF version here What are UDF: SQL server provides list of many predefined functions that are built in to the T-SQL language. The supplied functions helps extend the capabilities of T-SQL, providing the ability to perform string manipulation, mathematical calculations data type conversion etc. but often we need something which is not provided using … Continue reading

Rate this:

Create your first CLR Trigger in SQL Server 2008 using C#

What are CLR Triggers?  a) CLR triggers are trigger based on CLR. b) CLR integration is new in SQL Server 2008. It allows for the database objects (such as trigger) to be coded in .NET. c)  Object that have heavy computation or require reference to object outside SQL are coded in the CLR. d) We … Continue reading

Rate this:

What are temporary tables in Sql Server

Download/Read PDF version of article here   What are temporary tables in Sql Server? Introduction: Temporary tables are a useful tool in SQL Server provided to allow for short term use of data .SQL Server provides the concept of temporary table which helps the developer in a great way. These tables can be created at runtime and … Continue reading

Rate this:

What are magic table in Sql server?

Download/Read full PDF version of article here 1) Magic tables are nothing but inserted and deleted which are temporary object created by server internally to hold the recently inserted values in the case of insert and to hold recently deleted values in the case of delete, to hold before updating values or after updating values … Continue reading

Rate this:


Follow Vishalnayan on WordPress.com

Blog Stats

  • 217,794 hits