OpenSUSE

I am so regretted to install OpenSUSE in my 9 years old PC. I wanted to install Compiz but I could not install because there are problems between KDE and Compiz. I wanted install Google Chrome instead update Mozilla Firefox, and also I could not install Google Chrome because of Zypper. What the hell is Zypper? Why can not I simply type 'apt-get install google-chrome'?

I already made a decision. I will install other Linux Distro with GNOME. I just wanted install Compiz, Google Chrome...

I am disappointed with OpenSUSE. I thought was fantastic but is not! However, I will show a picture with system information with OpenSUSE.

SQL - Procedural Programming - TRY ... CATCH

The TRY...CATCH construnct was introduced with SQL Server 2005 for error handling using T-SQL. Statements to be tested for an error are enclosed in a BEGIN TRY ... END TRY block.
A CATCH block immediately follows the TRY block, and error-handling logic is stored here. The following examples shows the basic syntax:

BEGIN TRY
-- code that may produce errors
END TRY
BEGIN CATCH
-- error handling logic
END CATCH

SQL Server evaluates each statement in TRY block sequentially. If a runtime error is encountered, control immediately jumps to the CATCH block, and error information can be retrieved, logged, and displayed to the user.

Steve Jobs

“Your time is limited, so don’t waste it living someone else’s life,”

Jobs said. “Don’t be trapped by dogma — which is living with the results

of other people’s thinking. Don’t let the noise of others’ opinions

drown out your own inner voice. And most important, have the courage to

follow your heart and intuition. They somehow already know what you

truly want to become. Everything else is secondary.”

R.I.P. Steve Jobs

Ubuntu vs OpenSUSE vs Fedora

In past few weeks, I upgraded my 9 years old PC. I bought a Ethernet card, 1GB memory RAM and 160GB Hard Drive IDE/ATA to upgrade my old PC.

My question was what operating system I will install to my 9 years old PC. I was undecided between Ubuntu and OpenSUSE. So I researched more deep, and I found out a site who helped me a lot.

I had two choices: OpenSUSE or Fedora. To my surprise, Ubuntu had 90% of recommendation. So I ignored Ubuntu and I tried OpenSUSE and Fedora with LiveCD. After I experimented both, I decided to install OpenSUSE.

SQL - Procedural Programming - Variable

A variable is a container for a single data value of a particular type. In Transact-SQL (T-SQL), all variables are preceded by an @ symbol.

Local variables are used in T-SQL scripts for a variety of purposes including:

• Storing values to be tested by control-of-flow statement
• Acting as counter in a loop
• Storing the results of an expression
• Retrieving field values for a single record using a SELECT statement

Variable are also used to pass values into parameters for stored procedures and user-defined functions. When declaring a variable, you must specify its name, datatype and sometimes the length and precision of datatype. The DECLARE statement can be used to declare multiple variables by separating them with commas.

Example

DECLARE @var1 int, @var2 varchar(255);

The preferred way to set the contents of a variable is use the SET statement. It is also possible to use the SELECT statement to set the value of one or more variables.

SET @var1=5;

SELECT @var2='A varchar string';