Search In
In today's world, we need to display the data in tabular format with edit and delete functionality. For example, in ASP.NET we have Gridview control, which is more simple to achieve this. We have Edit data template and view template in ASP.NET Gr
TRIGGERS IN MS-SQL
Triggers are special kind of stored procedures that triggers automatically when an event occur. Triggers are written to fire when a specific event on table occurs. Following are the events that may force trigger-:
1) DML operatio
STUFF():-
STUFF is SQL SERVER function which is used to insert the string in another string. It deletes the specified number of characters from first string and insert the new string in the place of d
In MVC for performing various operations we can use the predefined templates for the execution of the program easy.
For the basic operation like binding the gridview we can use the list template for it.
I h
While display bulk of data in MVC we use lot of things for it.
One way is to display it using the table but in this case we dont have the basic functionality like paging sorting and if we want to edit it in the same view we are in then it wi
Arithmetic operations are very basic in every strongly type programming languages. We will oftenly save the result of this arithmetic computation in certain type of variable. Suppose if I am adding two integers then i will save the result in in
Hi All,
Some time we need to update value in a table in some pattern or increment order. Then we use loop and iterate with all record, but as know looping is take time and our application become slower.
We can achieve this by without loop also. bel
There might be some scenario in your code, where some of the tasks should be performed in the background without affecting the current task. Some time we have scenario, where we needed to fire the function, which consists of some function call, where
Protocols
Protocols are the set of standards that is followed while making any communication in the network.
Any node in the network cannot send or receive the data without following the protocols defined for the networking process.
Cursor In SQL
Cursor is used to iterate within a table. It is a pointer which iterates within a table to fetch rows.
Life cycle of cursor
1)DECLARE
Firstly you
