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

how to create a new view in mysql? : Sql dba

987

---

What are different types of keys?

1174

---

How to raise user-defined exception with custom sqlerrm ?

1178

---

Can I join the same table twice?

1095

---

What does a pl/sql package consist of?

1015

---

What are character functions in sql?

994

---

What is left join example?

1008

---

how is myisam table stored? : Sql dba

1097

---

Does pl sql work in mysql?

1035

---

Is sql between inclusive?

1199

---

What do you mean by query optimization?

1050

---

What is cursor in pl sql with examples?

1091

---

Which one is better subquery or joins?

1115

---

What is the purpose of cursors in pl/sql?

1201

---

What is write ahead logging in sql server?

1101

---