A subroutine available to applications accessing a relational database system.
I want to return virtual table from stored procedure and I want to use it in dataset in c# .net. …
c# asp.net stored-procedures datasetIm calling a SQL stored procedure from a piece of C#.net code: SqlHelper.ExecuteDataset(sqlConnection, CommandType.StoredProcedure, STORED_PROC_…
c# sql sql-server stored-proceduresIs there a graceful way to handle passing a list of ids as a parameter to a stored procedure? For …
sql-server tsql stored-proceduresI need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for …
sql oracle stored-procedures full-text-search toadI have created a procedure with this structure but it doesn't work for datetime input parameter I executed this query …
sql-server-2008 datetime stored-procedures input-parametersI have a handful of raw SQL queries for SQL Server which use SCOPE_IDENTITY to retrieve the generated ID …
sql oracle stored-procedures identity-column scope-identityI'm working on converting a stored procedure from SQL server to Oracle. This stored procedure provides a direct resultset. I …
oracle stored-procedures plsqlI am very impressed with the results of Dapper Micro ORM for stackoverflow.com. I am considering it for my …
.net stored-procedures orm dapperI know this has been asked to death, and I know why SQL Server doesn't let you do it. But …
sql sql-server sql-server-2005 stored-procedures user-defined-functionsHow to pass the parameters to the EXEC sp_executesql statement correctly? This is what I have now, but i'm …
sql-server tsql stored-procedures sp-executesql