Database

awadhendra tiwari wrote:

I have problem where I have get list of all tables on which full text index can be applied with their key names.

  SELECT TC.[TABLE_SCHEMA]
       , TC.[TABLE_NAME]
       , CCU.[COLUMN_NAME]
       , TC.[CONSTRAINT_NAME]
    FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
    JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU ON TC.[CONSTRAINT_NAME] = CCU.[CONSTRAINT_NAME]
   WHERE TC.[CONSTRAINT_TYPE] = 'PRIMARY KEY'
     AND EXISTS (
            SELECT *
              FROM INFORMATION_SCHEMA.COLUMNS C
             WHERE C.[TABLE_NAME] = TC.[TABLE_NAME]
               AND C.[DATA_TYPE] IN (
                     'char', 
                     'varchar', 
                     'nchar', 
                     'nvarchar', 
                     'text', 
                     'ntext', 
                     'image', 
                     'xml', 
                     'varbinary', 
                     'varbinary(max)'
                     )
         )
ORDER BY TC.[TABLE_NAME]

awadhendra tiwari wrote:

its urgent

I are Troll

UPDATE mytable 
SET field4 = 
(SELECT  RIGHT(mt.field1,CHARINDEX('_',mt.field1)-1)
FROM mytable mt
 WHERE mt.field1 = mytable.field1
)

SELECT * FROM mytable

AspDotNetDev wrote:

*I have had trouble with compression turned on. Once I turned off compression, my SQL installation went smoothly.

AspDotNetDev wrote:

*Perhaps you had an external drive (e.g., flash drive or USB hard drive) plugged in during the install? Maybe it's a network drive that has since been disconnected?

AspDotNetDev wrote:

If you don't have the permission to perform the install, have an administrator at your company install the software for you.

AspDotNetDev wrote:

Also, run chkdsk to ensure your hard drive does not have any errors on it.

loveangel888 wrote:

Where can i turn off the compression?

S<T>::f(U) // Out of line.