And when you migrate from one version of SQL to another.

I have tables with xml columns and having lot of rows. As long as i retrieve only a few rows (as pointed out earlier) i dont have problems.

Hi

How do you get 9 hrs. Is it stored somewhere in the db.

You can use the collate keyword along with Cast to collate all the data in the column to a single collation. If you take a distinct after collating the data...

Good tip.

Yes.

In vss there is a solution under which there are different projects. In vss this solution is the parent folder under which you have folders for each projects.

Here is how...

Douglas Duncan (4/11/2009)

---

The correct answer is no, and I would imagine that the people in power will correct the issue soon. In addition to the explanation given in the answer,...

arun.sas (4/9/2009)

---

Hi Manohar,

Try this

declare @abc table

(

name1 varchar(10)

)

insert into @abc values ('NAME1')

insert into @abc values ('NAME10')

insert into @abc values ('NAME11')

insert into @abc values ('NAME111')

insert into @abc values ('NAME2')

insert into @abc values...

If you need the sql statement that executed you need to pass the sql_handle to sys.dm_exec_sql_text using cross apply. Check BOL for examples.

Developer/DBA.

Another way is to create the project from ssms, add the scripts to the project and then add the solution to vss.

You will need to create a new solution and project from SSMS. Then you can add the prject you have created to vss. To do this open the project in...

You need info about different things before deciding on the indexes. Some of them are

Volume of data in the table (IMP),

Type of queries that are going to hit the...

To know the current identity value use IDENT_CURRENT function. To know the increment value use the IDENT_INCR function. To know the original value of the seed use the IDENT_SEED function....

Also check out Except and ALL keywords.