![SQL Server : Having the following table:-
sno val1
1 7.5
2 8
3 9.5
4 11
.
.
.
N val
Write the code to update the table where the difference in the column "val1" is computed i.e. (val1[2]-val1[1](/pics/thumbnails/sqlserver.png)
|
Code Required is:-
update cal set diff_val = 0 where ID = (select min(sno) from cal)
Update cal
....
|
|
|
|
1. Function returns a value but it is not necessary that stored procedure return a value.
2. Functio....
|
|
|
|
|
|
The three ways other than clustered and non-clustered it can be configured into Composite Index and ....
|
|
|
|
There are major two drawbacks of using indexes.
1.First one is the disk space. Index uses much spac....
|
|