Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?
Latest Answer: Comparing to SQL Server 2000 SQL Server 2005 have more features1. Reporting services are available 2. .Net integration3. HTTP protocols ...
Latest Answer: It is used to view the table structure. ...
Latest Answer: #temp table: the table define with single '#' called local temp table, it can be used only a single project of a databse for exemple if we are making a new query in query builder and declare a #temp table then this temp table only can be used for that ...
Latest Answer: CREATE PROCEDURE [usp_delete_Pataint_master] (@PataintID [int], @BranchID [int] )AS BEGIN SET NOCOUNT ON BEGIN TRAN DELETE [dbo].[Pataint_master] WHERE ([BranchID] = @BranchID ...
What is the difference between Inner join and full outer join in terms of the Number of rows returned?
Latest Answer: Hi RegardsFill factor is the term associated with indexes actually with clustured indexesWhenever a clustured index is created sql server physically orders data in basis of the clustured column. As you must be aware that the data is sql server is stored ...
Latest Answer: the act of joining together as one orPutting two or more data files together ...
Latest Answer: To take backup of the Access database, follow the steps:Alt+F --> Manage --> Backup Database -->Specify the path for the backup ...
Latest Answer: Hi RegardsIts very simple. I presume that you are aware of creating tables in SQL SERVER. If you want a default value in uniqueidentifier column. Just open the table in design view in enterprices value at highlight the column at the bottom you will ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 Next >>
Go Top
