not familiar with sql server stored procedures. i am only knowledgable in oracle and informix.
i need to know if it is possible to return a loaded resultset from a sql server stored procedure. i need to be able to do this from a single call to the stored procedure because these procedures will be called through odbc from linked query objects in microsoft access. using ADO an OLE to bind client cursor objects is not an option.
looking for an example of a simple stored proc that returns a first_name and last_name from an employee table with all employees with a last name started with var1; var1 will be passed in to the procedure at runtime. please demonstrate the call to the procedure and what the resultset should look like to the client. temp tables are not an option so please do not use that route.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.