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");
September 10, 2014 at 1:20 AM
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
MySQLselect into new table Example code
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)
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