Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Document Type: Example Program
NI Supported: Yes
Publish Date: Sep 6, 2006

Calling an SQL Stored Procedure Using the Database Connectivity Toolset

8 ratings | 2.00 out of 5
Print

Downloads

Filename: 1539.vi
Requirements: View

This example calls stored procedures in SQL Server using the LabVIEW Database Connectivity Toolset. The VI uses two methods to call the built-in stored procedure sp_helpuser -- one method uses parameters and the other does not.


Related Links:
LabVIEW Database Connectivity Toolset

Requirements


Filename: 1539.vi

Software Requirements


Application Software: LabVIEW Full Development System 6.0.2
Toolkits and Add-Ons: LabVIEW Database Connectivity Toolset
Language(s): LabVIEW

 
8 ratings | 2.00 out of 5
Print

Reader Comments | Submit a comment »

this example would be far more helpful if a full syntax demo was added to it. i.e. show the text call of the proceedure in sql, then show the equivalent labview VI for those not familiar with this specific item. i.e. 'exec sys.sp_helpuser 'dbo' would be the parameterized query
- Sep 4, 2009

 

Legal
This example program (this "program") was developed by a National Instruments ("NI") Applications Engineer. Although technical support of this program may be made available by National Instruments, this program may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this program with each new revision of related products and drivers. THIS EXAMPLE PROGRAM IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).