sql server syntax to add "!" sign to "name" field of "

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

Question Posted / yashu

sql server syntax to add "!" sign to "name" field of "employee" tabl..

Answer / kumarasamy

use trigger and string function
u will get it

Is This Answer Correct ?

0 Yes

0 No

More SQL Server Interview Questions

In what sequence sql statement is processed?

How to use "begin ... End" statement structures in ms sql server?

Explain syntax for disabling triggers?

what are three different authentications to connect linked servers?

What are the types of dml?

How to concatenate two character strings together?

What are primary keys and foreign keys?

how can we know that how many users are connected in perticuler server??????

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

What will you do If the low Performance occurs?

What is the most common trace flags used with sql server?

For more SQL Server Interview Questions Click Here