-
There are lot resources regarding the xml datatype in SQL 2005. For a start please go thru the links below http://weblogs.sqlteam.com/travisl/archive/2005/01/04/3931.aspx http://www.sql-server-performance.com/articles/dev/xml_data_2005_p1.aspx Amal
-
Server Error in '/' Application. Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. Description: An unhandled exception occurred...
-
Hi All, I have a table in my SQL Server 2005 database which has got more than 8,00,000 rows. It has a primary key defined on it. No non-clustered indices are defined. There is a periodic insert operation that inserts approximately 30,000 rows into the above mentioned table. This operation is annoyingly...
-
Consider two table below:(AId and BId are primary) Table A AId Name 1 ABC 2 MNB 3 POI Table B BId AId 1 1 2 1 3 2 "select A.Aid,A.Name,B.BId from A inner join B on A.Aid=B.BId" - a inner join like this will return the result as A.AId A.Name B.Bid 1 ABC 1 1 ABC 2 2 MNB 3 I want to remove the...