Posts

TSQL statements: https://o7planning.org/en/10327/sql-server-transact-sql-programming-tutorial
Dotnet Interview Question: OOPS:  Abstract classes, Interface, Encapsulation, Method hiding, Method overloading, Generics,collection,Delegates,Extension Methods. SQL: Joins, Stored procedures, functions, triggers, transactions, ACID, Normalization. Highest salary query. eliminate duplicate records. Table variables. Temp tables. views. Indexes. ASP.net: state management. page life cycle events. Server.transfer vs Response.Redirect WCF: contracts. security. Design Patterns: singleton. Factory. Abstract Factory. MVC: Routing. Filters. Results. Data Annotations. ADO.net: DataReader. Datasets. Project: Challenges in the current project. Roles & Responsibilities. Number of classes used. Which module you worked in the project. How you have done email notification in MOD(Manager on Duty). How to close the active incidents query. What design you implemented in the project. How do you create incidents query. who is u
DDL OPERATIONS: The various DDL commands are CREATE, ALTER and DROP.   Let us learn about each DDL Command one by one with examples. CREATE Statement:   The CREATE statement in SQL is used to create the database and the database objects like Tables, Views, Sequences, etc. Let us see how a database and table are created in SQL. Creating a database in SQL:   Syntax: CREATE DATABASE DatabaseName; Example: CREATE   DATABASE  Demos;     On executing this query, a database named "Demos" is created.   Creating Table in SQL:   Database is a collection of related tables and other objects. This implies that a table is a part of the database. Now, we have created the "Demos" database. And, we need to create a "Students" table in this database. By default, the master database is selected. Select Demos database from the dropdown list or alternatively you can use the following command: Use Demos;   This command will instru
Image
General purpose queries: Query 1: Retrieve List of All Database   EXEC  sp_helpdb     Query 2: Display Text of Stored Procedure, Trigger, View   exec  sp_helptext @objname =  'Object_Name'      Query 3: Get All Stored Procedure Relate To Database   SELECT   DISTINCT  o. name , o.xtype      FROM  syscomments c      INNER   JOIN  sysobjects o  ON  c.id=o.id      WHERE  o.xtype= 'P'      To retrieve the View use “V” instead of “P” and for functions use “FN.   Query 4: Get All Stored Procedure Relate To Table   SELECT   DISTINCT  o. name , o.xtype      FROM  syscomments c      INNER   JOIN  sysobjects o  ON  c.id=o.id      WHERE  c.TEXT  LIKE   '%Table_Name%'   AND  o.xtype= 'P'      To retrieve the View use “V” instead of “P” and for functions use “FN.   Query 5: Rebuild All Index of Database   EXEC  sp_MSforeachtable @command1= "print '?' DBCC DBREINDEX