Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

Does windows server 2016 come with sql server?

0 Answers  

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

How to download and install microsoft sql server management studio express?

0 Answers  

Differences between Standby Vs No recovery?

2 Answers   Wipro,

What is resultset concur_updatable?

0 Answers  




1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

What are the 10 characteristics of data quality?

0 Answers  

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

select empid empname from employee What is the result for the about query?

4 Answers  

What is SQL Server?

0 Answers   Atos Origin,

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories