Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is an expensive query?

913


How to get all stored procedures in sql server?

980


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

928


How to configure and test odbc dsn settings?

1139


What is the use of =,==,=== operators?

990


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

980


What is a join in sql? What are the types of joins?

1073


What is difference between index and primary key?

1084


Give the query of getting last two records from the table in SQL SERVER?

928


Working with TLogs

1822


Determine when an index is appropriate?

1055


How to see the event list of an existing trigger using sys.trigger_events?

1058


How do you Implement SSIS Packages in your Project?

1907


What happens when converting big values to integers?

985


What is a fill factor?

1072