 Related Questions Latest Answer : select column_list into new_table_name from old_table_name where false_condition(ex. 1!=1) ... Latest Answer : You can use Bulk copy program (BCP) to convert a data from row to text or text to row ... Latest Answer : In SQL Server, objects like tables, views, stored procedures and so on that occupy space are called data objects. ... Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical failure How to display the table data in XML format using SQL Server. Latest Answer : The only thing you have to do is to insert "for XML Auto" in your query and the result will be returned in XML format.Eg. Let there be a table with name tblABCNormally   Select * from tblABCFor XML Data   Select * from tblABC for XML Auto ... Read Answers (1) | Asked by : Yogesh Rajvanshi If you are doing website project, which one is used dataset or data reader? Why? Latest Answer : Data reader is used to fetch data from a databaseaccording to users condition.Data reader is used with the select statement.For Eg.to selecting a value from a database in our project, in c#.net we write,string s="Select * from employee";SqlCommand ... There is a problem in creating relationship between two tables using SQL Server Database.What are the requirements and data that should be had before creating table relationship. Latest Answer : The datatype of the both the columns used in relation must be the same ... Write an SQL query if you want to select the data from one block which intern reflects in another block? Latest Answer : Select *from(Select *from ) a ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1