>>>What is the equivalent in SQL-server SQL pass-through of NODATA ? I.e how can I force an empty cursor -- efficiently? (This must be a dumb question!)
>>
>>Good question.... I didn't know, so I figured I would use profiler and see what the use nodata would send to the back end, and this is what it sent...
>>
>>SET FMTONLY ON SELECT Ee_master.ee_id, Ee_master.company_id, Ee_master.empnum, Ee_master.ssno, Ee_master.fname, Ee_master.mname, Ee_master.lname, Ee_master.forlname, Ee_master.address1, Ee_master.address2, Ee_master.city, Ee_master.state, Ee_master.zip, Ee_master.phone, Ee_master.wk_phone, Ee_master.wk_phn_ext, Ee_master.birthdate, Ee_master.sex, Ee_master.ethnic, Ee_master.marital, Ee_master.veteran, Ee_master.disabled, Ee_master.empstatus, Ee_master.emptype, Ee_master.hiredate, Ee_master.svcdate, Ee_master.leavedate, Ee_master.returndate, Ee_master.termdate, Ee_master.termcode, Ee_master.rehire, Ee_master.payfreq, Ee_master.paystatus, Ee_master.chkstatus, Ee_master.unioncode, Ee_master.barg_unit, Ee_master.workstate, Ee_master.i9document, Ee_master.bencredits, Ee_master.benprgcode, Ee_master.usercode, Ee_master.pen_plan, Ee_master.w2eetype, Ee_master.timestamp_column FROM ee_master Ee_master ORDER BY Ee_master.empnum SET FMTONLY OFF
>>
>>
>>************
>>So, it looks like SET FMTONLY ON before and SET FMTONLY OFF after your select will do the trick.
>>
>>BOb
>====================
>Thanks, Bob, and everyone else who answered. Your good response leads me to two new questions:
>
>1. How do I delimit commands send through SPT at once?
>2. How do I turn on Profiler? It looks like a great tool.
>
>Tom
Tom,
As you see above, there is no delimiter. I believe SQL can parse this out.
SQL Profiler should be in your SQL Server 7.0 start up folder. It is one of the client side tools that is installed along with Query Analyzer and Enterprise Manager.
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement