Temp tables extension: https://codingsight.com/introduction-to-temporary-tables-in-sql-server/
Posts
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
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