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

Differentiate between sga and pga.

663

---

What is crud stand for?

561

---

Differentiate pl/sql and sql?

557

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

702

---

What is oracle pl sql developer?

528

---

---

Is ms sql traffic encrypted?

496

---

How do I save a sql query?

540

---

How do I count records in sql?

508

---

Is ms sql is free?

526

---

Is left join same as join?

514

---

How do I install microsoft sql?

521

---

what is the difference between $message and $$message? : Sql dba

542

---

What is the use of index in hive?

544

---

What is sql basics?

571

---

what is a constraint? : Sql dba

703

---