What is Stored Procedure?
What is Views in sql server?
Difference between a User Defined Function and a Stored Procedure
Difference between a primary key and a unique key?
What is a join and explain different types of joins.
Difference between temp table and table variable
Difference between Triggers and Stored Procedures
Difference between UNION ALL Statement and UNION
What is COALESCE / Why do we use COALESCE?
Why we use SET ROWCOUNT in Sql
How many clustered index can have a table
How many types of local tables in SQL SERVER
Difference between DELETE and TRUNCATE
What is Aggregate Functions?
What is Row_Number()?
What are Ranking Functions?
What is NOLOCK?
What is CTE?
What are the Advantages of using CTE?
What is the STUFF function and how does it differ from the
REPLACE function?
What are the difference between clustered and a non-clustered index?
What are the different index configurations a table can have?
Difference between a HAVING CLAUSE and a WHERE CLAUSE?
Difference between SET and SELECT
Provide all the built in string function of SQL SERVER
Difference between char and varchar data types
Define candidate key, alternate key, composite key.
What are constraints? Explain different types of constraints.
What is a self join? Explain it with an example.
How will you convert table row to a column comma separated value
Answer Posted / aejaz ahmad
Q-Difference between a User Defined Function and a Stored
Procedure
Ans
1:
the store procedure can not be execute with the select
command while function execute
with the select command you can execute the store procedure
with the execute statment
2:
you can not apply the crud operation on the function while
this my be apply on sql
3:
UDFs that return tables can be treated as another rowset.
This can be used in JOINs with other tables.
Q-Difference between a primary key and a unique key?
Ans- Primary Key: A column in a table whose values
uniquely identify the rows in the table.
A primary key value cannot be NULL.
Unique Key: Unique Keys are used to uniquely
identify each row in an Oracle table.
There can be one and only one row for each unique
key value
Q- What is a join and explain different types of joins.
Ans A join combines records from two or more tables in
a relational database.
In the SQL there are two types of joins: "inner"
and "outer". Outer joins are subdivided further into left
outer joins,
right outer joins, and full outer joins.
Inner join
This is the default join method if nothing else is
specified. An inner join essentially finds the intersection
between the two tables.This find and matching all
records from table A and table B.
Left outer join
A left outer join is very different from an inner
join. Instead of limiting results to those in both tables,
it limits results to those in the "left" table (A).
Right outer join
A right outer join is much like a left outer join,
except that the tables are reversed.
Every record from the right side, B, will be
returned.
Full outer join
Full outer joins are the combination of left and
right outer joins.
These joins will show records from both tables, and
fill in NULLs for missing matches on either side.
Q-Difference between temp table and table variable
Ans 1: A temp tablecan have indexws,where as a table
variable can onlyhave a primary index .
2: table variable can be faster than temp table .
3: Need to search the record so, temp table is
batter.
4: Table variables are Transaction neutral. They
are variables and thus aren't bound to a transaction.
Temp tables behave same as normal tables and
are bound by transactions.
Q-Difference between Triggers and Stored Procedures
Ans 1: Triggers are automatically fired ,but Procedure
has to be explicitly fired.
2: Triggers can only be implemented on tables or
views
SP in independent code that can be specific to
database
3: Triggers will get execute automatically when an
update ,insert or delete statement is issued aganist a
table or view
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
How to use group functions in the select clause in ms sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
what happens on checkpoint? : Sql server database administration
What is nolock?
Explain the ways to controlling cursor behavior?
Explain the first normal form(1nf)?
What is table level trigger?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Explain isolation levels that sql server supports?
How to test subquery results with the exists operator?
How to drop an existing stored procedure in ms sql server?
Can sub report data source be different from that of the parent report?
What is dbcc?
how you can list all the tables in a database?
What do you understand by physical_only option in dbcc checkdb?