Latest article tagged on "Database"

Restart Computer Failed Error in SQL Server 2008...

 19423 View(s)

DELETE, TRUNCATE with RESEED Identity in SQL Server...

 14682 View(s)

How to Drop Primary Key Constraint...

 4589 View(s)

SQL SERVER – Maximum Number of Index per Table...

 9803 View(s)

Date and Time Function in SQL...

 5199 View(s)

Select Command in SQL Server...

 4219 View(s)

Nested Queries in SQL Server...

 4083 View(s)

Change Data Capture (CDC) in SQL Server...

 6007 View(s)

How to Backup a Table in SQL Server...

 4508 View(s)

How to Backup a SQL Server Database...

 3813 View(s)

Upgrade SQL Server 2005 SP3 to SP4...

 7168 View(s)

Beginning of SQL Server Security – Guest Post...

 9038 View(s)

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....

 3763 View(s)

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....

 5971 View(s)

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...

 15439 View(s)

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....

 3029 View(s)

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....

 3910 View(s)

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

 3281 View(s)

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....

 13980 View(s)