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 are the differences between left join and inner join in sql server?
What does it mean to normalize a database and why would you do it?
How to defragment table indexes?
Can you please differentiate between a primary key and a unique key?
How to delete all rows with truncate table statement in ms sql server?
What is the difference between dropping a database and taking a database offline?
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?
What is query processing?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is a cube? : sql server analysis services, ssas
What are the new features of sql server 2012 reporting service?
what is an extended stored procedure? : Sql server database administration
What is data source document?
What is transact-sql ddl trigger?
Where to find ntwdblib.dll version 2000.80.194.0?