Answer / rvs varma

Its not possible to call sp's in function but viceversa is
possible

Answer / swathi

no we cannot call sp in a function

Answer / mohammad ali

We cannot call Procedure from the Function

We can call the Procedure From the Procedure as
EXEC ProcedureName
@Parameter1 = "Para1"
@Parameter2 = "Para2"
@Parameter3 = @Val OUTPUT (Use when there is Output in the Procedure)

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is difference between views and stored procedures?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

What is 3nf normalization form?

0 Answers  

---

---

What is sql server profiler?

0 Answers  

---

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

What is the dbcc command and why is it used?

0 Answers  

---

What is cursors?

0 Answers   NA,

---