Tip Bank

When using XMLHttpRequest object, there is a way to post data in the same way that an HTML Form is posted. All you need to do is add an HTTP

The following stored procedure will restore the database. This is helpful when you need to restore the database from other applications: CREATE PROCEDURE [dbo].[sp_db_restore]@DBName varchar(60),@BackName varchar(120),@DataName varchar(60),@DataFileName varchar(120),@LogName varchar(60),@LogFileName varchar(120)

The way we have constructors for user defined data types, we also have constructors for built in data types like chat, int, float and so on. Here is a program

The following demonstrates how to manipulate complex numbers: class Complex{ double real; double imag; Complex() { } Complex(double real,double imag) { this.real=real; this.imag=imag; } void addComplexNos(Complex comp1,Complex comp2) { this.real=comp1.real+comp2.real;

Debugging stored procedures can be a headache, but heres an easier way to trace a stored procedure’s execution: Use the PRINT statement. PRINT lets you output and analyze variable values,

‘ Retrieve the drive name (label) of the specified drive’ Note: requires a reference to the System.Management assembly’ Example: MessageBox.Show(GetDriveLabel(“D”c))Function GetDriveLabel(ByVal driveLetter As Char) As String Dim driveFilter As String

‘ Retrieve the serial number of the specified drive’ Note: requires a reference to the System.Management assembly’ Example: MessageBox.Show(GetDriveSerialNumber(“D”c))Function GetDriveSerialNumber(ByVal driveLetter As Char) As String Dim driveFilter As String =

‘ Get the Url pointed by the input link (*.url) file” Example: print the Url of all the link files in the Favorites folder’ Dim filePath As String’ For Each

‘ Count how many characters of a given type are in a file’ Example:’ Dim charCount(255) As Integer’ CountFileCharacters(“c: est.txt”, charCount)’ Debug.WriteLine(“the char ‘A’ was found ” & charCount(Asc(“A”)) &