Learn how to Make Money Online doing freelancing, Affiliate Marketing, Blogging and many more ...
Go4Expert
Go4Expert RSS Feed

Go Back   Programming and SEO Forum >  Go4Expert > Articles / Source Code > Database

Post New Thread  Submit New Article  Copy HTML to Clipboard  Copy BBCode to Clipboard  | More
Tutorials and Source Code in : SQL Server Bookmarks Forum Tools Search this Forum
Announcement
Views: 17,887 View Announcement Announcement: Rules for Duplicate Article Submission
10-08-2008 shabbir (Go4Expert Founder)
  Rating Article / Author Last Post Reverse Sort Order Replies Views
 
venkatesanj@hcl.in
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...
05-24-2010 05:06 AM
by LynxSI Go to last post
4 14,486
Red face
sameer_havakajoka
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...
12-28-2009 04:43 AM
by rasd123 Go to last post
18 2,432
Lightbulb
Obaid
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...
12-24-2009 01:09 PM
by technica Go to last post
5 24,900
 
Safari
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...
12-24-2009 01:07 PM
by technica Go to last post
3 2,368
 
venkatesanj@hcl.in
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...
12-24-2009 01:05 PM
by technica Go to last post
8 5,759
Thumbs up
sun_kangane
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...
12-24-2009 01:04 PM
by technica Go to last post
6 6,759
 
shabbir
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...
02-12-2009 01:50 PM
by shabbir Go to last post
7 15,395
Post New Thread  Submit New Article  Copy HTML to Clipboard  Copy BBCode to Clipboard  | More

Display Options Currently Active Users
Showing articles 1 to 7 of 7 1 (0 members & 1 guests)
 
Forum Tools Search this Forum
Search this Forum :

Advanced Search
Bookmarks

New comments New comments More than 15 replies or 150 views Hot articles with new comments
No new comments No new comments More than 15 replies or 150 views Hot article with no new comments
Closed Thread Article is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
 

All times are GMT +5.5. The time now is 05:28 AM.