Introduction: In this article,i am going to explain about how to encrypt a stored procedure and how to set a stored procedure security while using exec statement. Main: Just like a view, stored procedure Transact-SQL definitions can have their contents encrypted in the database, removing the ability to read the procedure’s definition. In order to [...]

Introduction: In this article,i am going to explain about how to effectively use/utilize the sql-server build in aggregate functions in t-sql code. Main: Aggregate Functions Aggregate functions:- are used to perform a calculation on one or more values, resulting in a single value. An example of a commonly used aggregate function is SUM, which is [...]

Introduction: In this article, i am going to explain about how to effectively use reular view,indexed view and distributed partitioned view. Main: Views allow you to create a virtual representation of table data defined by a SELECT statement. The defining SELECT statement can join one or more tables and can include one or more columns. [...]

Introduction: In this article, i am going to explain about how to access/use large clob/lob objects over/using http. Main: We can easily transfer clob object in oracle database to remote server using http via port number 80. Firewall restrictions on the network containing the image file server prevent any direct access to the image server [...]

Introduction: In this article,i am going to explain about how to handle/manage errorsin oracle pl/sql block. Main: Normally in pl/sql we will get two kind of exceptions. 1.compilation errors –> compilation errors when you run an anonymous block program or attempt to build a stored program unit—a function, procedure, or user-defined object type 2.Run-Time errors [...]

Introduction: In this article,i am going to explain how to alter a database in sql server 2008. Main: we can use the ALTER DATABASE command to change a database’s defi nition in one of the following ways: * Change the name of the database. * Add one or more new data files to the database. [...]

Introduction: In this article,i am going to explain about how to use new date and time data types in sql server 2008. Main: The date, time, datetime2, and datetimeoffset types are four new data types in SQL Server 2008 for storing dates and times, which you should now begin using for new database development in [...]

Introduction: In this article,i am going to explain about how to use WAITFOR in sql server 2008. Main: In SQL Server 2000, WAITFOR waited for a specified duration or a supplied datetime value. Starting with SQL Server 2005, as with the TOP enhancements, you can use WAITFOR with a SQL expression. You can essentially use [...]

Introduction: In this article,i am going to explain about how to handle the exception in transactions using sql server 2008. Main: SQL Server offers major improvements in error handling inside T-SQL transactions. As of SQL Server 2005, you can catch T-SQL and transaction abort errors using the TRY/CATCH model without any loss of the transaction [...]

Introduction: In this article,i am going to explain about how to create the ranking functions in sql server 2008. Main: Databases hold data. Users sometimes want to perform simple calculations or algorithms on that data to rank the results in a specific order—like gold, silver, and bronze medals in the Olympics or the top 10 [...]