Wednesday, July 3, 2013

Stored Procedure (SP)

What is a Stored Procedure (SP)The stored procedure is a set of PL/Sql statements written inside a named block. We use stored procedures in Sql Server to perform the very basic operations on database tables.AdvantagesStored Procedures are very much useful in multidevelopment environment. As they serve the developers or applications from single point.They are precompiled and the execution of the stored procedures is very fast when compared to sql queriesThey sit inside the database and executes from it. The changes made in one place are visible...

Simple Survey Application

Introduction:         The companies which are offering variety of services to the customers, they need to get the response from the customers in many forms. By analyzing these responses companies will have an overview of their services and performance.          The surveys or polls are very much important in different situation and organizations. for examples, consider a company is selling different...

bio metric log text file import and validate in attendance management system

Bio metric log text  file Upload and export   to excel sheets  in vb.net   project in attendance system                                                               Browse Bio Metric Log fileImport bio metric log fileValidate Bio Metric log file Click...

Tuesday, July 2, 2013

Converting MS SQL Database to MySQL

                         If you want to Convert your sql server database tables, stroed procs, functions etc to Mysql ,you can use this tool . Here is the URLhttp://www.ispirer.com/products/sql-server-to-mysql-migrationYou can either use free evaluation or can purchase. You need to register before downloading the to...