When working with stored procedures, you can define _________ parameters to pass values to the procedure.
- Input
- Output
- Input and Output
- Optional
In SQL Server, stored procedures can have parameters that can be defined as either input parameters, output parameters, or both. Input parameters are used to pass values into the procedure, while output parameters are used to return values back to the caller. Optional parameters are not directly supported in stored procedures but can be simulated using default parameter values.
Loading...
Related Quiz
- The Connection String can include authentication details such as ___________ and ___________.
- One-to-One relationships in Entity Framework can be mapped using the ___________ attribute.
- What is distributed transaction management in ADO.NET, and when might it be necessary?
- Which LINQ technology is more suitable for querying in-memory data structures like lists and arrays?
- You have a complex inheritance hierarchy in your entity model. How can Entity Framework help you map these entities to the appropriate database tables?