SQL Vulnerability Assessment
SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment
Home » SQL Database »
SQL Database
SQL Server Tutorials By Pradeep Raturi- This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .You will find out a step-by-step
SQL ROLLBACK Transactions
SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If a savepoint is specified, it rolls back… Read More »SQL ROLLBACK Transactions
Separate numbers, letters and special characters from string
How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string
Column Level Encryption Decryption using Symmetric Keys
SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt… Read More »Column Level Encryption Decryption using Symmetric Keys
SQL Correlated Subquery
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery
SQL Server @@Servicename
SQL @@servicename is SQL Server configuration function which returns the name of the registry key under which SQL Server is running. This function does not… Read More »SQL Server @@Servicename
SQL NOT NULL Constraint
SQL NOT NULL Constraint is used to prevent inserting NULL values into the specified column. When value for any specific column is not provided while… Read More »SQL NOT NULL Constraint
SQL Server sp_executesql
The sp_executesql is a SQL Server built-in sytem stored procedure that enables to execute of the dynamically constructed SQL statements or batches. The following are advantages… Read More »SQL Server sp_executesql
SQL Server Change Data Capture
SQL Server Change Data Capture also know as CDC, was introduced in SQL Server 2008 version. It is used to capture the changes made to… Read More »SQL Server Change Data Capture
SQL change column collation to case sensitive
How to change the Collation of table column to Case insensitive or Case sensitive? Lets prepare a sample table called DumpData, and insert few records… Read More »SQL change column collation to case sensitive
SQL Between Operator
SQL Between Operator is a logical operator that selects the records whose values are in between the given values. SYNTAX SELECT * FROM table_name WHEREÂ … Read More »SQL Between Operator
SQL SET ROWCOUNT
The SQL ROWCOUNT is a SQL Server SET statement which causes SQL Server to stop processing the query after the specified number of rows are returned
SQL SET NOCOUNT ON
SQL Server SET NOCOUNT ON/OFF statement that controls the behaviour in SQL Server to shown the number of affected rows in the T-SQL query.
SQL Attach Database
Detaching and attaching a SQL database, is helpful in case in case when you want to move to move a database to a different SQL Server instance. So Bascially, first we detach database from SQL Server and move those files to another SQL Server and then attach files.
SQL Server Cursor
A SQL cursor is a database object that is used to retrieve data from a result set one row at a time. A SQL cursor is used when the data needs to be updated row by row.
SQL Server FLOOR Function
SQL Server FLOOR Function is a mathematical function that returns the largest integer value that is less than or equal to a number.
SQL Server CEILING Function
SQL Server CEILING Function is a mathematical function that returns the smallest integer value that is greater than or equal to a number.