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

what is a stored procedure? : Sql dba

1187

---

Which are the different types of indexes in sql?

1094

---

What sql does db2 use?

1023

---

Difference between table function and pipelined function?

1075

---

How to take user input in pl sql?

1198

---

What is meant by user defined function?

1093

---

What is nosql db?

1009

---

What is indexing oracle sql?

1138

---

What are the different ways to optimize a sql query?

984

---

What are two statement types in sql?

1155

---

What is the need of a partition key?

1025

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1176

---

define data blocks ? : Sql dba

1040

---

What is the difference between a subquery and a join?

1162

---

What will you get by the cursor attribute sql%rowcount?

1072

---