Pl sql use step by step with examples [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

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

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

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

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

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