Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

inbuilt function : replicate, len, ltrim, rtrim and convert Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 2:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, February 08, 2014 9:45 PM
Points: 1, Visits: 46
can someone explain me why we use replicate in our query
and also len, ltrim, rtrim and convert with useful example
Post #1441030
Posted Wednesday, April 10, 2013 2:52 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:20 PM
Points: 22,475, Visits: 30,152
shahdipen727 (4/10/2013)
can someone explain me why we use replicate in our query
and also len, ltrim, rtrim and convert with useful example


Have you looked up in Books Online what these functions do? You should also find examples of how they are used there as well.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1441035
Posted Wednesday, April 10, 2013 3:50 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 10:55 AM
Points: 532, Visits: 984


I must have spent thirty seconds trying to scroll up and down to find the query the OP was talking about.
Post #1441056
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse