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 do I find the sql server database version?

534


Do you know what is similarity and difference between truncate and delete in sql?

579


Write a query for primary key constraint with identity key word?

581


what are different types of raid configurations? : Sql server database administration

490


How to find tables without indexes?

633






What are the different types of replication are there in sql server 2000?

565


What stored procedure can you use to display the current processes?

501


What is the default Port No on which SQL Server listens?

628


What is the function of sql server agent windows service?

539


How can sql injection be stopped? : sql server security

556


What are group functions in query statements in ms sql server?

557


Can you explain what is indexed view? How to create it?

530


What is a self join in sql server?

601


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1505


Explain the types of indexes.

643