We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Typically speaking what a Cursor & Handle mean?

Favourites
Favourites asked
on
Medium Priority
314 Views
Last Modified: 2010-03-19
1.   I need to know what is a cursor & what for its used>
     Is it same as Handle.Then what's its purpose and list      out the advantages and disadvantages of each of them

2.  What is win16 and win32 api, where's used.Give me where its used exactly.

3. What are the Trigger Types in sql Server.

4. Often I encounter "DB CONNECTION BROKEN"
   when executing left/right and inner join simultaneously in a query. ie In other words if I give left as (*=) and right as (=*) and inner as (=) in WHERE clause I get this error.
Suppose If I give Right join as Right Join , Left as Left Join and Inner as Join I don't get this problem.

Can anyone help me out what might be the problem and what does it mean by "DB BROKEN BROKEN".?

5.  Is SQL SERVER BETTER THAN ORACLE AND IF SO IN WHAT WAY THE FORMER OR LATTER IS BETTER. BRIEF ME WITH DETAILS. DIFFERENCE BETWEEN ORACLE AND SQL SERVER

6. I want to prepare for Microsoft Certification for which I need to Know what books I should look into . Is there any sites where can I find the Questions(previously attended/sample questions, put up by the students).similar to newsgroup like this one.


7. What is meant by SQL PASS THRU QUERY. GIVE AN ILLUSTRATION.

8. WHAT IS THE DIFFERENCE BETWEEN EXECUTE METHOD AND EXECUTE SQL.
.
Comment
Watch Question

Commented:
I don't have time to get into as many details as you requested, but I can tell you an excellent book for SQL Server is:

Inside Microsoft SQL Server 6.5 by Ron Soukup  

ISBN:   1572313315
Publisher:   Microsoft Press
Pub. Date:   November 1997


Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
Great answer Martin!

Author

Commented:
This is reg. the first Question
You have'nt given me the answer for what is an handle and how's its used and in what situations.

I need to have more light on 7th and 8 th Question.
I need more information on Sql Pass thru Query using Visual Basic and not Access. Pl. give an illustration .

Reg. the Execute  and Execute SQL  I need more clarification with respect to how it is being handled from visual basic .



There are several types of handles, it depends on what you are talking about.  There are environment handles which are used with the ODBC API, there are window handles that are used in the Windows API, etc.  Basically a handle is a long integer that is a reference to a particular area of memory, this memory offset usually has a base address associated with it that the API addresses.

Say you are using DAO to connect to SQL Server and want to execute the stored procedure:
    "exec master..xp_sendmail @recipients = 'MyMailbox'"
Well, DAO does not know how to handle this, and you will get a syntax error, unless you set the dbSQLPassThrough option.  This tells DAO (the JET Engine) to ignore the syntax of the query, that the server will handle it.

Don't use ExecuteSQL, it is obsolete.  This basically means in the near future Microsoft is going to drop support for the function, period.  This becomes an issue when you try to upgrade your code, no matter what environment your in (VB, Access, etc.).  Use the Execute function instead, it has improved functionality, and should be supported for quite a while.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.