Latest Answer: views,indexes,stored procedures,user-defined functions and triggers ...
Latest Answer: The binary datatype is used for storing the images in the database.the non binary datatypes are integer,varchar etc ...
Latest Answer: http://msdn2.microsoft.com/en-us/library/ms175890.aspx ...
Latest Answer: If you have a stored procedure that looks like this: CREATE PROCEDURE myProc AS BEGIN SET NOCOUNT ON SELECT columns FROM table1 SELECT columns FROM table2 ...
Latest Answer: Here is the Top 30 features of Sql 2005http://www.microsoft.com/sql/prodinfo/features/top30features.mspx ...
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: Therefore sp_columns dataloader.rescomps will display column names and their descriptions. ...
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 ...
View page << Previous 1 2 3 4 [5] 6 7 8 9 10 Next >>
Go Top
