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

Is it possible to include an insert statement on the same table to which the trigger is assigned?

959

---

What are different types of functions in sql?

959

---

What is trigger types of trigger?

996

---

Can we insert data into materialized view?

897

---

How do I quit sql?

899

---

what is the use of set statement in tsql? : Transact sql

945

---

What is a mutating table and a constraining table?

1038

---

When should I use nosql database?

946

---

What is synchronized subquery?

1093

---

What are the three pl sql block types?

949

---

Which normal form is best?

895

---

How to set up sql*plus output format in oracle?

977

---

Can we perform dml in function?

1016

---

How do you clear the screen in sql?

1012

---

Can we join two tables without common column?

932

---