--STEP : 1
SELECT * INTO JAHNAVI FROM
(select ROW_NUMBER() OVER (ORDER BY name) As SrNo, name ,'' AS 'Column Name','' AS 'Data Type' ,'' AS 'Maximum Length' from sysobjects where xtype = 'u'
UNION ALL
SELECT '' As SrNo, table_name + '$$$$', column_name 'Column Name', data_type 'Data Type', CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE table_name in (select name from sysobjects where xtype = 'u')
)A
ORDER BY A.NAME
--STEP : 2
UPDATE JAHNAVI
SET NAME = ''
WHERE NAME LIKE '%$$$$'
--STEP : 3
SELECT * FROM JAHNAVI
No comments:
Post a Comment