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.
1586in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
1505how 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
1669
Explain filestream storage of sql server 2008?
What are the types of indexing?
Explain external key management in sql server 2008
How sql server executes a statement with nested subqueries?
Is it possible in sql table to have more than one foreign key?
How do I view views in sql server?
Explain a differential backup?
How to enter unicode character string literals in ms sql server?
What do you understand by mirroring?
What is change tracking in sql server?
What happens if you delete a table that is used by a view?
Which sql server table is used to hold the stored procedure script?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to find related tables in sql server?
How do I setup a local sql server database?