Database

PIEBALDconsult wrote:

Ummmm... so how do you copy records between tables that have identity
columns?

jschell wrote:

I would use GUIDs.

jschell wrote:

used for every possible scenario

PIEBALDconsult wrote:

I'm pretty sure I didn't say they should.

jschell wrote:

I took that to mean that one should use GUID - always (implicit within "never").

Xiangyang Liu 刘向阳 wrote:

Thanks to myself

I are Troll

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