Do you want to store "width * height" in WEIGHT column??

There is nothing like creating parameters to the view/table. Based on the input you need to have WHERE conditions.

I am kind of lost, what is front-end for the End user?

It realy depends on the architecture of the system on where to define the business rules. If it is an OLTP system i would like to define all the PK...

mauryakamal (4/14/2009)

---

1) Is it unique index is cluster index or non cluster index?

2) If we define the unique index column not null then what type of the index.

3) If unique...

You can even try with CASE statement.

ex:

CASE WHEN arg1 IS NULL THEN 'x' ELSE arg1 END

Can you give us Sample Input Data and sample out data and few lines about what do you want to do.

Hi,

By looking at the error, may be this is related to the Length of the field. Please verify the Length of the fields with the XML values/XSD Schema.

Instead of using...

This is not the place to share the link. You can share the infromation using "Blogs".

rgillings (4/14/2009)

---

From what I understand, and please correct me if I am wrong, UPDATE FROM is not ANSI standard

So with the MERGE statement introduced in SQL 2008, it is preferred...

If you are looking for SQL then the best way to put is :

Input Sample Data and Output Sample Data and few lines about the requirement.

Hi

You need to manually write No.Of Alter statements based on No.Of Tables.

There is no Magic;-)

This is what i like about the SQL Server, Updates using is Join is really kool. In Oracle there is no way you can perform Joins in Updates unless you...

You can even think about using "ON DELETE CASCADE" to perform the deletes with out writing the code.

Functions means user Defined Functions or the Row and Group functions?