Michael Earl (5/21/2008)

---

In addition, if your "other" queries only needed the two specified columns, creating a "covering index" - which is an index that completely encompases the fields your query...

Hi

I hope this is right... did little bit of testing and seems allright.

To find out the wrong previous key entry..

select n.* From table1 n,table2 t

where n.previouskey =...

do you have anything else on your production server.

First and the best method in general is to go through BOL.

I also got no discrepiancy while testing in 2005 & 2000.

in both the cases after truncating the table the seed started with 0.

or use a trigger.

Hi

If you do not want to reinstall then you can change the collation of the database. Whenever you create a new db you will have the server collation as the...

rahul

here are 2 links to the function that will split your string to a recorset , i found on SSC.

http://www.sqlservercentral.com/articles/Advanced+Querying/2547/

This one uses a number table to do this.

http://www.sqlservercentral.com/scripts/Miscellaneous/31913/

hi

How i do this is like ...

Create a user defined function that returns a table to break down your string to rows. Then use the resultset of the function in...

no response 😉

yes check the datatype & length of the variable - @v_sql.

Hi

If u add the user to a sysadminm role then remove it after your purpose is over.

U cannot use double qoutes.

Hi

canu give the table structure and some data to make thing clear. I think a derived table can be used for this.

Hi

Pls explain clearly.