Sponsored Links

Arrive. RAISE HELL. Leave

I think it was about 1 year ago when I was watching WWE Wrestle Mania XXIII. Stone Cold Steve Austin came up as a guest referre for the match  between Vince McMahon and Donald Trump with a band and there I saw these wonderful words comming up: Arrive. RAISE HELL. Leave. And God, I’m so [...]

How to reseed the identity value of a table?

I was working on a project and there was a lookup table in that which needed to be populated and its identity values needed to strictly match with the database at my client’s end. At first when I tried to insert data from another table it turned in to an error, the rows didnt get [...]

(Wo)Man Diet. Probably something that men should also do

Read this article on MSN.com, some woman wrote this question:-

I’ve been married for eight years, I have a 5-year-old child — and I’m madly in love with my colleague, who’s also married. About two years ago, we had a month-long affair, but he wants to stay with his wife and barely talks to me now. [...]

How to get the special characters from keyboard?

ANSI secrets

 

Ever wondered how to get special characters like ©, ® or ™ in your document? You don’t need any special software installed. Windows has it’s own inbuilt character map utility, which you can use to identify individual special characters. Using copy and paste you can insert them into [...]

Ill treatment with Applicants at the Swedish Embassy in Islamabad

I’ve received the news from the Swedish Migration board that my document haven’t reached there although it’s in their record that they’ve been submitted on May 21, 2008. When I tried calling the Swedish embassy at Islamabad I received a very rude response, that call us between 2 – 3 pm and guess what, the [...]

How to access data from two different tables in SQL Server 2005?

howdy,

well I was having a problem where I needed to populate the table of my SQL Express 2005 database from another table in another database. So I wrote the query in the following fashion:

INSERT INTO debtdb.SchemaName.TableName (column1, column2….)

SELECT Column1, column2…

FROM dbName.SchemaName.TableName

 

my sample query was this

Insert into db2.dbo.tblNationality(NationalityName) 

Select

Name FROM db1.dbo.tblNationality

what it does is that it [...]

Changing a Column to Identity after creation.

Today I had to change the Primary key columns in tables so that they can become identity columns but I couldn’t do it using Alter Table x Alter column y IDENTITY(1,1) command. So I found out that you can’t use ALTER TABLE to change a column into IDENTITY column (except on SQL Server CE!). One [...]

Properties in .NET

Property in C#:

Property ? it is a special method that can return a current object?s state or set it. Simple syntax of properties can see in the following example:

public int Old 
{
   get {return m_old;}
   set {m_old = value;}
 } 
public string Name 
{
   get {return m_name;} 
}

Here are two types of properties. A first one can set or get [...]

Enumerations in .NET

The enum keyword is used when you require a enumeration. A enumeration is a distinct type that consists of a set of named constants called the enumetor list. Every enumeration type has an underlying type which can be all integral times except that of a char type.Where:

Declaration syntax:

attributes (optional) – this is additional declarative [...]

How To Increase The Google Crawl Rate For Your Website

It is every important to understand one simple concept and it is that, you can never force or cheat Googlebot into crawling your website. But you can always employ certain steps, that would ensure that Googlebot gets attracted to your content and crawls it. Here are a few ways to do just exactly that:

You should [...]