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 / kumarasamy
use trigger and string function
u will get it
| Is This Answer Correct ? | 0 Yes | 0 No |
How to rebuild indexes with alter index ... Rebuild?
What stored procedure would you use to view lock information?
Explain what is cte (common table expression)?
Can you name some of the dml commands in sql?
How many databases instances are there in sql server 2000?
What is BCNF? How is it better than 2NF & 3NF?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Delete duplicate rows without using rowid.
What is the difference between functions and stored procedures?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Explain what is sql server english query?
What are the types of table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)