Answer Posted / pradeep aryan

hi this is Sql server Statement:

Create table findSalary(salay int)

-- create procedure
Create proc stp_testdata
as
begin
select * from findsalary
end
-- Create function
create function Function4()
returns varchar
as
begin
return 'test data'
end
-- insert command
insert into findsalary values (89)


this is working fine

Can we use pl sql in mysql?

513

---

What are the types of triggers in sql?

494

---

What is normalization sql?

509

---

explain advantages of innodb over myisam. : Sql dba

640

---

What are the two types of periodical indexes?

503

---

---

Can we create clustered index without primary key?

519

---

what is sp_pkeys? : Transact sql

699

---

What are the different types of a subquery?

515

---

what is a unique key ? : Sql dba

539

---

What is trigger in pl sql?

555

---

Which is better join or inner query?

514

---

What is cursor in pl sql with examples?

477

---

What is a heap in sql?

525

---

What are triggers and its uses?

593

---

What are character functions?

627

---