>> 1)What are different types of Cursors?
http://www.databasejournal.com/featu...er-Cursors.htm
>> 2)What are diff types of locks?
<table_hint> ::=
[ NOEXPAND ] {
INDEX ( index_value [ ,...n ] ) | INDEX = ( index_value )
| FASTFIRSTROW
| FORCESEEK
| HOLDLOCK
| NOLOCK
| NOWAIT
| PAGLOCK
| READCOMMITTED
| READCOMMITTEDLOCK
| READPAST
| READUNCOMMITTED
| REPEATABLEREAD
| ROWLOCK
| SERIALIZABLE
| TABLOCK
| TABLOCKX
| UPDLOCK
| XLOCK
}
See:
http://technet.microsoft.com/en-us/l.../ms187373.aspx
3) What is Z order Precedence?
Lets say you have 3 buttons that are all docked to "Top". How do you determine which button is the first, second, then third? The answer is the Z-Order. You can right click on the bottom-most button and click "Send to Back" and it will make that button the top most. Likewise you can click on the topmost button and click "Bring To Front" to send it to the bottom.
>>4) dim X,Y as integer
In Visual Basic 6.0, you can declare variables of different types in the same statement, but you must specify the data type of each variable or it defaults to Variant. The following example shows multiple declarations and their resulting data types.
Dim I, J As Integer ' I is Variant, J is Integer.
Dim L As Integer, M As Integer ' L is Integer, M is Integer.
Dim N As Integer, X As Double ' N is Integer, X is Double.
http://msdn.microsoft.com/en-us/library/56ht941f.aspx
In VB.NET:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim x, y As Integer
Console.WriteLine("x: " + VarType(x).ToString())
Console.WriteLine("y: " + VarType(y).ToString())
System.Diagnostics.Debugger.Break()
End Sub
Results in:
Reputation Points: 1749
Solved Threads: 735
Senior Poster
Offline 3,948 posts
since Feb 2009
Unsolved 
