To encrypt and decrypt a string we have a predefined functions in Sql Server 2008 that are easy to use. Suppose we want to save some data that doesn't need to be exposed as a plain text then in such ...

With the latest release of SQL Server, Microsoft produced 14 new T-SQL functions. These functions can be separated into four different categories, as seen in Table 1. These functions will be ...

functions, rules, etc. in just a few simple clicks. Moreover, the software supports all SQL Server Version such as 2019, 2017, 2016, 2014, and below. Follow the steps to recover deleted views in SQL ...

An installable assembly for SQL Server that adds Deflate (the algorithm ... During development it's fairly normal to want to view problem data. Having a decompression function on the dastabase makes ...

In SQL Server, a function that returns a single value is ... the contents of the scalar function are pasted into every query, view, and stored procedure that need it. It wouldn’t even be unusual ...

Exports the contents of a table, view, or query of a SQL Server database to an RFC 4180-compliant CSV file. This function supports the export of huge result sets by writing the contents of the CSV ...