sreddy_bond

 Profile Answers by sreddy_bond Questions by sreddy_bond

• May 9th, 2008

Rownum is the id which is assigned to recored, by the time of record set selected (executed).Rowid is, the id which is assigned physically to each record in table.RegadsSarele

Bill

• Nov 10th, 2006

   sql dbname < script_filename > output.out 2>&1

Answer Question  Select Best Answer

psingla

 Profile Answers by psingla Questions by psingla

• Mar 17th, 2010

Hints are instructions given by the developer in the query to use a particular type of exectuion plan.Whenever a query is written then sql comipler creates n number of execution plans and opt for the ...

Bobby

• Oct 13th, 2007

Hints are options or strategies specified for enforcement by the SQL Server 2005 query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query.

Answer Question  Select Best Answer

bharathi

• Jul 12th, 2007

Comparing to SQL Server 2000 SQL Server 2005 have more features1. Reporting?services are available 2. .Net integration3.?HTTP protocols

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 26th, 2007

There are plenty of enhancements added since Sql Server 2000. Every feature cannot be explined here. Better you refer Sql Server 2005 Books Online for detailed answer. Also Refer http://www.microsoft....

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

How can we rename a Database with query?

Priya Lakshmi

 Profile Answers by Priya Lakshmi Questions by Priya Lakshmi

• May 25th, 2011

Sp_rename 'old_db_name','new_db_name';

dinu_26

 Profile Answers by dinu_26 Questions by dinu_26

• Nov 11th, 2008

Syntax of renaming the database:sp_renamedb old_database name new_database nameEg:? name of the database is tree. Now if you need to change the database as three. So the query for changing the database as follows:sp_renamedb tree three

Answer Question  Select Best Answer

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Use IsNULL(,value) .If query return null ,it will replace by  value.

Pandian S

 Profile Answers by Pandian S Questions by Pandian S

• Mar 5th, 2007

Hi1. Without any Null Value for Column1:Select * From Table1 Where Column1 Is Not Null2. Instead of Null values it returns as '0':Select IsNull(Column1,0) Column1,* From Table1

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

jayaprakash.raman  

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Member Since Apr-2007 | Apr 24th, 2007

---

Please refer that here we are discussing about Sql Server only. There is no function named 'Translate' in Sql Server. 'Translate' function exists in Oracle for translating a single character to some other character.

Replace fucntion in Sql server is used to replace a string as well as character to another string or character. No need to have a seperate function like Transalate in Oracle:

Find below the examples to get the clear idea:

Ex 1: Sql Server replace function similar to Oracle Replace function

Declare @Str varchar(100)

set @Str='India is my country'

print @Str

print replace(@Str,'India','Pakistan')

Result

India is my country

Pakistan is my country

Ex 1: Sql Server replace function similar to Oracle Translate Replace function

Declare @Str varchar(100)

set @Str='Think You'

print @Str

print replace(@Str,'i','a')
Result

Think You

Thank You

Note: Please try to post Sql server questions only here. Ther is a seperate section available for Oracle. If we mix both, it will confuse the people who are specializing their skill in particular area. Thank you.

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Please refer that here we are discussing about Sql Server only. There is no function named 'Translate' in Sql Server. 'Translate' function exists in Oracle for translating a single cha...

aruna

• Apr 3rd, 2006

Translate is a character wise functionwhere as replace is a string wise

Improve Answer

psingla

 Profile Answers by psingla Questions by psingla

• Mar 8th, 2010

primary key:is a key on ( 1  or group of columns) used to identify a record uniquely.builds clustered index automaticallyAlternate key:is a key which is a unique key but not a primary key.no...

khurram

• Aug 3rd, 2006

aggregate fact tables have two types of keys-composite key-serrogate key (system generated key)So aggregate-key is a primary key

Answer Question  Select Best Answer

psingla

 Profile Answers by psingla Questions by psingla

• Mar 17th, 2010

Group by: It clubs all the similar rows and display only the distinct data so here clubing and displaying distinct data is an overhead.Order by: It sorts the data either in ascending order or in desending order as specified in the query.  Sorting the data is an overhead.

Shehzad

• Aug 22nd, 2006

Group by class will have to group all the data returing from the query in our specifed groups... so it is definitly an overhead from execution point of view... imagine that the number of rows returned...

Answer Question  Select Best Answer

genie_cool

• Jun 6th, 2007

use TableLocks or RowLocks to prevent the other user from modifying the data when the previous user is using the same data.

vmandviya

 Profile Answers by vmandviya Questions by vmandviya

• Feb 5th, 2007

See if two user are updating same time at same time it will affect one by one!! it means 1st user changes will accept then 2nd user changes it iwll accept

Answer Question  Select Best Answer

yatinhatkar

 Profile Answers by yatinhatkar Questions by yatinhatkar

• Jun 18th, 2009

Data objects are basic runtime entities.

Rekha

• Jan 15th, 2007

Stored procedures,views,tables,database diagrams are the data objects

Answer Question  Select Best Answer

mbhsye786

 Profile Answers by mbhsye786 Questions by mbhsye786

• Jan 13th, 2014

Your answer is incorrect
Sql Server runs only on windows platform and is hardware dependent
where as
Oracle runs in any platform and hardware independent such as can run on unix and windows.

Sivaram

• Dec 31st, 2006

Basic DifferenceSql Server:Runs only on windows platform,Hardware independentoracle:Runs in any platform and hardware dependent..

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

anjan_maity

 Profile Answers by anjan_maity Questions by anjan_maity

• Aug 7th, 2008

Deadlock occurs when two or more processes have?lock objects and each process is trying to acquire a lock on an object that the other processes have previously locked.? Let p1 process? has an exclu...

rup

• Jan 30th, 2007

Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the ...

Answer Question  Select Best Answer

pavalisofthard

 Profile Answers by pavalisofthard Questions by pavalisofthard

• Oct 31st, 2008

Cursor is used to eliminate the repeated(duplicate) records in a table.

anupama

• Feb 22nd, 2007

In Embedded SQl we can get

Answer Question  Select Best Answer

jjvetri

 Profile Answers by jjvetri Questions by jjvetri

• May 8th, 2009

CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000

gvs

 Profile Answers by gvs Questions by gvs

• Jan 3rd, 2008

Using Pivot Option in MS SQL Server 2005.

Answer Question  Select Best Answer

cybersavvy

 Profile Answers by cybersavvy Questions by cybersavvy

• Feb 19th, 2009

Clustered Index

Badri

• Jun 18th, 2007

Clustered index

Answer Question  Select Best Answer

kirangiet

 Profile Answers by kirangiet Questions by kirangiet

• Aug 17th, 2010

Cluster Index should be created on unique columns. By default it will be created on Primary Key. We can change it to any other column. Note: We can create Clustered Key on Non-Unique column also....

RAGHUKANTH

• Aug 21st, 2007

Yes, coming to your answer clustered index is used and applied only and primary keysFor example if a table student is created consider here in this table student id is the primary key so clustered ind...

Answer Question  Select Best Answer

askvenki

 Profile Answers by askvenki Questions by askvenki

• Aug 13th, 2007

It is to know the no of rows feched from cursorIt is used in situations likeWe have to do the modifications up to five rowsTheir is some situations to print up to no of rows fetched from cursorIn pl/sql table it is used like an array index to store values

waqarali

 Profile Answers by waqarali Questions by waqarali

• Jul 30th, 2007

In the stored procedures to the total counts of the rows affected by the query.

Answer Question  Select Best Answer