It is Non-Clusterindex

object_id name ...

Thanks for your quick replay.

uniqueidentifier column(with primary key (now)) has been used in table joining in current design.

so if i remove the current primary key on uniqueidentifier, will the...

Supported means that Microsoft "supports" that configuration. I have installed SQL Server on non-supported platforms and been able to use it plenty of times.

But seriously, why install SQL Server...

SQLRNNR (2/27/2014)

---

Are you looking for a means to install it for testing?

Even though it is not supported, you might be able to successfully install it.

I run developer edition of SQL...

Checked Hardware and Software Requirements for Installing SQL Server 2012 could not find Windows XP.

http://msdn.microsoft.com/en-us/library/ms143506.aspx

Have any one tried it?

Even for 32 bit?

OS : Windows XP with SP3

Can we install sql server 2012 (32 bit) on Win XP

Thanks for the Link but it does not give the solution rather it is trying to address the problem but not fully.

Pasting couple of rows is not a problem but what is the logic...?

I/P

'0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ'

Divide by 3;

i need it as

O/P

'0ABCDEFGHIJKLMNOPQRSTUVWXYZ' -1

'0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ' -2

String len =71(27+54);

I know one string len can not exceed 27

say the string is now 27*4 =108

I/P

'0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ'

Divide by 2;

O/P

'0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ' -2

'0ABCDEFGHIJKLMNOPQRSTUVWXYZ0ABCDEFGHIJKLMNOPQRSTUVWXYZ'...

how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a dynamic...

Similiar thing for flaot values can we get..!

for decimal values is it is possible...

Select utl_raw.cast_to_varchar2(utl_raw.CAST_FROM_BINARY_FLOAT(.2635)) from dual;

>†éy

LutzM (12/15/2013)

---

Example: let's assume all 100 columns are defined as integer. Then one row will use 400byte. So you're transferring almost 400MB each time the sort order is changed.

Assuming the...

page will be having 1000 records (between 1 and 1000 ) in first go.. for each and every scroll there be another 1000 rows (between 1001 and 2000 )and so...

The information will be stored in a BLOB table as...