Hi

Are you the owner of the table? If YES then there shouldn't be any problem. In this case looks like you are not the owner of the table. TRUNCATE is...

Hi

But to my understanding Order by Clause is the which gets executed as the last step in SQL query and it is completely based on what the alias was used....

Hi

As suggested by nagar has Foreign Keys, but to provide good solution can you tell us your complete requirement.

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.vom

Thats a good idea let me try it out...

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

You may want to refer to the below link

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic45049.aspx

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

using Windows PowerShell you can do this.

get-childitem *.mdf |

sort-object LastWriteTime |

format-table Name, LastWriteTime

This statement assumes database is in AutoClose mode.

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

In addition to the "Florian Reischl" store procedure its good to use TRANSACTIONS also.

If one INSERT fails then dont proceed with the next INSERT.

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.vom

Hi

In simple words you can use the cursors when you have plenty of time 🙂 i.e. Even if the system suffers from perfromance nobody is going to complaint. 🙂

Thanks --...

Hi

When you say "What If we are to get total record count by joining more than two table?"

Based on the table join criteria you want to count the No.Of Records?...

Hi

In simple words in stead of splitting teh database i would go with breaking the tables in Horizontal way i.e. either by creating partitions or breaking the tables like Current...

Hi

Instead of the code can you give us what is requirement? and how the the data access pattern??

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

Ramesh, Instead of Unique Constraint why can't we have Unique Index??

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

At the first place why dont you store this in XML type?? Btw which version of SQL Server you are using?

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

Looks like data is no good. but the answer provided by RBarryYoung is good to solve your problem.

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com

Hi

Check out the below link

http://deepakrangarajan.blogspot.com/2009/02/full-text-index-sql-2005.html

Thanks -- Vijaya Kadiyala

http://www.dotnetvj.com