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.766
what is checksum in sql server.........???
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it674
how 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 A768
What is Lock table in SQL?662
Can we call a function that has out parameter in select statement422
Call by value and call by reference in procedure and function, with NOCOPY.504
If we delete pack Spec what will be the status of pack Body ?592
Delete duplicate rows without using rowid.617
how to find 6th highest salary583
Explain few examples of stored procedure over triggers?218
What are the different types of backups that exist?270
What can be used instead of trigger?238
What does asynchronous call backs means?247
How do you implement session management in SQL Server mode?229
Please explain what is “asynchronous” communication in sql server service broker?
How can I know what locks are running on which resource?
What is sql azure database?
What is the purpose of update statistics and scope_identity() function?
Does order by actually change the order of the data in the tables or does it just change the output?
How to maintain a fill factor in existing indexes?
What are the advantages of sql azure?
What is a primary index?
What is Cross Join and in which scenario do we use Cross Join?
What is the purpose of grouping data in a report?
What is self contained scalar sub query?
What is a matrix in ssrs?
List the various tools available for performance tuning?
How to disable stored procedure sql server?
What is the difference between ‘having’ clause and a ‘where’ clause?