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
- 1 Answers
- 3389 Views
- I also Faced
- E-Mail Answers
Answer / kumarasamy
use trigger and string function
u will get it
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you mean by subquery?
What is the difference between a local and a global variable?
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.
What is the tcp/ip port on which sql server runs?
What languages bi uses to achieve the goal?
What is data block and how to define data block size?
Describe in brief databases and sql server databases architecture.
Tell me what do we need queues in sql service broker?
Write a query to get all details of employee who has maximum salary from employee table
Give a example to search fr a string in all stored procedure in sql server.
What is multi-statement table-value user-defined function?
internal language used in sql server 2000?
-
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)
