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

How to generate create procedure script on an existing stored procedure?

1002


Can we linked SharePoint to a SQL database?

1015


what is hash nonclustered index

958


How to disconnect from a sql server using mssql_close()?

1096


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2098


What is postgresql server?

990


Define right outer join?

969


Is null in sql server?

978


What is data file in computer?

935


Explain “row_number()” in sql server with an example?

993


What is the bookmark lookup and rid lookup?

992


Can sql servers link to other servers?

1077


What do you understand by physical_only option in dbcc checkdb?

973


What is difference between unique and primary key?

897


Write a program using SQL queries to find a unique entry in a table.

981