A subroutine available to applications accessing a relational database system.
I need to check when function was changed last time. I know how to check creation date (it is in …
sql-server-2008 stored-procedures sql-server-2008-r2 sql-functionHow to pass an array into a SQL Server stored procedure? For example, I have a list of employees. I …
c# sql-server tsql stored-proceduresI know it's possible, but I don't know how. I need to search an SQL Server database for all mentions …
sql-server function search stored-proceduresI have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have …
sql-server stored-procedures triggers linked-serverHow do you assign the result of an exec call to a variable in SQL? I have a stored proc …
sql sql-server tsql stored-proceduresIm trying to get the value from BrandID in one table and add it to another table. But I can't …
sql-server stored-procedures local-variablesI have a stored procedure that alters user data in a certain way. I pass it user_id and it …
sql sql-server stored-proceduresJust can't figure out why it gives me ORA-06512 Error PROCEDURE PX(pNum INT,pIdM INT,pCv VARCHAR2,pSup FLOAT) …
oracle stored-procedures plsql ora-06512I have a SQL Server 2005 database. In a few procedures I have table parameters that I pass to a stored …
c# sql-server stored-procedures sqlcommand table-valued-parametersUsing Sql Server 2012. I have a stored procedure and part of it checks if a username is in a table. …
sql sql-server if-statement stored-procedures sql-server-2012