What is application role in sql server database security? : sql server security
Explain what is meant by replication of database?
What is the difference between insensitive and scroll cursor?
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
List the types of recovery model available in sql server?
What is the log shipping?
How do I start sql server 2016?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
Explain the difference between function and stored procedure?
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 TRUNCATE and DROP?
find the 3rd max salary
What is difference between getdate and sysdatetime in sql server 2008?