Answer Posted / casmir
stored procedure is a set of sql statements that are stored
in the database on a server rather than storing it in the
database.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Which joins are sql server default?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What’s the use of custom fields in report?
Does a sql server 2005 select statement require a from?
What is shared lock?
What are commit and rollback in sql?
What are the advantages of using third-party tools?
When to use null data driven subscription?
how many no of arguments can be passed in procedures and functions
Explain system functions or built-in functions? What are different types of system functions?
Give an example of why you would want to denormalize a database
What are constraints?
Can multiple columns be used in sql group by clause in ms sql server?
Can a database be shrunk with users active?