Latest posts on "SQL"

Access denied sql server attach database

6 October 2021

When I tried to attach the SQL database to the local server I got this following error "access is denied".

How to attach database in sql server using cmd?

6 October 2021

In SQL Server we can use the SQL command to attach database to Microsoft Sql Server. Just copy the mdf file path and run with the following command.

Export SQL query results to Excel?

7 October 2017

In this video tutorial I will show how to export SQL Query results to excel using Microsoft SQL Server. After executing the SQL Query, in the results pane, click the top-left cell to highlight all the records, and then right-click the top-left cell and click "Save Results As" and give any name for it.

Custom Paging SQL Server example

28 November 2016

In this article, I will show you how to implement custom paging in SQL servre 2008. I used ROW_NUMBER() in where clause to achieve ms sql paging.

How to use like Operator in Sql Stored procedure?

6 October 2016

In this article I will show you how to create Sql Server Stored procedure like, parameter implemented for it. Here I used nullable parameter (IsNull) and search the product using Like keyword.

Page 1 of 3