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 walk through of the basics and advanced topics with practical and include numerous hands-on activities.
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
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
Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read… Read More »How to Read SQL Server error logs using the xp_readerrorlog
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 @@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 Server Cross Apply and Outer Apply
SQL Server APPLY operator is like a SQL JOINS, which allows joining two table expressions, but the Difference between APPLY operator and JOINS is the ability of APPLY operator to work with table- valued expression.
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 is a mathematical function that returns the largest integer value that is less than or equal to a number.
SQL Server CEILING Function is a mathematical function that returns the smallest integer value that is greater than or equal to a number.
SQL Server Dirty Reads problems in concurrent transactions
SQL Server LAST_VALUE function is a Analytic function which returns the Last value in an ordered set of values.
SQL Server FIRST_VALUE function is a Analytic function which returns the first value in an ordered set of values.
SQL Server Primary key is used to uniquely identify each rows in the table but sometimes more than one column are used to uniquely identify each rows in the table.
Print a prime numbers separted by comma for any given number .
For example, the prime number for 10 , wolud be 2,3,5,7 .
Here is the query:
Query to Get the Students who scored higher than 80 Marks ?
SQL server allows us to transform a row- level data into columnar data using SQL Pivot.
SQL Server Clustered index
A clustered index defines the order in which data is physically stored in a table. A table can have only one clustered index because data rows can be only sorted in one order.
