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.
1662in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
1565how 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
1721
Find columns used in stored procedure?
Tell me what is difference between view and materialized view?
What structure can you implement for the database to speed up table reads?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Where are full-text indexes stored?
What is a result set object returned by odbc_exec()?
how many triggers you can have on a table? : Sql server database administration
What is clustered primary key?
What is model database? : SQL Server Architecture
Can binary strings be converted into numeric or float data types?
What are transactions in sql?
Can we take the full database backup in log shipping?
How do I find the size of a sql server database?
Write an SQL query to obtain the 2nd highest salary.
What is the name of reporting services config file and what’s it’s used for?