String in Switch statement in JAVA JDK 1.7

See this article http://netbeans.org/kb/docs/java/javase-jdk7.html

And Do the following

** set the Sources/Binary Format to JDK 7. You can do this in the bottom right of the Sources section of the Project Properties window.





Mohammad Abu Hmead

Replace in MSSQL

Replace in MSSQL

use Satellites
Declare @ss as nvarchar(400)
set @ss ='.png'
Update dbo.Frequencies_Owners
Set logoLink = REPLACE(cast(logoLink as nvarchar(max)), @ss, '')

Import Excel Sheet to MySqlTable

Sometimes you want to import excel sheet to your MySQL DB table which contains Data for this table, the way bellow guide you how to do that:

1- Create Microsoft Excel 97-2003 Worksheet.

2- Place the table fields names in the first row.

3- Rename the sheet to your table name.

4- Go to your MySQL Admin page and open your DB and open your table.

5- Press on the Import tab and point on your document location.

6- Set the charset to UTF8.

7- Pick Excel 97-2003 XLS Workbook.

8- Check Column names in the first row.

9- Press "Go".

Mohammad Abu Hmead