The ‘Database’ Archives
Posted February 2, 2014 by

Inner and Left Outer Join with Where Clause vs ON Clause

database join featured article

Filtering results with the [ON] clause and the [Where] clause using LEFT OUTER JOIN and INNER JOIN is a very powerful technique.

Posted January 1, 2014 by

11 Keyboard Shortcuts Every SQL Server Geek Should Know

front_image_sql_server_keyboard_shortcuts

A smart programmer knows the ins and outs of the IDE in which he works. Keyboard shortcuts save a lot of time and can improve productivity as well. SQL server Management Studio has included over 100 keyboard shortcuts. Here, we will explore the most essential shortcuts which will make our daily programming life more easy […]

Category Database, SQL Server

Posted December 20, 2013 by

A Beginner’s Guide to the OUTPUT Clause in SQL Server

database featured admin

T-SQL supports the OUTPUT clause after the inception of SQL server 2005 and later editions. We can use the OUTPUT clause with DML statements (INSERT, DELETE, UPDATE) to return information from modified rows.

Category Database, SQL Server

Posted December 13, 2013 by

SQL Server: Browser Service Started and Then Stopped

The SQL Server Browser service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

This error message is commonly encountered: “The SQL Server Browser service on your local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.” This is how explore and fix this SQL Server issue.

Category Database, SQL Server

Posted October 19, 2013 by

SQL Server: Coding the After Delete Trigger in SQL Server

feature sql delete

A trigger is special type of stored procedure that is executed when an INSERT, DELETE or UPDATE statement modifies data in a table.

Category Database, SQL Server

Posted June 27, 2013 by

SQL Server 2012: Pagination with Order By and Offset Fetch

SQL Server Pagination with Order By and Offset Fetch in SQL Server 2012_1

Many times developers need to implement pagination on search results. Pagination is the process of dividing the results of a query into discrete numbered pages.

Category Database, SQL Server

Posted June 23, 2013 by

SQL Server: Coding the After Insert Trigger in SQL Server

After insert trigger in sql server 1

A trigger is a special type of stored procedure that is executed when an INSERT, DELETE or UPDATE statement modifies data in a table.

Category Database, SQL Server

Posted June 14, 2013 by

SQL Server 2012: Using Top with Percent in SQL Server

TOP with PERCENT SQL Server_1

The TOP clause in SQL Server is used to limit the number of rows in a result set. You can specify the number of rows or percentage of rows to be returned with the TOP clause.

Category Database, SQL Server

Posted May 29, 2013 by

SQL Server: Enable and Disable Triggers

Enable Disable Trigger SQL Server_1

If we have a trigger and want to prevent it from running, we can either delete the trigger or disable it temporarily. With the trigger disabled, it will not function. We have three ways to enable/disable a trigger in SQL Server by using a graphical option or by using a query editor.

Category Database, SQL Server

Posted March 20, 2013 by

SQL Server 2012: Find Expiry Date of SQL server

binary-feature

If you have installed SQL server 2012 Enterprise Evaluation Edition, this trial software will expire after 180 days without any pre alert notification. This SQL query will show the current version and edition of SQL Server you are using.

Category Database