Pl sql use step by step with examples [Resolved]

Posted by Rajesh081725 under Sql Server on 11/8/2012 | Points: 10 | Views : 2029 | Status : [Member] | Replies : 6
Can any one know

How to use the procedure step by step
because i open sql server 2005 but where its how to create proceudre where i typed i confused

give some examples

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.



Responses

Posted by: Pramodthakur on: 11/8/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
First of all you have to login on SSMS(sql server management studio) and then select the database where you want to create store procedure..
After that write a code like i have to make a procedure to select all record from table abc where name like 'xyz'.
create proc Abc_Select
(
@Name nvarchar(800)
)
as
begin
select * from abc where Name=@Name
end

after that select the code and press F5

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saratvaddilli on: 11/8/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Please dowload and install sql server
while installing it give the sql server name and the login credentials.
After successfully installing the sql server just click on the icon and then go for the Windows/SQl Server authentication
No Need to provide the login credentials for windows authentication and we should provide login credentials for SQl Server authentication you can enjoy with Sql server

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh081725 on: 11/8/2012 [Member] Bronze | Points: 25

Up
0
Down
hi saratvaddilli,

i am asking how to open a PL SQL procedure given some examples but u reply intal option .

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saratvaddilli on: 11/8/2012 [Member] [MVP] Bronze | Points: 25

Up
0
Down
ho you had asked that question only know but know i think you want to know how to use stored procedure right ?

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh081725 on: 11/8/2012 [Member] Bronze | Points: 25

Up
0
Down
hai pramodthakur,

do u know

pl sql that code using vb.net or asp.net
how to use given the code for this same procedure

Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh081725 on: 11/8/2012 [Member] Bronze | Points: 25

Up
0
Down
hi saratvaddilli,
ya that correct

but i asked one more question above the reply message
if know the answer then give code to me.


Time is Gold
Thanks & Regards,
Rajesh Kumar,
9962038582.

Rajesh081725, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response