Do you know what is replace and stuff function in sql server?
- 1 Answers
- 1118 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rohit Saxena
{"answers":[n "REPLACE: Replaces a specified number of occurrences of a specified string with another string.n ",n "STUFF: Modifies a string expression by inserting a specified string value into a specified position within the source string."]}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
Where can you add custom error messages to sql server?
What is a view in sql?
How to convert numeric expression data types using the cast() function?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the properties of the transaction?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
How to rebuild the master database?
Why should you use or avoid select * statements?
What is in place upgrade in sql server?
How to provide default values to function parameters?
Explain system functions or built-in functions? What are different types of system functions?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Explain “row_number()” in sql server with an example?
What are wait types?
