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



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

Can we use custom code in ssrs?

1 Answers  


How to create an index on a view?

1 Answers  


Explain full-text query in sql server?

1 Answers  


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1 Answers  


What is index, cluster index and nonclustered index?

1 Answers  


What is a Join in SQL Server?

3 Answers  


CREATE a table from another table

2 Answers  


What is the server name in sql server?

1 Answers  


How many types of Outer Joins?What are they?

1 Answers  


How to provide default values to stored procedure parameters?

1 Answers  


What do you mean by 'normalization'?

1 Answers   Ernst Young, Thomson Reuters,


what authentication modes does sql server support? : Sql server database administration

1 Answers  


Categories