Hi

I am happy 🙂 to see you got the answer 🙂

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Do you have audit on Image field. I am curious to know what is the reson behind to this.

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Simulating "CONNECT BY" in SQL Server.

http://www.sqlteam.com/article/more-trees-hierarchies-in-sql

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Couple of things:

1) When you are inserting string value you need to enclose it in Single Quotes.

2) If the data has single quotes, then you need to replace them with...

what is the joing condition between these 3 tables?

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

This is your Table:

ID Response

---------------------------------------------

1 Ques1=1&Ques2=6&Ques3=4&Ques4=5

2 ...

Hi

You need to use SCOPE_IDENTITY().

I belive you want to insert data first into Parent Table and then use the Identity value and insert it in Child table. Repeate the above...

Hi

What is AVG size of the record?

What is the DefaultBufferSize set to?

What is the DefaultMaxBufferRows set to?

Mean while check out the below articles to modify the above attributes in order...

Hi

The problem with UNION is that it required sorting operation to eliminate duplicate row sets which is added cost for executing a statement, while UNION ALL return all rows without...

Its not too late..simple add one Identity column to have PK. this will make your life easier.

If you dont put PK now then its going to be too late in...

Hi

Not qute sue why you are making it so complex.

SELECT COUNT(*),type_desc FROM sys.objects

GROUP BY type_desc

use this query and copy the output to Excel sheet and do the cosmetic changes.

rather...

Hi

Check out the below which gives you detailed explanation of INSTEAD OF TRIGGER on View.

http://msdn.microsoft.com/en-us/magazine/cc164032.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

By looking at your table structure CustomerID is Primary Key. Not quite sure why do you want to have CustomoerID IS NULL Condition in the query.

Can you also tell...

Hi

Check out the below link

http://www.codeproject.com/KB/database/MovingSQLServer2005to2000.aspx

http://scottelkin.com/uncategorized/how-to-downgrade-a-database-from-sql-server-2005-to-sql-server-2000/

Thanks -- Vj

http://dotnetvj.blogspot.com

Hi

Are you getting this "low buffer memory error" on Oracle side?

Thanks -- Vj

http://dotnetvj.blogspot.com