itunes win64 downloads location

 

iPad3,3_5.1_9B176_Restore.ipsw

WHERE clause on SQL Server “Text” data type

SELECT * FROM @Village WHERE [CastleType] like 'foo' 

SELECT * FROM [Village] WHERE PATINDEX('foo', [CastleType]) <> 0

How to Escape Single Quotes in SQL2005

To fix the error mentioned above, escape single quotes with two single quotes as displayed in following example.

USE AdventureWorks
GO
SELECT *
FROM Person.Address
WHERE City = 'Villeneuve-d''Ascq'
GO

Reply above quoted message

The mail.identity.default.reply_on_top preference sets the default value for the reply text position for each account/identity. It defaults to 0, to have the reply at the bottom. You can use the Config Editor at Tools -> Options -> General to set it to 1 to have the reply on top.

Move all numbers from “Other Phone” to “Mobile Phone” field in Outlook contacts

Use Powershell to run this script

$outlook = new-object -com outlook.application
$contacts = $outlook.Session.GetDefaultFolder(10)
$contacts.Items | % { if($_.MobileTelephoneNumber -eq "") { $_.MobileTelephoneNumber = $_.OtherTelephoneNumber; $_.OtherTelephoneNumber = ""; $_.save() } }

Move all numbers from “Other Phone” to “Mobile Phone” field

Use Powershell to run this script

$outlook = new-object -com outlook.application
$contacts = $outlook.Session.GetDefaultFolder(10)
$contacts.Items | % { if($_.MobileTelephoneNumber -eq "") { $_.MobileTelephoneNumber = $_.OtherTelephoneNumber; $_.OtherTelephoneNumber = ""; $_.save() } }

select date from xx to xx

select * from table x

where date filed between date_from and date_to

openldap notes

ldapadd -x -D "cn=jimbob,dc=example,dc=com" -f step-1.ldif -w dirtysecret
slapd -d 63 -h "ldap:/// ldaps:///"

ldapadd -D "cn=sfitel, dc=my, dc=com" -f step-1.ldif -w cook

ms outlook 2010 contacts field names

---

Available in 9 languages

http://www.contactgenie.com/outlook_fields.htm

Sync Gmail and MS Outlook contacts

---

1_ Contact Sync – get free version here - http://www.pppindia.com/contacts-sync/index.html

2_ MS Outlook Add-In – get free version here - http://scand.com/products/outlook4gmail/install.html

Good Luck.