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
Answer Posted / kumarasamy
use trigger and string function
u will get it
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an expensive query?
How to get all stored procedures in sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How to configure and test odbc dsn settings?
What is the use of =,==,=== operators?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is a join in sql? What are the types of joins?
What is difference between index and primary key?
Give the query of getting last two records from the table in SQL SERVER?
Working with TLogs
Determine when an index is appropriate?
How to see the event list of an existing trigger using sys.trigger_events?
How do you Implement SSIS Packages in your Project?
What happens when converting big values to integers?
What is a fill factor?