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
How to change the password of a login name in ms sql server?
Define synonym?
What is sqlcmd?
explain extended properties
Do comments need to go in a special place in sql server 2005?
Why use “nolock” in sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How to copy data from one table to another table?
How can sql server instances be hidden? : sql server security
How do I determine how many instances of sql server are installed on a computer?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Difference between connected and disconnected database in .net with sql server?
What is nested transaction?
What are scalar functions in sql?
explain how to create a new schema in a database? : Sql server database administration