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 the different between now() and current_date()? : Sql dba

1004

---

State some properties of relational databases?

1047

---

What are the 3 types of behavioral triggers?

1244

---

What is pl sql block structure?

1030

---

How do you copy a table in sql?

1057

---

What is the difference between subquery and correlated query?

1054

---

Cite the differences between execution of triggers and stored procedures?

1075

---

How many commands are in sql?

1059

---

What are the subsets of sql?

1117

---

What are the methods of filing?

927

---

Why partition by is used in sql?

1028

---

What are the two characteristics of a primary key?

965

---

Are sql database names case sensitive?

994

---

Mention what are different methods to trace the pl/sql code?

1194

---

What is the difference between mdf and ndf files?

1110

---