LATEST ARTICLE ON CATEGORY "DATABASE"

Restart Computer Failed Error in SQL Server 2008

Restart Computer Failed Error in SQL Server 2008

DELETE, TRUNCATE with RESEED Identity in SQL Server

DELETE, TRUNCATE with RESEED Identity in SQL Server

How to Drop Primary Key Constraint

How to Drop Primary Key Constraint

SQL SERVER – Maximum Number of Index per Table

SQL SERVER – Maximum Number of Index per Table

Date and Time Function in SQL

Date and Time Function in SQL

Select Command in SQL Server

Select Command in SQL Server

Nested Queries in SQL Server

Nested Queries in SQL Server

Change Data Capture (CDC) in SQL Server

Change Data Capture (CDC) in SQL Server

How to Backup a Table in SQL Server

How to Backup a Table in SQL Server

How to Backup a SQL Server Database

How to Backup a SQL Server Database

Upgrade SQL Server 2005 SP3 to SP4

Upgrade SQL Server 2005 SP3 to SP4

Beginning of SQL Server Security – Guest Post

Beginning of SQL Server Security – Guest Post

SIGN function in SQL SERVER

SIGN is an in-build function of Transact-SQL. This is a mathematical function that returns the positive ( 1), zero (0), or negative (-1) sign of the specified expression.

Discard results after execution SSMS

This is a SSMS (SQL Server Management Studio) option that use for discard results after execution. When enabled this option will discard results after the execution.

Subquery with MAX function SQL

An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference in SQL Server

View in SQL Server

A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query stored as an object. Hence, a view is an object that derives its data from one or more tables.

Trigger in SQL Server

A Trigger is a special kind of stored procedure that is invoked whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT, UPDATE OR DELETE or Data Definition Language (DDL) statements.

JOIN in SQL Server

By using joins, you can retrieve data from two or more tables based on logical relationships between the tables.

Add or Remove Identity Property on Column in SQL Server

Identity is a property of table that automatically increment integer value of a column. For example a table has column name ‘id’ and this column generated id automatically id value, this done by identity property.

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!