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.
1530in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
1453how 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
1625
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What do you mean by acid?
How to provide login information for a new odbc dsn?
List the different types of collation sensitivities in sql server?
What is reportserver and reportservertempdb ?
Explain the properties of subqueries in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is the default server name for sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Can group functions be used in the order by clause in ms sql server?
How to delete duplicate rows from table except one?
What is a primary index?
How to get nth highest salary from employee table.
How do you send email on SQL Server?
Why I am getting this error when renaming a database in ms sql server?