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
How to generate create procedure script on an existing stored procedure?
Can we linked SharePoint to a SQL database?
what is hash nonclustered index
How to disconnect from a sql server using mssql_close()?
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 postgresql server?
Define right outer join?
Is null in sql server?
What is data file in computer?
Explain “row_number()” in sql server with an example?
What is the bookmark lookup and rid lookup?
Can sql servers link to other servers?
What do you understand by physical_only option in dbcc checkdb?
What is difference between unique and primary key?
Write a program using SQL queries to find a unique entry in a table.