 |
There are many occasions where if someone updates a records or even deletes a record we need to keep the Audit trails of the record updated or deleted or even keep a history of records as what are the updates that happened on the database as well as what are the records deleted from the table. In...
By shabbir
Last Message By deonrock
|
10
23,671 |
 |
Introduction
Stored procedures are special objects available in sql server. Its a precompiled statements where all the preliminary parsing operations are performed and the statements are ready for execution.
Its very fast when compared to ordinary sql statements where the sql...
By venkatesanj@hcl.in
Last Message By anisa
|
6
152,279 |
 |
A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERT,UPDATE,OR DELETE statements.Triggers are used to enforce data integrity and business rules such as...
By Obaid
Last Message By watson88
|
12
211,109 |
 |
Introduction
I had a complex SQL query that was used to extract data from my system and send it across via web request to an external system. The query was taking unduly longer time to run. I made few changes to the query structure and reduced it run time to 7 mins. A part of the main query...
By sameer_havakajoka
Last Message By mitzanu
|
20
7,759 |
 |
Concatenating data with Multiple Result(s) using FOR XML PATH
Create table #TempProducts(Items Varchar(30),Colour Varchar(15))
Insert into #TempProducts values('Table','Red');
Insert into #TempProducts values('Table','Green');
Insert into #TempProducts values('Table','Blue');
Insert...
By mail.yuva
|
0
2,532 |
|
CUBE generates a result set that represents aggregates for all combinations of values in the selected columns. CUBE automatically generates a summation rollup to the top level of a GROUP BY.
Lets us look one Example.
Create table #TempTable(Items varchar(30),
...
By mail.yuva
|
0
3,171 |
 |
SQL Server implements Client/Server technology.A number of client send queries to the Central Server.The server after receiving the query request,parses it for syntax errors and process the request.Since the query passes from the client to the server through the network it adds to network...
By Safari
Last Message By kumarmannu
|
6
9,955 |
|
Introduction
This article deals with parsing techniques involved in executing the sql server query. Nowadays, stored procedures forms a strong back ground in accessing the database. Why is it so???? how it's related to my query parsing technique
Background
If we think about the query...
By venkatesanj@hcl.in
Last Message By technica
|
8
10,816 |
 |
What is SMO?
SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server.
SMO Overview
SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server. You can...
By sun_kangane
Last Message By technica
|
6
17,233 |