Latest article tagged on "Database"

Restart Computer Failed Error in SQL Server 2008

DELETE, TRUNCATE with RESEED Identity in SQL Server

How to Drop Primary Key Constraint

SQL SERVER – Maximum Number of Index per Table

Date and Time Function in SQL

Select Command in SQL Server

Nested Queries in SQL Server

Change Data Capture (CDC) in SQL Server

How to Backup a Table in SQL Server

How to Backup a SQL Server Database

Upgrade SQL Server 2005 SP3 to SP4

Beginning of SQL Server Security – Guest Post

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.

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.

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

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.

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.

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

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.