Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
what are the problems that can occur if you do not implement locking properly in sql serverthe problems that occur if you do not implement locking
what are different transaction levels in sql serverthe transaction isolation level decides how is the one process isolated from theother process
what are the different locks in sql serverdepending on the transaction level there are six types of lock that can be acquired on data -1intentthe
what is lock escalationthe lock escalation is the process of converting of the low level locks such as row locks page locks into the higher level
what are advantages of sql 2000 over sql 701user-defined functions the user-defined functions udfs -- one or moretransact-sql statements may be used
how can you raise custom errors from stored procedurethe raiserror statements are used to produce an ad hoc error message or to retrieve acustom
what is acid fundamental what are transactions in sql serverthe transaction is a sequence of operations performed as a single logical unit of workthe
what are the different types of replication supported by sql serverthere are 3 types of replication supported by sql server which are shown
what are the different types of triggers in sqlthere are 2 types of triggers in the sql server 2000 -1 instead of triggersthe instead of triggers
what is sql injectionthis is a form of attack on the database-driven web site in which the attacker executes the unauthorized sql commands by
what is the difference between stored procedure sp and user defined function udfsome of major differences between a stored procedure and user defined
what is umlthe unified modeling language uml is a graphical language for documenting specifying visualizing constructing and the artifacts of
how many types of diagrams are there in umlthere are nine types of diagrams in the uml as shown below-1use case diagramthe use case diagram describe
what are advantages of using umlas the name suggests the unified modeling language the modeling has been around for years not only in the software
how can we load multiple tables in a dataset objcommandcommandtext table1 objdataadapterfillobjdataset table1 objcommandcommandtext table2
what is the difference between dataset and datareaderthe major differences between dataset and datareader are as follows-1the dataset is a
what is basic use of dataviewthe dataview represents the whole table or can be small parts of rows depending on some criteria it is the best used for
what are the steps involved to fill a dataset the sample code is shown belowprivate sub loaddatadim strconnectionstring as stringstrconnectionstring
the adonet gives the sqlcommand object which gives the functionality of executing the stored procedurescreate procedure selectbyemployee firstname
how can we connect to microsoft access foxpro oracle etc the microsoft provides systemdataoledb namespace to communicate with the databases such as
what are the various objects in datasetthe dataset has a collection of datatable object inside the tables collection every datatable object have
what is dataset object the dataset gives the basis for the disconnected storage and manipulation of the relational data we fill it from the data
what are basic methods of data adapterthe three most commonly used methods of dataadapter are as follows-1fill - it executes the selectcommand to
what is the use of data adapterthe data adapter are the objects that connect one or more command objects to a dataset object they give logic that
what are the methods provided by the command objectthe command objects used to connect the connection object to the datareader or the dataset the