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?
No Answer is Posted For this Question
Be the First to Post Answer
What is normalization according to you and explain its different levels?
What is a data source file?
What are tasks?
How to create a testing table with test data in ms sql server?
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
What is transact-sql language?
What are sparse columns?
Do you know what is sql service broker?
What factors you will consider calculating the storage requirement for that view?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
List few advantages of stored procedure.
How can you list all the columns in a database?
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)