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

What are the dis_advantages of stored procedures, triggers, indexes?

Explain features of analysis services?

What are the source of constraints?

Can we use having clause without group by?

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

What causes index fragmentation?

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

Explain what is meant by replication of database?

What are the different types of lock modes in sql server 2000?

What are different backups available in sql server?

How to create Clustered Primary Key to table?

Tell me about the approaches which you used to counter the DI problems.

For more SQL Server Interview Questions Click Here