Thursday , December 14 2017
Home / Samba

Samba

November, 2016

  • 30 November

    step by step Procedure for Creating DDL Triggers (Part-1)

    DDL-Trigger

    DDL triggers: DDL triggers fire in response to a variety of Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords CREATE, ALTER, DROP, GRANT, DENY, REVOKE or UPDATE STATISTICS. DDL triggers are fired when user performs DDL events(CREATE,ALTER and DROP) in the …

  • 30 November

    step by step Procedure for Creating DDL Triggers (Part-2)

    DDL-Trigger

    In Previous Article we seen types of Triggers in SQL Server , now in this article we will know steps for how to create DDL triggers on a table. Step 1: Create trigger for Understandable message after creation of table.Please follow below screen. Step 2: Create a sample table for testing …

  • 30 November

    step by step Procedure for Creating DML Triggers

    DML-Trigger

    In Previous Article we seen types of Triggers in SQL Server , now in this article we will know steps for how to create DML triggers on a table.In this example we are creating trigger for employee table 1. After triggers or For triggers: Step 1: Create a sample table employee …

  • 30 November

    what is Trigger and Types of Triggers in SQL Server

    TYPESOFTRIGGERS

    Triggers in Sql Server:- A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.A trigger is executed implicitly whenever the triggering event happens, which performs their own operation when user performs any INSERT, UPDATE, DELETE operations on a specific table. …

October, 2016

  • 4 October

    When SQL Server Uses Indexes:

    When SQL Server Uses Indexes: Sql sever uses indexes of a table provided the select or update or delete statement contained “where” condition in them and more over the where condition column must be a indexed column. If the select statement contain an “order by” clause also indexes will use. …

September, 2016

  • 3 September

    Indexes in Sql Server one by one

    studyclues_sqlserver_indexes

    Indexes in Sql Server one by one:- Indexes: Indexes are created to Improve performance of data accessing or data retrieval Index Improves performance of “select” operation. Types of Indexes: 1.simple Index 2.composite Index 3.Unique Index 4.Clustered Index 5.Non Clustered Index Sample Tables: Table 1:EMPLOYEE [crayon-5a324922cb4aa226278672/] 1.Simple Index:- If the Index …

August, 2016

  • 31 August

    Set Operators in Sql Server (one by one)

    SET OPERATORS

    Set Operators in Sql Server (one by one): SQL server provides the following set operators which combines results from two or more Queries into a single result set. Those are: 1.Union 2.union All 3.Intersect 4.Except To combine the results of two queries we need to follow the below basic rules …

  • 30 August

    SUB QUERIES

    Subqueries

    Subqueries:- 1.A query inside another query is known as subquery. 2.First inner query is executed then result of inner query is input for outer query. 3.Outer can be insert/update/delete/select 4.inner query must be always select. Types of Subqueries:- 1.single row subquery 2.Multirow Subquery 3.Co-related Subquery [crayon-5a324922cc7a2093503784/] Sample Tables: Table 1:EMPLOYEE …

  • 23 August

    Every Sql Server Developer Should know this Tips

    Studyclues_shouldknow

    Every SQL Server Developer Should Know this tips 1.Query Execution Order in Sql Query:- 1.From clause 2.Where clause 3.Group by clause 4.Having clause 5.Select clause 6.Order by clause 2. Find  Number of Tables In a Single DataBase   [crayon-5a324922cd06d043327876/] 3.Find All Number of Columns In a DataBase [crayon-5a324922cd079666431750/] 4.Find Number of …

  • 23 August

    Multirow Functions:-

    Studyclues_MultiRow

    Multirow Function:- These functions process group of Rows and Return one value. This functions are also called group functions or aggregate functions. 1.Max():- Returns Maximum value [crayon-5a324922cd8c7764705878/] [crayon-5a324922cd8d3867907148/] Maximum salary of managers? select Max(sal)from emp where Job=’MANAGER’ 2.Min():- Returns Minimum value [crayon-5a324922cd8da318124351/] [crayon-5a324922cd8df719355890/] 3.Sum():- Returns total [crayon-5a324922cd8e4752882035/] 4.Avg():- Returns average …

  • Page 1 of 4
    1 2 3 4