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 Server Sequence

A Sequence objects are used to sequentially generate numeric values that can be in ascending or descending order at a defined interval and may cycle if requested.

SQL Server DENSE_RANK()

The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.

SQL SERVER EXCEPT

The SQL EXCEPT clause is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement.

SQL Unique Key Constraint

A unique key constraint is a set of one or more than one columns of a table that uniquely identify a record in a database table.

SQL Q & A on SELECT Statement

Q 1 > SELECT Count(1) as Output 1> NULL 2> Error 3> 1 4> Invalid select statement Answer Q 2 > SELECT Count(*) as… Read More »SQL Q & A on SELECT Statement

SQL Primary Key constraint

A PRIMARY KEY constraint uniquely identifies each record in a table .

SQL Query to get the list of files in a folder in SQL

How to get the list of all the files in a folder into SQL table ?

Truncate VS Delete statements in SQL Server

What is the Difference between SQL Truncate and SQL Delete statements in SQL Server ?

How to access a data of table from another database in SQL Server?

How to copy a data of table from another database in SQL Server?

Suppose, you have a database1 and table1 and one another database2 and table2 in SQL server.

Now you are required to select data of a table1 of database1 from database2 of table2.

What would be a query for that?

SQL LOGON Trigger

It fires in response to LOGON events of SQL Server is raised .

A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .

SQL DDL Trigger

It is a special kind of trigger which fires in response to DDL statements.

SQL DML Instead Of Trigger

Instead of Trigger (using FOR/AFTER CLAUSE)

SQL Triggers

SQL Server triggers are special kind of Stored Procedures that invokes whenever a special event in the database occurs.

SQL Server uses two virtual tables INSERTED and DELETED, whenever a trigger is called . These table is used to capture the data of the modified row before and after the event occurs tables , these tables are called as magic tables or virtual tables.