Software / Technology Tips

We can take SQL Server database backup in various processes. This is one method which will take database backup daily with time basis automatically. To achieve above the functionality we have to follow some steps. #1. Create a procedure in database with below code for taking database backup. CREATE PROCEDURE usp_BackupDatabase @databaseName VARCHAR(100) AS BEGIN…

Step 1: Create a table        CREATE TABLE .( IDENTITY(1,1) NOT NULL, (25) COLLATE Latin1_General_CI_AS NOT NULL, (47) COLLATE Latin1_General_CI_AS NOT NULL, (50) COLLATE Latin1_General_CI_AS NULL,         CONSTRAINT PRIMARY KEY CLUSTERED         (   ASC         )WITH (IGNORE_DUP_KEY = OFF) ON      …

The PurchaseOrderManager is a sealed class and used to retrieve and store the PurchaseOrder object in Commerce Server. This class has a method named SearchPurchaseOrders() which takes two parameters to search the Purchase Orders existing in Commerce Server and returns it as a DataSet. Parameters taken by this method: 1. SearchClause:– Specifies the conditions that…

To place the Products in CatalogManager we need a BaseCatalog. Once we have a catalog schema defined for e-commerce site then we can add actual data in form of BaseCatalogs, VirtualCatalogs, Categories, Products etc. To Create a BaseCatalog we need to provide the values to some of the parameters by calling the CreateBaseCatalog() method using…

While using the gridView and listView it is an easier pratice to use the data pager control for pagging purpose. But while you are working with datalist control then you will face the real problem, because the datalist does not support the data pager. In order to impliment the paging functionalty in data list here…

Fusion Chart :- The link is One has to register there. No charges applied. Just give the name and email id and it will redirect to the download page. This contains demos with source code and a very useful manual. Here one just have to include 2 class files present in (FusionChartsFree/Fusion_Charts/Code/PHP/Includes ) i.e. FC_Colors.php( For…

Sorting arrays is easy using PHP, thanks to the sort(), ksort(), and related functions. You can sort a one-dimensional array by key, by value, in reverse order, etc. But these functions will not work on multidimensional arrays (not as you’d probably like, at least). So, many a times beginners end-up creating their own logic to…

USE GO INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu11, Value21, value31) INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu12, Value22, value32) INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu13, Value23, value33) INSERT INTO Table_Name (Column1, Column2, Column3) VALUES (Valu14, Value24, value34) But we can do the above stuff in the following way.

Problem: We have three table ‘questions’, ‘answers’ and ‘questions’. ‘Questions’ table is not used, have placed it as an reference. About relationships, Attendee table has one-many relationship with answers table, which contains the foreign key fk_attid to attendee table resp. The tables have the datas as mentioned below. Questions Table qid | question                             | system_name…

In php unzipping a zip file is always different for  separate OS. Though most php sites are running on Linux there are a few on Windows too. Here I have written a class to programmatically unzip a zip according to the OS Linux/Windows . My  class is OS independent, it automatically detects the server’s OS and processes the unzipping…