Answer Posted / shanmukha srinivas

procedure can run in sql block like
begin
sp_procedure_name(input parameters);
end;
function can run in sql block like
select sf_function_name(input paramters)

how to do backup entire database? : Transact sql

1143

---

What is partition by in sql?

1068

---

What are inner outer left and right joins in sql?

1015

---

How many types of normalization are there?

959

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

967

---

what are all the common sql function? : Sql dba

1057

---

What is the usage of sql functions?

1146

---

Why partition by is used in sql?

1038

---

What are the benefits of triggers?

1172

---

What is the difference between microsoft access and sql?

1023

---

Why do we need sharding?

988

---

what does the t-sql command ident_current does? : Transact sql

977

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1021

---

how to convert character strings to dates? : Sql dba

1058

---

What is sql stand for?

983

---