Sanjeet Pandey

Explain the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption. It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to CREATE PROCEDURE Abc WITH ENCRYPTION AS <<    SELECT statement>> GO What is a linked server in SQL Server? It enables SQL server to address diverse data sources like OLE DB similarly. It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions. Features and concepts of Analysis Services Analysis Services is a middle tier server for analytical processing, OLAP, and Data mining. It manages multidimensional cubes of data and provides access to heaps of information including aggregation of data one can create data mining models from data sources and use it for Business Intelligence also including reporting features. Some of the ...

SUBQUERIES Subqueries are used to structure queries.   In  many  cases, a subquery can be used instead of a JOIN (and vice versa). For database systems fully compliant with the SQL 92 standard, a subquery can also be used to provide one or more values in the SELECT clause. In most database systems, subqueries are typically part of the WHERE clause, as follows:   WHERE  column  IN  (subquery WHERE  column  <comparison>  (subquery) WHERE   EXISTS  (subquery) The subqueries themselves are complete  SELECT  statements, enclosed in parentheses.   Examples   IN                         Find the price of all products in a particular category, for example condiments. Type this query in the SQL window and check against the result shown below:            ...