A subroutine available to applications accessing a relational database system.
I am not as familiar with Oracle as I would like to be. I have some 250k records, and I …
sql oracle stored-proceduresI have a stored procedure as follows. CREATE OR REPLACE PROCEDURE TEST( X IN VARCHAR2 DEFAULT 'P', Y IN NUMBER …
stored-procedures parameters plsql oracle11g defaultThe definition says: When SET ANSI_NULLS is ON, a SELECT statement that uses WHERE column_name = NULL returns zero …
sql tsql stored-proceduresI have a stored procedure that uses the LIKE operator to search for a truck location among some other parameters @…
sql-server stored-procedures parameters sql-likeI am using asp.net mvc 5 and C# with Entity Framework... I have model and domain classes for function... now …
asp.net-mvc entity-framework stored-procedures repository-patternI am pretty new to SQL and hope someone here can help me with this. I have a stored procedure …
sql sql-server stored-procedures case sql-likeHere is the definition of the stored procedure: CREATE OR REPLACE PROCEDURE usp_dropTable(schema VARCHAR, tblToDrop VARCHAR) IS BEGIN …
sql stored-procedures oracle10g privilegesI recently upgraded our SQL Server from 2005 to 2014 (linked server) and I am noticing that one of the stored procedures …
sql sql-server stored-procedures sql-server-2014 linked-serverI wrote this SQL in a stored procedure but not working, declare @tableName varchar(max) = 'TblTest' declare @col1Name varchar(…
sql-server tsql stored-procedures executequeryI took a look at the "Beginner's Guide to LINQ" post here on StackOverflow (Beginners Guide to LINQ), but had …
linq linq-to-sql stored-procedures