SQL: What is it? A computer language called Structured Query Language is used to communicate with relational databases. SQL is a computer database management and organization technique for historical data retrieval. IBM initially referred to it as Structured English Query Language, or SEQUEL for short. SQL is used to send requests for data that need…
Tag: SQL Server Hosting
SQL Server Hosting Tutorial : Encryption of Stored Procedures in SQL Server
The stored procedure can be encrypted. When you have complex business logics and want to hide the logic implementation then the schema of the stored procedure can be encrypted. The sql server do not have any mechanism to decrypt the encrypted stored procedure. They have store manually. CREATE PROCEDURE Proc_RetrieveProducts WITH ENCRYPTION AS BEGIN SET…
Export Blob(BINARY or VARBINARY) From SQL Table And Save It As A File
A binary value or type in SQL Server is a series of bytes (known as a byte array in some programming languages). Just like char/varchar, there are fixed-length types, binary(1-8000), and variable-length ones, varbinary(1-8000) and varbinary(max). Sometimes we store this type of data in SQL Tables and lose the source files. This type of data is stored in a binary…
Introduction to Triggers in SQL Server
Tiggers are commonly used to automate data updates in SQL Server. This article describes the fundamentals of triggers in SQL, the different categories of triggers, and how to implement triggers in SQL Server. What is the SQL Server Trigger? A SQL trigger is a database object that executes when a database event occurs. When a…
HostForLIFEASP.NET vs DailyRazor- Who is The Best for SQL Server Hosting?
HostForLIFEASP.NET vs DailyRazor – Who is The Best for SQL Server Hosting? | Both HostForLIFEASP.NET and DailyRazor are award-winning hosting providers of ASP.NET in the market, but which one is better? In fact, both of the 2 companies are experienced in offering quality ASP.NET hosting solution for no less than 5 years, and have been trusted…