Answer: Space is an in-built Sql Server function which returns a string of the specified number of spaces.
Whatever the number we provide in space function,will generate space characters.In short we can say that,it is used for giving the spaces between characters.
For Example:
Select Space(5);
It will generate 5 space characters.
SELECT 'Vishal' + SPACE(1) + 'Neeraj';
Output:
Vishal Neeraj
Asked In: Many Interviews |
Alert Moderator