Why do I get Access Denied Error in TOAD for MySQL Database Connection

Asked by Riya on 7/17/2009 4:26:23 PM

I just installed TOAD for using MySQL Database server but kind of getting access denied error while trying to connect a remote shared server. Please help me as i tried with the IP and domain name, both failed. I checked the db name, user id, password and all are correct.

Comment (0)

How Can I Schedule One Event in MySQL Database

Asked by Riya on 7/17/2009 11:21:49 AM

I am new to this database. I want to use to schedule a job to hit a web based processor to do my processing. I have no clue about this database as i totally work in MS SQL Server. I hope someone from this site can help me figuring the solution to this problem.

Comment (0)

Writing a foreign key constraint query

Asked by Riya on 3/2/2009 4:54:14 PM

I have 2 tables and I don’t want the user to delete from table 1 when the related records are already there in table 2. Is there a query that you can help me to write that will make sure for available records from table 2 before deleting a record from table 1? Thank you..

Comment (0)

Can I Concatenate String from a Column and Get Back One Row

Asked by Matt on 11/12/2008 5:02:58 PM

I don’t want to do it at presentation layer, i want to concatenate strings and pull in one row, can I do this using a sql command? If you know a way to combine all the values and get back a record then please let me know here.

Comment (0)

How Can I use a Count Query to get the Sum of Columns

Asked by Riya on 11/4/2008 2:48:54 PM

I am writing a program where i need to know the number of columns in the table upfront so how can I use a count query to find the sum of all the columns in a table and read the expression? Please help me with an answer. Can I user count(column) as column_count here?

Comment (0)

Ways to Know the Version of MDAC I am Running

Asked by Rima on 11/4/2008 1:04:34 PM

How would i know which version of MDAC I am running now? I was wondering and looking for ways to find this, I am just guessing if I go to run and regedit then I might find this and know the version. Am I correct or there is a simpler way to know this?

Comment (0)

What is Cross Join in SQL

Asked by Riya on 10/31/2008 3:19:40 PM

Is there anyone who knows about cross join in sql? I just came across this join and have list knowledge about it. Where it is used and how it is better than other joins? If I can get some help on it then it will be of a great help.

Comment (0)

What is the Difference between Inner Join and Join

Asked by Rima on 10/31/2008 3:16:32 PM

I was wondering about these joins, what is the difference between join and inner join? Is there any difference to notice or just 2 naming conventions followed. If you have a guide to know the difference of joins from then please pass it here.

Comment (0)

when to use cast and when to use convert operator in SQL

Asked by Rinku on 10/25/2008 1:16:01 AM

I always get confused with this. Can anyone explain with an example when to use a cast operator and when to use Convert operator for writing SQL Querries. What is the difference between cast and convert operators when they are both used to change one data type to another data type. Also please explain which one is better for faster query processing.

Comment (0)

What is the use of nolock condition in SQL Query

Asked by Rinku on 10/17/2008 7:29:10 PM

I am instructed by my DBA to use : with (nolock) indicator whenever i create joins on many tables. I dont really understand the need for the nolock criteria. The results of the query and the execution time is the same with or without the - with (nolock) indicator. So why use it. Can someone explain

Comment (1)