What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Following are some major differences between a stored procedure and user defined functions: UDF can be executed using the ďSELECTĒ clause while SPís can not be. UDF can not be used in XML FOR clause but SPís can b... 2007-10-25, 4970👍, 0💬
What is SQl injection
What is SQl injection ? It is a Form of attack on a database-driven Web site in which the attacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a databas... 2007-10-25, 4752👍, 0💬
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? If a table has multiple AFTER triggers, then you can specify which trigger should be executed first and which trigger should be executed last using the stored procedure sp_settriggerorder. All the other trig... 2007-10-25, 6433👍, 0💬
What are the different types of triggers in SQl SERVER 2000
What are the different types of triggers in SQl SERVER 2000 ? There are two types of triggers : INSTEAD OF triggers INSTEAD OF triggers fire in place of the triggering action. For example, if an INSTEAD OF UPDATE trigger exists on the Sales table and an UPDATE statement is executed against the Sales... 2007-10-25, 4421👍, 0💬
What is BCP utility in SQL SERVER
What is BCP utility in SQL SERVER ? BCP (Bulk Copy Program) is a command line utility by which you can import and export large amounts of data in and out of SQL SERVER database. Below is a sample which shows BCP in action. 2007-10-25, 5272👍, 0💬
What are the different types of replication supported by SQL SERVER
What are the different types of replication supported by SQL SERVER ? There are three types of replication supported by SQL SERVER Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The ... 2007-10-25, 4666👍, 0💬
What is the purpose of Replication
What is the purpose of Replication ? Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber. Publisher Database server that makes data available for replication is called as Publisher. Subscriber Database Serve... 2007-10-25, 5914👍, 0💬
What is DBCC
What is DBCC? DBCC (Database Consistency Checker Commands) is used to check logical and physical consistency of database structure.DBCC statements can fix and detect problems.They are grouped in to four categories Maintenance commands like DBCC DBREINDEX , DBCC DBREPAR etc , they are mainly used for... 2007-10-25, 4954👍, 0💬
What is ACID fundamental? What are transactions in SQL SERVER
What is ACID fundamental? What are transactions in SQL SERVER ? A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a t... 2007-10-25, 4587👍, 0💬
How can you raise custom errors from stored procedure
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement c... 2007-10-25, 5743👍, 0💬
What is the difference between UNION and UNION ALL SQL syntax
What is the difference between UNION and UNION ALL SQL syntax ? UNION SQL syntax is used to select information from two tables. But it selects only distinct records from both the table, while UNION ALL selects all records from both the tables. Note : Selected records should have same datatype or els... 2007-10-25, 4266👍, 0💬
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 4371👍, 0💬
What are advantages of SQL 2000 over SQl 7.0
What are advantages of SQL 2000 over SQl 7.0 ? User-Defined Functions: User-Defined Functions (UDFs) -- one or more Transact-SQL statements can be used to encapsulate code for reuse. Userdefined functions cannot make a permanent change to the data or modify database tables. UDF can change only local... 2007-10-25, 4297👍, 0💬
What are the different ways of moving data between databases in SQL Server
What are the different ways of moving data between databases in SQL Server? There are lots of option available; you have to choose your option depending upon your requirements. Some of the options you have are: BACKUP/RESTORE, detaching and attaching databases, replication, DTS, BCP, logshipping, IN... 2007-10-25, 4280👍, 0💬
What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 4343👍, 0💬
Can we suggest locking hints to SQL SERVER
Can we suggest locking hints to SQL SERVER ? We can give locking hints that helps you over ride default decision made by SQL Server. For instance, you can specify the ROWLOCK hint with your UPDATE statement to convince SQL Server to lock each row affected by that data modification. Whether it's prud... 2007-10-25, 4529👍, 0💬
What are the different locks in SQL SERVER
What are the different locks in SQL SERVER ? Depending on the transaction level six types of lock can be acquired on data Intent The intent lock shows the future intention of SQL Server's lock manager to acquire locks on a specific unit of data for a particular transaction. SQL Server uses intent lo... 2007-10-25, 4496👍, 0💬
What are different types of locks in SQL SERVER
What are different transaction levels in SQL SERVER? Transaction Isolation level decides how is one process isolated from other process.Using transaction levels you can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER READ COMMITTED The shared lock is held for the dur... 2007-10-25, 5222👍, 0💬
If locking is not implemented what issues can occur
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you do not implement locking properly in SQL SERVER. Lost Updates Lost updates occur if you let two transactions modify the same data at the same time, and the transaction that completes first is lost. You... 2007-10-25, 6197👍, 0💬
What is the difference between DELETE TABLE and TRUNCATE TABLE commands
What is the difference between DELETE TABLE and TRUNCATE TABLE commands? Following are difference between them ? DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table ... 2007-10-25, 4490👍, 0💬
What is RAID and how does it work
What is RAID and how does it work ? Redundant Array of Independent Disks (RAID) is a term used to describe the technique of improving data availability through the use of arrays of disks and various data-striping methodologies. Disk arrays are groups of disk drives that work together to achieve high... 2007-10-25, 4817👍, 0💬
When does page split occurs ?
What is fillfactor ? The 'fill factor' option specifies how full SQL Server will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows from the previous page to the new one. This operation is called page sp... 2007-10-25, 4566👍, 0💬
Can you explain the star schema for OLAP
What are fact tables and dimension tables in OLAP ? The dimensions and measures are physically represented by a star schema. Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key rel... 2007-10-25, 4608👍, 0💬
.NET INTERVIEW QUESTIONS - What is the difference between thread and process? A thread is a path of ...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
What Happens to Your Transactions When ERROR 1213 Occurred? - MySQL FAQs - Transaction Management: C...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...