Which sql server table is used to hold the stored procedure scripts?
What is raiseerror? What is raiseerror?
What is a data source or ds? : sql server analysis services, ssas
When we can say that is in BCNF?
What are the disadvantages of using the stored procedures?
How to find the second highest salary of an employee?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
How to rebuild all indexes on a single table?
Define indexes?
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.
What is the difference between Stored Procedures and triggers?
between cast and convert which function would you prefer and why?
What is the openxml statement in sql server?