sql server syntax to add "!" sign to "name" field of
"employee" table in a manner that all names have the same
lenght of 20 characters

Answer Posted / kumarasamy

use trigger and string function
u will get it

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can group functions be mixed with non-group selection fields in ms sql server?

540


What do you understand by mirroring and mention the advantages of the mirroring?

577


Can we write trigger for view?

551


Explain about Joins?

603


Explain cursor as data base object?

574






What is trigger in salesforce?

493


How to change the password of a login name in ms sql server?

559


How to perform key word search in tables?

527


What is the difference between grant and with grant while giving permissions to the user?

506


What is difference between equi join and inner join?

482


What are the extra roles available in msdb? : sql server security

637


How to query multiple tables jointly?

556


What is optimization and its types?

534


What are data regions?

90


How to remove duplicate rows from table except one?

568