Latest Questions for SQL
retrieve the records from one table to another table by using cursors
Hi I'm fresher to backend(mysql),my requirement is retrieve the records from one table to another table by using cursors.The following is my procedure and tables.After execution it insert one extra record to another table. empproc procedure:
May 14, 2013 at 10:15 AM
Hi I'm fresher to backend(mysql),my requirement is retrieve the records from one table to another table by using cursors.The following is my procedure and tables.After execution it insert one extra record to another table. empproc procedure:
May 14, 2013 at 10:15 AM
Sql Querie
I have two tables Emplyee EmpID EmpName Age 1 Jhon 28 2 smith 38 3 jill 46 Ages AgeID AgeName
May 6, 2013 at 5:17 PM
I have two tables Emplyee EmpID EmpName Age 1 Jhon 28 2 smith 38 3 jill 46 Ages AgeID AgeName
May 6, 2013 at 5:17 PM
Combine Two Tables(Purchase and Sales) and getting Current Stock
How can i combine both the Tables and Getting Current Stock..
May 4, 2013 at 11:04 AM
How can i combine both the Tables and Getting Current Stock..
May 4, 2013 at 11:04 AM
How Insert DateTime Vales into Mysql Databse from the front end application.But User Gives Date only from Datepicker,not Time
I am new developer in .net,I Have requirement..like this ,when user pick date from date picker not time only date he/she pick up,then click insert that time ,i want insert that date and time is into Column exist with name "EnterdDate" data type is
April 29, 2013 at 10:16 AM
I am new developer in .net,I Have requirement..like this ,when user pick date from date picker not time only date he/she pick up,then click insert that time ,i want insert that date and time is into Column exist with name "EnterdDate" data type is
April 29, 2013 at 10:16 AM
How Insert DateTime Vales into Mysql Databse from the front end application.But User Gives Date only from Datepicker,not Time
I am new developer in .net,I Have requirement..like this ,when user pick date from date picker not time only date he/she pick up,then click insert that time ,i want insert that date and time is into Column exist with name "EnterdDate" data type is
April 29, 2013 at 10:16 AM
I am new developer in .net,I Have requirement..like this ,when user pick date from date picker not time only date he/she pick up,then click insert that time ,i want insert that date and time is into Column exist with name "EnterdDate" data type is
April 29, 2013 at 10:16 AM
CONVERT VALUE MONEY TO WORDS IN SQL?
i want to covert money or varchar value (like 7500000 ) in words like (75 lacs) then how to convert this value in this words . please give me solution for this
April 5, 2013 at 8:25 AM
i want to covert money or varchar value (like 7500000 ) in words like (75 lacs) then how to convert this value in this words . please give me solution for this
April 5, 2013 at 8:25 AM
mutiple storage of values
i have 3 fields in table i.e street number,house number,colony.Now i want to store these 3 fields into a single field of another table .Name of the field is address. and have to check whether the data stored in the 3 fields are same as the data s
March 22, 2013 at 4:04 PM
i have 3 fields in table i.e street number,house number,colony.Now i want to store these 3 fields into a single field of another table .Name of the field is address. and have to check whether the data stored in the 3 fields are same as the data s
March 22, 2013 at 4:04 PM
mutiple storage of values
i have 3 fields in table i.e street number,house number,colony.Now i want to store these 3 fields into a single field of another table .Name of the field is address. and have to check whether the data stored in the 3 fields are same as the data s
March 22, 2013 at 4:04 PM
i have 3 fields in table i.e street number,house number,colony.Now i want to store these 3 fields into a single field of another table .Name of the field is address. and have to check whether the data stored in the 3 fields are same as the data s
March 22, 2013 at 4:04 PM
Can anybody help me with this simple MySql code
select c.countryid, r.bp, r.sp, c.country, t.timee from rate as r, countryloc as c, todaysrate as t where r.countryid=t.countryid and t.countryid=c.country this is waht i gt whn i run that: countryid bp sp country time
March 17, 2013 at 9:48 PM
select c.countryid, r.bp, r.sp, c.country, t.timee from rate as r, countryloc as c, todaysrate as t where r.countryid=t.countryid and t.countryid=c.country this is waht i gt whn i run that: countryid bp sp country time
March 17, 2013 at 9:48 PM
query
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
query
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
query
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
query
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) <
February 28, 2013 at 8:47 PM
SQL
There are two applications once has transaction management and another has non-transaction management the first application has committed the data and the same has to be updated in the second application But the second application failed to update
February 11, 2013 at 4:02 PM
There are two applications once has transaction management and another has non-transaction management the first application has committed the data and the same has to be updated in the second application But the second application failed to update
February 11, 2013 at 4:02 PM
SQL
What is the purpose of the triggers? How you are going to debug the procedure?
February 11, 2013 at 3:43 PM
What is the purpose of the triggers? How you are going to debug the procedure?
February 11, 2013 at 3:43 PM
SQL
1)What is self Join and when we have to use, give me the scenario? 2)Why we have to use Indexes?
February 11, 2013 at 3:35 PM
1)What is self Join and when we have to use, give me the scenario? 2)Why we have to use Indexes?
February 11, 2013 at 3:35 PM
SQL
1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views.
February 11, 2013 at 3:10 PM
1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views.
February 11, 2013 at 3:10 PM
Tutorial Topics
Questions by Category