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

What is difference between delete and truncate commands?

696


What is the purpose of optimization?

723


What are the various editions of sql server 2017 that are available in the market?

672


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1753


Do you know what guidelines should be followed to help minimize deadlocks?

722






What is a user-defined function in the sql server and what is its advantage?

819


Tell me what are cursors and when they are useful?

703


What is model database in sql server?

779


What is multilevel indexing?

694


What is the process of normalising?

757


What is multi-statement table-value user-defined function?

724


What is BCP? When does it used in sql server 2012?

758


How to declare a cursor with "declare ... Cursor" in ms sql server?

741


How each E-R model constructs can be mapped to the relational model?

722


What are the lambda triggers?

656