Interested to Buy Any Domain ? << Click Here >> for more details...
What is a trace frag? Where do we use it?
- 0 Answers
- 1043 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to create a dynamic cursor with the dynamic option?
What is sub-query in sql server? Explain its properties.
What is ms sql server index?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to create database with physical files specified in ms sql server?
Why should we go for stored procedures? Why not direct queries?
Explain “not null constraint” in sql server?
What is difference between clustered and non clustered index?
What is isnull() operator?
What is compression - row-level and page-level compression?
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
How to avoid cursors?
3 Answers CarrizalSoft Technologies, HP,
-
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)
