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.
1085in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
1045how 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
1198
What is partition in sql server?
How to optimize stored procedure optimization?
How to create a trigger for insert only?
How do you create a clustered index?
What is resultset concur_updatable?
How to update values in a table with update statements in ms sql server?
How can you know if the row fetched from cursor is still valid in underlying table?
What is not null constraint?
What are diverse clauses that form a part of sql?
Where can you add custom error messages to sql server?
How many types of keys are there?
What is the difference between char, varchar and nvarchar?
How many triggers are possible per table?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What are the steps to follow to configure SQL*Net?