text

Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage...

I'm curious as to the business case for doing this. It sounds to me like you need to have your data normalized better.;-)

maureen,

You might want to look here. Just keep your semicolon in the excel spreadsheet, but then split the words apart with one of the several excellent methods mentioned there.

If you want the physical database files:

select [Logical Name] = [name],

[Physical Name] = physical_name

from sys.database_files

if you want the tables and columns...

sandi5980 (7/9/2009)

---

I know I can use my SQL Server Management studio to view the files and columns in a newly created database, but is there a way to generate a...

Paul White (7/9/2009)

---

Bruce W Cassidy (7/9/2009)

---

[font="Verdana"]Well, COALESCE is a SQL standard function, not just T-SQL. So perhaps the question is......

GilaMonster (7/9/2009)

---

A unique constraint is implemented as a unique index, so order of columns matters just as much, and for the same reasons, as with a composite index.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

That's the order...

Lynn Pettis (7/9/2009)

---

Okay, I saw this earlier this morning before I left for work, and I want to give them a shot, then I will look (Q1 and Q3) to...

I think :

1. that the first question was definitely fair.

2. the second question is beyond using sql at a fairly basic level, but still a good question (maybe this...

Well, after testing it, I don't know what to say....

Jeff Moden (7/8/2009)

---

Just to be sure... it's not the PK order that will be obeyed. It's the clustered index order that will be obeyed and actually, the INDEX(0) hint...

Hi Jeff,

Since the REPLACE function doesn't work on text data types, I think the reason for the cursor was that he was using the UpdateText function. This requires you to...

Great! It's always nice to see the solution that you end up implementing... it...

karthimca07 (7/8/2009)

---

Hi All,

Tab_Token_Master(Transid,Token_starts_from,Token_Ends_To,Token_value)

Tab_Token_Details(Transid,Token_No,Token_Value,Token_Status)

[p]The first table is used to store the token starting number and end number.[/p]

[p]for example (staring number)1 to 100(ending number). so i have to insert token1,token2...token100...

There are some characters that are "special" to XML; if they are present in the string they will cause the string to not be converted into XML. If you're going...