Interested to Buy Any Domain ? << Click Here >> for more details...
how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.
- 6 Answers
- 10209 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / samar
plz explain in brief,
if u can send me screen shots for process , it ll be good
for undetstandin
mail id: summer_sinha@yahoo.com
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Name few endpoints exposed by ssrs 2012?
How to create stored procedures with parameters in ms sql server?
Where can you find the error log information? : sql server database administration
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is trace flag in sql server?
Explain what is it unwise to create wide clustered index keys?
Explain the steps to use transact-sql cursor?
What are scalar functions in sql?
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?
What is the significance of master, tempdb and model databases?
Explain collation?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is ssl in sql server?
What is explicit cursors?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
