We have used a Stored Procedure having large code in it. If we try to Alter the SP again then the entire code seems to be SCRAMBLED - Why ?

Deepak

• Jan 1st, 2007

Index is used for the fast retrieval of data from the table. there are two types of indecs Clustered and Non clustered. Cluster index is created on primary key and it can be only on per table where as...

Phaneesh

• Feb 1st, 2006

Indexes are useful for maintaining unique values in a column, since the database can easily search the index to see if an incoming value already exists. Primary keys are always indexed for this r...

Answer Question  Select Best Answer

Shayer

• Dec 20th, 2006

Extended Stored procedure is a function in a DLL that can be called from T-SQL in a similar manner as we call normal stored procedure.Can accept parameter and return value as well.

Rajesh

• Dec 15th, 2006

The Microsoft Extended Stored Procedure API provides a server-based application programming interface (API) for extending Microsoft SQL Server functionality. The API consists of C and C++ functions an...

Answer Question  Select Best Answer

Ranjit

 Profile Answers by Ranjit Questions by Ranjit

• Dec 7th, 2006

Here is the Top 30 features of Sql 2005http://www.microsoft.com/sql/prodinfo/features/top30features.mspx

nandakishore

• Oct 18th, 2006

There are lot of independent and powerful features have been implemented in SQL Server 2005,Some of these features are avaiable in other databases but some are specific for SQL Server for example...

Answer Question  Select Best Answer

Ranjit

 Profile Answers by Ranjit Questions by Ranjit

• Dec 7th, 2006

If you have a stored procedure that looks like this:  CREATE PROCEDURE myProc AS BEGIN     SET NOCOUNT ON      SELECT columns FROM table1 &n...

reshmi

• Nov 8th, 2006

Yes.. stored procedure can return multiple recordsets.

Answer Question  Select Best Answer

Ranjit

 Profile Answers by Ranjit Questions by Ranjit

• Dec 7th, 2006

http://msdn2.microsoft.com/en-us/library/ms175890.aspx

Jacx

• Oct 19th, 2006

The database can be modified using ALTER DATABASE with the syntaxALTER DATABASE database { ADD FILE < filespec > [ ,...n ] [ TO FILEGROUP filegroup_name ] | ADD LOG FILE < filespec > [ ,.....

Answer Question  Select Best Answer

Roopesh Nanaware

• Nov 3rd, 2006

CREATE PROCEDURE [usp_delete_Pataint_master] (@PataintID [int], @BranchID [int] )AS BEGIN SET NOCOUNT ON  BEGIN TRAN    DELETE [dbo].[P...

Baskar

• Aug 22nd, 2006

Rollback is used to Return the Qurey Statement of Execution After Begin StatementsEx : Begin Tran  Select * From Employee Order by Name  Delete From Employee Select * From Employee...

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

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

Raj Sekhar

• Aug 17th, 2006

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

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

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

Yogesh Srivastava

• Jun 27th, 2006

Hi Your can try thisSELECT? CONVERT(varchar, GETDATE(), 103)In this example the GETDATE() will return your sql server?system date.and? the CONVERT is used to convert the date into the desired fomat...

rick

• Jun 24th, 2006

CREATE TABLE mytable ([Date] SMALLDATETIME)

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

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

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