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 many non clustered indexes there can be on table ?
How to disable a login name in ms sql server?
Can you explain different types of locks in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What’s the distinction between dropping a info and taking a info offline?
How to use user defined functions in expressions?
Explain having clause and where clause?
What is the query and subquery?
Who developed sql server?
What are the features of Embedded SQL
how to create “alternate row colour”?
What does asynchronous call backs means?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How can a database be repaired?