What are the challenges you have faced while using stored procedure?

Genie_Cool

• Jun 4th, 2007

Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)Dirty reads: Reading the data that is actually read by Trans...

Answer Question  Select Best Answer

sahu

 Profile Answers by sahu Questions by sahu

• Jan 28th, 2006

Ans:Database returns an error message when a constraint is violated.Differnet type of constrains;1.Domain Constraints:A Domain constraint deals with one or more columns2.Entity Constraints3.Referentia...

Answer Question  Select Best Answer

Nirav

• Jul 25th, 2006

You can use Bulk copy program (BCP) to  convert a data from row to text or text to row

Answer Question  Select Best Answer

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

Create [shared/public] database link connect To identified by using Any problem Don't hesitate write to rahultripathi@myway.com

Answer Question  Select Best Answer

Raj Sekhar

• Aug 17th, 2006

Trigger are two types:1) Insteadof trigger2) After trigger

Answer Question  Select Best Answer

Ritesh P. Medhe

• Sep 19th, 2006

I Think the question is not well formed.. Please Elaborate

Answer Question  Select Best Answer

harshaa

 Profile Answers by harshaa Questions by harshaa

• Aug 7th, 2006

The act of joining together as one orPutting two or more data files together

Answer Question  Select Best Answer

teju

• Nov 5th, 2007

You have to connect your database first than you can open asly.....

Answer Question  Select Best Answer

suji

 Profile Answers by suji Questions by suji

• Nov 6th, 2011

Here is how you can use rollback in any of the SQL Server versions. works in both SQL Server 2000 and later versions. "sql Begin tran insert into table values or updates rollb...

Answer Question  Select Best Answer

debasis.yours

 Profile Answers by debasis.yours Questions by debasis.yours

• Dec 14th, 2007

Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy...

Answer Question  Select Best Answer

tiras

• Oct 12th, 2005

1. Optimise DB performance

shantinath patil

• Oct 8th, 2005

What is the use of ANALYZing the tables?

Answer Question  Select Best Answer

Mai Nguyen

• Apr 17th, 2006

 A transaction is a group of operations combined into a logical unit of work.  Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system BEGIN TrnasactionCommit Transaction

geekist

 Profile Answers by geekist Questions by geekist

• Oct 24th, 2005

Transactions are an atomic piece of instructions in SQL which have to be executed all or none.The word atomic signifies the all or none character of a transaction.

Answer Question  Select Best Answer

bugeye

 Profile Answers by bugeye Questions by bugeye

• Mar 14th, 2008

Go to your last good full backup.   Restore to another db using the MOVE command.

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 23rd, 2006

SQL*Loader is strictly an ORACLE product.  Most of not all vendors provide some kind of utility to load tables from flat files. It's not a question of comparison; you can't use SQL Loader in DB2,...

Ramesh

• Feb 22nd, 2006

SQL*Loader is capable of loading from data multiple files in one session.

Answer Question  Select Best Answer

Ritesh Medhe

• Sep 19th, 2006

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...

MikeroSoft

 Profile Answers by MikeroSoft Questions by MikeroSoft

• Jul 30th, 2006

Question is not well formed :Although the IDENTITY property automates row numbering within one table, separate tables, each with its own identifier column, can generate the same values. This is becaus...

Answer Question  Select Best Answer

Ritesh P. Medhe

• Sep 19th, 2006

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 yo...

mvkr

• Aug 29th, 2006

When you create a clustered index, the data in the table is stored in the data pages of the database according to the order of the values in the indexed is known as fill factor

Answer Question  Select Best Answer

vishalparate

 Profile Answers by vishalparate Questions by vishalparate

• Mar 30th, 2010

By using xp_sendmail store procedure we can do this but my problem is what parameter needs to be pass to this store procedure if I want to send mail from my local machine to another user, bcos&nb...

Answer Question  Select Best Answer

srikanth tirunagari

• May 25th, 2007

1) perform a tail log backup.2) restore wednesday's File 3 backup with no recovery3) restore all hourly transaction log backups in sequence taken after 8 pm on wednesday with no recovery4) finally restore the tail log backup with recovery

Answer Question  Select Best Answer

ex. Smith,John,India

Chetna

• Oct 16th, 2007

Save the query results to .csv file.

Answer Question  Select Best Answer