category
home / developersection / category
Difference between Delete, Truncate, Drop
Delete command is used to delete all the rows from the table. If we use where clause then according to condition specific rows will be deleted. In del
Primary key and foreign key
Primary key is a key that uniquely identifies a record in a table. It cannot accepts a null value. We cannot have multiple primary key in a table. It
Uses of Stored Procedure in Database
It is a set of structured query language statement with given name. It is stored in the database in the compiled form.It is store in the compile form that’s why it can be shared by many program.
Union and Union all Operator in sql
Union and Union all both are use for combine the result-set of two of more select queries. Let us explain both individuallyUnion-Union Operator is us
Where Clause in SQL Statement
Where clause is very important clause for filtering data .It search the records from the table according to the condition given in the where clause.
Temporary Tables Magic Table and Injection in SQL
Tempopary tables are created at runtimes and ability to perform all the operation like the normal table. These tables have limited scope. This table is stored in tempdb.
User Define function in Sql Server
User Defined Functions play a major role in SQL. User Defined functions can be used to perform a complicated logic, can accept parameters and return data. Many a times we have to write complex logic which cannot be written using a single query.
Create database mail profile in sql server step by step.
In this article I would discuss about the Database Mail which is used to send the Email using SQL Server. Database Mail Configuration To Create a D
Create sql server agent job to run stored procedure
This Article describes how to create a Microsoft SQL Server Agent job step that executes Store procedure in SQL Server by using SQL Server Management Studio.
CURSOR in SQL Server
In this blog describe the concept of cursor in sql server and how to create cursor in sql server, types of cursor. Here, I’m trying to demonstrate the good examples of cursors.
Creating, Inserting, Updating and Deleting in SQLite
In this blog, I’m explaining how to create and use the sqlite database in our application. IntroductionSQLite is a relational database management sy