Home Answers Viewqa SQL SQL Question and Answers


Latest Questions for SQL
example of before insert trigger in mysql
Hi, How to create a simple before insert trigger in MySQL? Thanks
April 25, 2016 at 1:59 PM

Failed to Call Procedure
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sum(case when c.result = '1' then 1 else 0 end ) as Pass_total, sum(case when c' at line 1
February 27, 2015 at 3:31 AM

MY Sql Query Error - Not able to Understand the issue
I am new at MYSQL,I wrote simple query as follow: CREATE Table tblFeedBack ( FeedBackID INT AUTOIncremeNT, UserID INT, InsertedTS TIMESTAMP , FeedBackValue VARCHAR(100), PRIMARY KEY (FeedBackID) ); CREATE PROCEDURE tblFeed
February 15, 2015 at 10:53 AM

which query will be run for previous(button) question
which query will be execute on previous button to view the previous questions . for example :- i m working on online examination software so when i click on the previous button i got previous question. please provide me the answer .
October 16, 2014 at 3:15 AM

How to access data yearly from DB in C# ?
how to access data yearly from database in C#. I have code but i m not able to retrieve data yearly from DB table. string date1 = dateTimePicker1.Value.Date.ToString("dd/MMM/yyyy"); OleDbConnec
September 10, 2014 at 1:20 AM

Fastest way to upload huge raw data in database - c#, Java or stored procedure
I have huge raw data that needs to uploaded in database. This procedure repeats every 15days. I need to know which method would be fastest to upload this data - Stored procedures, Java or c#. Why? What are the advantages and disadvantages of each
September 1, 2014 at 9:02 PM

DB Insert
How to insert XML data into a database column? Column data type is CLOB
August 11, 2014 at 4:18 PM

Nb hours between 2 time stamps meets specific criteria
sql - I have 2 columns with time stamps and 2 empty columns, named DAYHOURS AND NIGHTHOURS. I want to update DAYHOURS and NIGHTHOURS with Number of hours fall under - 06:00 to 21:00 and 21:00 to 06:00 respectively. Thanks
August 7, 2014 at 1:18 PM

mysql select into table from another table example
Can you suggest the correct example of select into table from another table example in MySQL Database. Thanks
July 9, 2014 at 3:28 PM

MySQLselect into new table Example code
Hi, I have a big table in MySQL database and I want to create a new table with all the data in it. I have heard that there is SQL statement "mysql select into new table" which selects the data from one table and create and insert data into
July 9, 2014 at 3:19 PM

How to create a .mdf file from script (.sql)
Hi, I have a sql database in 2008 server. now i want it to convert to 2005. so i script it. just help me to create a .mdf file back from the script.
April 22, 2014 at 10:22 AM

Please help me out
Description* You are hired to develop a laptop inventory information system for Sheridan College in order to keep track of the information about the laptops lent to the students. Users can add or remove data as well as perform searches on th
February 12, 2014 at 8:29 PM

fixing broken relational links in MySQL database after an upgrade
Need help fixing broken relational links in MySQL database after an upgrade
December 26, 2013 at 2:25 PM

How do I upgrade mysql?
How do I upgrade mysql?
December 26, 2013 at 2:24 PM

mysql 4.x to 5.x upgrade problem
mysql 4.x to 5.x upgrade problem
December 26, 2013 at 2:23 PM

Upgrading a PHP/MYSQL application?
Upgrading a PHP/MYSQL application?
December 26, 2013 at 2:22 PM

upgrading sql query join
upgrading sql query join
December 26, 2013 at 2:22 PM

phpmyadmin in whm
phpmyadmin in whm
December 26, 2013 at 2:04 PM

whm php version
whm php version
December 26, 2013 at 2:04 PM

update php cpanel
update php cpanel
December 26, 2013 at 2:03 PM

View all discussion for SQL