First Date and Last Date of Last Month using SQL

In this article we will see how to get the first and last date of past / last month. This is very helpful to generate the previous month reports. 1,022 total views, no views today

1,022 total views, no views today

Category: SQL

Password protected MS SQL bak file

In this article, we will learn to take the backup of MS SQL database with password protected. Password protected files are very secured since unauthorized person will not able to access it. If it is database then it is more important to secured the database backup file with password. 1,370 total views, no views today

1,370 total views, no views today

Category: SQL

sqlcmd Utility – SQL Server Express

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There […]

1,143 total views, no views today

Category: SQL

How to debug SQL Store Procedures

In this article, we will learn how to debug the SQL Store Procedures. Debugging is a methodical process of finding and reducing the number of bugs, or defects, in a computer program, thus making it behave as expected. Debugging tends to be harder when various subsystems are tightly coupled, as changes in one may cause […]

1,581 total views, no views today

Category: SQL

Select All checkbox in page via Javascript

In this article we will learn to select all check box from JavaScript on click of Parent check box like we have in GMail and Yahoo Mail account. To demonstrate this functionality i have used  Northwind database. I have created one simple aspx page and bind the Gridview with table customer.  873 total views, no views […]

873 total views, no views today

How to install Custom ROM in HTC Incredible S

To install the Custom ROM in your HTC handset, its mandatory to unlock the boot loader with the help of instruction provided by the HTC dev. Once you unlock the boot loader then you will get an option to install the ROM from SD Card. However, due to some reason i was unable to perform the […]

815 total views, no views today

How to install and configure Bluetooth devices in Windows XP Service Pack 2

To install a Bluetooth device, you only have to connect it. Microsoft Windows XP Service Pack 2 (SP2) includes drivers for many Bluetooth devices. If Windows does not recognize a Bluetooth device, you can still use it by using the generic software support that Windows includes, or you can use the driver that the device […]

9,566 total views, no views today

Trim spaces in Excel using kutools

In this tutorial we will learn to perform some string operation like trimming spaces, change the case etc. Many time we are receiving data in excel file  in which we are facing errors like extras spaces between 2 words and some time words with Leading and Trailing spaces. If records is few then you can […]

1,102 total views, no views today

Import Data from SQL in Excel without third party tool

In this tutorial, we will learn to import data from SQL directly to Excel without using any third party tools and programming techniques. To demonstrate this scenario, i have used MS Excel 2007. 1,102 total views, no views today

1,102 total views, no views today

(Solved) – HTC stuck logo – Failed to boot OS

  Hi Friend, i have HTC incredible S, few months ago i was facing lots of issues like Facebook was not working, many apps are displaying not compatible in google apps, Many times update get failed. With the help of HTC ROM Update Utility, i have successfully  restore my device to stock settings which was provided by the HTC. Then i […]

1,659 total views, no views today