Answers were Sorted based on User's Feedback
Answer / parifs
Functions - the tasks or actions that software is intended
|Is This Answer Correct ?||2 Yes||0 No|
Answer / kotikhammam
Functions are saved T-sql routines that returns a value.
|Is This Answer Correct ?||1 Yes||0 No|
Answer / subrahmanyam
Function is collection of T-Sql statements and used as unit
|Is This Answer Correct ?||0 Yes||0 No|
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
what is statistics
What is difference between stored procedure and function?
If a stored procedure is taking a table data type, how it looks?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
what is a stored procedure and trigger?
from the table display the 2nd highest salary? and also the least 2nd salay?
select names starts with a,b,c
sql database suspect We have a sql database that is showing as suspect. How can we recover?
any one can explain Self mapping Delegation Remote Credentials
How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?