I have the following query that runs in my Oracle database and I want to have the equiv开发者_StackOverflow中文版alent for a SQL Server 2008 database:
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
We have a table which has a DATE column d. I\'d like to get all the rows where the d column is greater / lower than some value, regardless of the date.
I have an AFTER INSERT OR UPDATE OR DELETE trigger that I\'m writing to store every record revision that occurs in a c开发者_运维问答ertain table, by copying the INSERT and UPDATE :NEW values into a m
I know it seems like a basic thing, but I\'ve never done this before. I\'d like to return a single record from an existing table as the result of an Oracle PL/SQL function.I\'ve found a few different
I am having the below statement from stored procedure. It\'s giving Insufficient P开发者_开发知识库rivileges.
What is the difference between these two pieces of code? TYPE t_my_cursor IS REF CURSOR; v_my_cursor t_my_cursor;
I have two very large tables and I need to process a small resultset from these tables. However, processing is done in several functions each and function must do some joining in order to format the d
I have a type myType declared with a member procedure insert_obj. When i try this code, i get the following error:
This question already has answers here: What is the difference between "AS" and "IS" in an Oracle stored procedure?
加载中,请稍侯......