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 can you fetch common records from two tables?

1063

---

how to drop an existing view in mysql? : Sql dba

1063

---

How do I view a view in sql?

956

---

What is bulk collect in pl sql?

1096

---

How do you declare a constant?

965

---

What does seeding a database mean?

973

---

How can I change database name in sql?

1088

---

What is difference between sql and mysql?

1137

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1218

---

What is data modelling in sql?

1025

---

Which is better trigger or stored procedure?

956

---

how can you see all indexes defined for a table? : Sql dba

1003

---

How do you optimize a stored procedure query?

1004

---

What are variables in pl sql?

1172

---

How do I filter in sql profiler?

1002

---