REPLICATE, Sql Server - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

REPLICATE

Language: Layout:

CREATE TABLE MyTable (
    Col1 NVARCHAR(200),
    Col2 NVARCHAR(100),
    Col3 NVARCHAR(200),
    Col4 NVARCHAR(50)
    );
    INSERT INTO MyTable VALUES 
    (NULL, NULL, NULL, NULL), 
    (N'ABC', N'DEF', NULL, NULL),
    (N'', N'', N'', N''),
    (N'foo', N'bar', NULL, NULL);

UPDATE MyTABLE 
        SET Col1 = (SELECT CASE WHEN (Col1 IS NULL) OR (Col1 = '') THEN 
                        REPLICATE(' ', COL_LENGTH('MyTable', 'Col1')/2) 
                        ELSE Col1 + REPLICATE(' ', (COL_LENGTH('MyTable', 'Col1')/2)- LEN(Col1)) END),
        Col2 = (SELECT CASE WHEN (Col2 IS NULL) OR (Col2 = '') THEN 
                        REPLICATE(' ', COL_LENGTH('MyTable', 'Col2')/2) 
                        ELSE Col2 + REPLICATE(' ', (COL_LENGTH('MyTable', 'Col2')/2)- LEN(Col2)) END),                
        Col3 = (SELECT CASE WHEN (Col3 IS NULL) OR (Col3 = '') THEN 
                        REPLICATE(' ', COL_LENGTH('MyTable', 'Col1')/2) 
                        ELSE Col3 + REPLICATE(' ', (COL_LENGTH('MyTable', 'Col3')/2)- LEN(Col3)) END), 
        Col4 = (SELECT CASE WHEN (Col4 IS NULL) OR (Col4 = '') THEN 
                        REPLICATE(' ', COL_LENGTH('MyTable', 'Col4')/2) 
                        ELSE Col4 + REPLICATE(' ', (COL_LENGTH('MyTable', 'Col4')/2)- LEN(Col4)) END);
                        
SELECT *
FROM MyTable;

View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 8, absolute service time: 0,17 sec

fork mode | history

λ

                                      .NET NoSQL database for rapid development