Home » SQL & PL/SQL » SQL & PL/SQL » convert oracle to ms server 2005
convert oracle to ms server 2005 [message #422651] Fri, 18 September 2009 02:16 Go to next message
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 Go to previous messageGo to next message
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:07
In 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

Re: convert oracle to ms server 2005 [message #422819 is a reply to message #422651] Sat, 19 September 2009 17:28 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
Buy a book and start reading.

Good luck, Kevin
Previous Topic: date format
Next Topic: BFILENAME with filenames containing accents
Goto Forum:
  


Current Time: Tue Feb 11 09:47:34 CST 2025