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

Why are indexes and views important to an organization?

678

---

Can I call a procedure inside a function?

734

---

Explain exception handling in pl/sql?

724

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1890

---

What are the disadvantages of file system?

819

---

---

What is the difference between partition and index?

656

---

Does sql support programming?

765

---

Write a query to find the names of users that begin with "um" in sql?

701

---

how to load data files into tables with 'mysqlimport'? : Sql dba

739

---

How do you modify a column in sql?

727

---

Does execute immediate commit?

925

---

What is the difference between sql and t sql?

714

---

What are all different types of collation sensitivity?

735

---

How do I view a table in sql?

716

---

Are subqueries better than joins?

715

---