Do you know what is difference between stored procedure and user defined function?
No Answer is Posted For this Question
Be the First to Post Answer
Do you know what is normalization of database? What are its benefits?
What is the downside of using udf?
What is a trace frag?
What is the default Port No on which SQL Server listens?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Can an entity have two primary keys?
Delete duplicate rows without using rowid.
What happens if null values are involved in string operations?
Define union, union all, minus, intersect?
What are the differences between char and varchar in ms sql server?
What are the main control-of-flow T-SQL constructs?
What is better - 2nd Normal form or 3rd normal form? Why?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)