The ‘SQL Server’ Archives
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 October 23, 2012 by

SQL Server: Copy One Table to Another Using Stored Procedure

Stored Procedure to copy one table to another.

When modifying an important table in the database, user frequently backup the table by making a copy of the original table with a different name. Using a stored procedure makes this process simple and convenient to reuse.

Category Database, SQL Server

Posted October 14, 2012 by

SQL Server: How to Left Pad a Number with Zeros

mssql-logo

The replicate T-SQL function in Microsoft’s SQL Server makes it simple to add leading zeros to a number value.

Category Database, SQL Server

Posted October 7, 2012 by

SQL Server: How to Swap Values between Two Columns

sql-feature

When working with databases, moving and swapping values between columns is a common task.

Category Database, SQL Server

Posted September 20, 2012 by

SQL Server: How to Check if a File Exists in a Directory

mssql-logo

Frequently, when working with SQL, we need to know if a file exists in a local directory or not. This can be done using SQL Server’s built-in procedure known as master.dbo.xp_fileexist. This user-defined function (UDF) checks whether or not a file exists in a specified directory.

Category Database, SQL Server

Posted September 13, 2012 by

SQL Server: Use a CASE Expression in an Update Statement

mssql-logo

The CASE expression is used to compare one expression with a set of expressions in SQL. The result of the CASE expression is a Boolean value, true or false. We can use various DML statements like INSERT, SELECT, DELETE and UPDATE with a CASE statement. In this Tech-Recipes tutorial, we will see how to use […]

Category Database, SQL Server

Posted June 3, 2012 by

SQL Server: Generate Insert Statement Script

sql-feature

When running reports, for example, the same insert statements need to be created over and over again. SQL Server includes a great feature to generate these insert statements automatically.

Category Database, SQL Server