Interested to Buy Any Domain ? << Click Here >> for more details...
How would you Update the rows which are divisible by 10,
given a set of numbers in column?
- 3 Answers
- 11478 Views
- I also Faced
- E-Mail Answers
Answer Posted / picture12345
select * from TableName where ColumnName%10=0
| Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Do you know exporting and importing utility?
What are the advantages of policy management?
How to defragment indexes with alter index ... Reorganize?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What are page splits?
What is advantage data architect?
List the types of recovery model available in sql server?
What is the stored procedure?
What are cursors stored procedures and triggers?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
explain extended properties
What is user-defined functions? What are the types of user-defined functions that can be created?
Differentiate between a having clause and a where clause.
What is full outer join in sql server joins?
