convert oracle to ms server 2005 [message #422651] |
Fri, 18 September 2009 02:16  |
karthikeyanc2003
Messages: 33 Registered: August 2009 Location: india
|
Member |
|
|
hi folks,
i have a follwing sp which i create in oracle but my client ask me to develop the same for ms sql server, since i have no idea about the sql server i need you peoples guidence to fullfill my client needs
the code is as follows...
CREATE OR REPLACE PROCEDURE validation
AS
TYPE t_t1 is table of NUMBER(2);
t_a t_t1;
i NUMBER ;
BEGIN
select Count(table1.user_name) BULK COLLECT INTO t_a
from table1 ,table2
where table1.user_name = table2.user_name;
IF t_a(1)>0 THEN
dbms_output.put_line('EXECUTION FAILS');
ELSE
dbms_output.put_line('SUCCESSFUL EXECUTION');
END IF;
END ;
thanks in advance
Karthikeyanc2003
|
|
|
Re: convert oracle to ms server 2005 [message #422656 is a reply to message #422651] |
Fri, 18 September 2009 02:43   |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Maybe you should post this in a MS/SQL Server forum there is a better you find someone knowing its programming language there than in an Oracle forum.
Michel Cadot wrote on Mon, 10 August 2009 08:07In addition, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.
Regards
Michel
Regards
Michel
[Updated on: Fri, 18 September 2009 02:45] Report message to a moderator
|
|
|
|