What are the types of backup and tell me the difference between full and differential backup?
4 12737I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
7 10514
Why Master database is required?
What are the recovery models for a database?
How do I debug a stored procedure in sql server?
What is a partitioned view?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to insert and update data into a table with "insert" and "update" statements?
What are the difference between “where” and “having” clause in sql server?
What are the differences between having and where clause.
What are the new features of sql server 2012 reporting service?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
What is order of B+tree?
Explain what is scheduled job and how to create it?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is rs.exe utility?
How to see existing views in ms sql server?