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

Where views are stored in sql server?

0 Answers  

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

What is filestream?

0 Answers  

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  




how can i store resumes in database?

3 Answers   HCL,

Explain multiserver query

0 Answers  

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

Explain difference between control flow and data flow?

0 Answers  

What is dknf in normalization form?

0 Answers  

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

For more SQL Server Interview Questions Click Here
Categories