1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
1594in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
1514how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
1682
What are the difficulties faced in cube development? : sql server analysis services, ssas
Why is sql server log file full?
What is the simplest way to create a new database in ms sql server?
What is 1nf normalization form?
What is the default schema of your login session in ms sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is the maximum size of a row in sql server?
What are the diifferences between the ms sql server vs mysql?
Explain active/passive and active/active cluster configurations?
How to define and use table alias names in ms sql server?
Tell me what is log shipping?
What is sql injection and why is it a problem? : sql server security
What is an index in sql?
What is Federation Root Database?
Do you know the capabilities of cursors?