Method 1
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
Method 2
string strHostName = System.Net.Dns.GetHostName();
string clientIPAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString();
HttpContext.Current.Request.UserHostAddress;
Use the below code to get the IP address of the machine and not the proxy use the following code
HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_For]
If you are using SQL Server 2005, then you can use Intersect Key word, which gives you common records.
SELECT column1FROM table1INTERSECTSELECT column1FROM table2
If you want in the output both column1 and column2 from table1 which has common columns1 in both tables.
SELECT column1, column2FROM table1WHERE column1 IN(SELECT column1FROM table1INTERSECTSELECT column1FROM table2)
USE JobPortal
GO
Method-1
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE ‘%Jobseekers%’
GO
Method 2
SELECT DISTINCT o.name ,o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE ‘%Jobseekers%’
GOUSE JobPortal
GO
–Searching for Jobseekers table
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%Jobseekers%’
GO
Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Trusted Connection
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
Connecting to an SQL Server instance
Server=myServerName\theInstanceName;Database=myDataBase;
Trusted_Connection=True;
Connecting to an SQL Server instance via an IP address
Data Source=192.168.1.80,Network Library=DBMSSOCN;
Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
SELECT name,create_date, modify_date FROM sys.objects
WHERE type = ‘P’
AND DATEDIFF(D,modify_date, GETDATE()) < 7 getDate()
getDate function returns the current date from 1 to 31 according to the corresponding month.
getDay()
getDay function returns the current Day of the week from 0 to 6 where 0 for Sunday, 1 for Monday and so on.
getMonth()
getMonth function returns the current month from 0 to 11 where 0 for January, 1 for February and so on.
getFullYear()
getFullYear function returns the current year e.g. 2008
The following methods all extract information from the Date object:
| Method | Description | Example |
|---|---|---|
getFullYear () | Retrieves the year component of the date as a 4-digit number. | y = x.getFullYear () |
getMonth() | Retrieves the month component of the date as a number from 0 to 11 (0=January, 1=February, etc) | y = x.getMonth() |
getDate() | Retrieves the day-of-month component of the date as a number from 1 to 31 | y = x.getDate() |
getDay() | Retrieves the day of the week component of the date as a number from 0 to 6 (0=Sunday, 1=Monday, etc) | y = x.getDay() |
getHours() | Retrieves the hours component of the date as a number from 0 to 23 | y = x.getHours() |
getMinutes() | Retrieves the minutes component of the date as a number from 0 to 59 | y = x.getMinutes() |
getSeconds() | Retrieves the seconds component of the date as a number from 0 to 59 | y = x.getSeconds() |
getMilliseconds() | Retrieves the milliseconds component of the date as a number from 0 to 999 | y = x.getMilliseconds() |
getTimezoneOffset() | Retrieves the time difference, in minutes, between the computer's local time and GMT | y = x.getTimezoneOffset() |
The following methods are similar to the previous ones, but they work with UTC (Universal Time Coordinated) time, or GMT, rather than the computer's local time.
UTC is a timezone-independent way of storing time values, based on milliseconds since midnight, January 1, 1970 in the GMT timezone. All dates and times are stored internally in JavaScript using UTC. When you use the above, non-UTC functions to get dates and times, JavaScript converts the time back into the local computer's time locale first. However, the UTC functions below will return times and dates in UTC format instead.
| Method | Description | Example |
|---|---|---|
getUTCFullYear () | Retrieves the year component of the date as a 4-digit number. | y = x.getUTCFullYear () |
getUTCMonth() | Retrieves the month component of the date as a number from 0 to 11 (0=January, 1=February, etc) | y = x.getUTCMonth() |
getUTCDate() | Retrieves the day-of-month component of the date as a number from 1 to 31 | y = x.getUTCDate() |
getUTCDay() | Retrieves the day of the week component of the date as a number from 0 to 6 (0=Sunday, 1=Monday, etc) | y = x.getUTCDay() |
getUTCHours() | Retrieves the hours component of the date as a number from 0 to 23 | y = x.getUTCHours() |
getUTCMinutes() | Retrieves the minutes component of the date as a number from 0 to 59 | y = x.getUTCMinutes() |
getUTCSeconds() | Retrieves the seconds component of the date as a number from 0 to 59 | y = x.getUTCSeconds() |
getUTCMilliseconds() | Retrieves the milliseconds component of the date as a number from 0 to 999 | y = x.getUTCMilliseconds() |
The following methods allow you to set components of the Date object:
| Method | Description | Example |
|---|---|---|
setFullYear() | Sets the year component of the date using a 4-digit number. | x.setFullYear(2002) |
setMonth() | Sets the month component of the date using a number from 0 to 11 (0=January, 1=February, etc) | x.setMonth(11) |
setDate() | Sets the day-of-month component of the date using a number from 1 to 31 | x.setDate(17) |
setMinutes() | Sets the minutes component of the date using a number from 0 to 59 | x.setMinutes(45) |
setSeconds() | Sets the seconds component of the date using a number from 0 to 59 | x.setSeconds(0) |
setMilliseconds() | Sets the milliseconds component of the date using a number from 0 to 999 | x.setMilliseconds(500) |
And again, these methods set date components using UTC, rather than the computer's local time:
| Method | Description | Example |
|---|---|---|
setUTCFullYear() | Sets the year component of the date using a 4-digit number. | x.setUTCFullYear(2002) |
setUTCMonth() | Sets the month component of the date using a number from 0 to 11 (0=January, 1=February, etc) | x.setUTCMonth(11) |
setUTCDate() | Sets the day-of-month component of the date using a number from 1 to 31 | x.setUTCDate(17) |
setUTCHours() | Sets the hours component of the date using a number from 0 to 23 | x.setUTCHours(20) |
setUTCMinutes() | Sets the minutes component of the date using a number from 0 to 59 | x.setUTCMinutes(45) |
setUTCSeconds() | Sets the seconds component of the date using a number from 0 to 59 | x.setUTCSeconds(0) |
setUTCMilliseconds() | Sets the milliseconds component of the date using a number from 0 to 999 | x.setUTCMilliseconds(500) |
Date methodsThere is a handful of further methods that can be used on Date objects:
| Method | Description | Example |
|---|---|---|
parse() | Converts a date text string to the "milliseconds since midnight Jan 1, 1970" format. You call it using Date.parse() rather than object.parse(). | x = Date.parse |
UTC(y, m, d, h, m, s) | Converts the specified date to the "milliseconds since midnight Jan 1, 1970" format. You call it using Date.UTC() rather than object.UTC(). | x = Date.UTC(1972, 0, 6) |
toString() | Outputs the value of the Date object as a date text string. | y = x.toString() |
toUTCString() | Outputs the value of the Date object as a date text string, using UTC. | y = x.toUTCString() |
toLocaleString() | Outputs the value of the Date object as a date text string, using the computer's locale conventions (e.g. D/M/Y for UK computers). | y = x.toLocaleString() |
toDateString() | Outputs the "date" portion of the Date object as a text string. | y = x.toDateString() |
toTimeString() | Outputs the "time" portion of the Date object as a text string. | y = x.toTimeString() |
enum Polygon
{
Triangle = 3,
Quadrilateral,
Pentagon,
Hexagon
}
static void Main(string[] args)
{
foreach (Polygon p in Enum.GetValues(typeof(Polygon)))
{
Console.WriteLine("{0} ({1})", p, (int)p);
}
}
/* OUTPUT
Triangle (3)
Quadrilateral (4)
Pentagon (5)
Hexagon (6)
*/
Console.WriteLine("byte\t{0} to {1}", byte.MinValue, byte.MaxValue);
Console.WriteLine("sbyte\t{0} to {1}", sbyte.MinValue, sbyte.MaxValue);
Console.WriteLine("short\t{0} to {1}", short.MinValue, short.MaxValue);
Console.WriteLine("ushort\t{0} to {1}", ushort.MinValue, ushort.MaxValue);
Console.WriteLine("int\t{0} to {1}", int.MinValue, int.MaxValue);
Console.WriteLine("uint\t{0} to {1}", uint.MinValue, uint.MaxValue);
Console.WriteLine("long\t{0} to {1}", long.MinValue, long.MaxValue);
Console.WriteLine("ulong\t{0} to {1}", ulong.MinValue, ulong.MaxValue);
Console.WriteLine("float\t{0} to {1}", float.MinValue, float.MaxValue);
Console.WriteLine("double\t{0} to {1}", double.MinValue, double.MaxValue);
Console.WriteLine("decimal\t{0} to {1}", decimal.MinValue, decimal.MaxValue);
/* OUTPUT
byte 0 to 255
sbyte -128 to 127
short -32768 to 32767
ushort 0 to 65535
int -2147483648 to 2147483647
uint 0 to 4294967295
long -9223372036854775808 to 9223372036854775807
ulong 0 to 18446744073709551615
float -3.402823E+38 to 3.402823E+38
double -1.79769313486232E+308 to 1.79769313486232E+308
decimal -79228162514264337593543950335 to 79228162514264337593543950335
*/
* Outputs "The Quick Brown Fox JUMPS Over The Lazy Dog."
nt? a = 10;
int? n = null;
int result;
result = a ?? -1; // result = 10
result = n ?? -1; // result = -1
DECLARE @Var1 INT
DECLARE @Var2 INT
SET @Var1 = 1
SET @Var2 = 2
SELECT @Var1 ‘Var1′, @Var2 ‘Var2′
Method 2: Single statements for declaring multiple variables
DECLARE @Var1 INT, @Var2 INT
SET @Var1 = 1
SET @Var2 = 2
SELECT @Var1 ‘Var1′, @Var2 ‘Var2′
GO
From above example its clear that we can declare multiple variables in one statements.