Abhinav Jain

• Nov 19th, 2007

User Identification: In virtue of Data base server Identification tries to find whether you are registered user in the database or not. It applies to whole database server. Authentication: It ap...

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

Chetna

• Oct 16th, 2007

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties > Por number, both on client and the server.

Answer Question  Select Best Answer

Chetna

• Oct 16th, 2007

If a Trigger is having Insert/Update/Delete statement of a table which is also having a trigger defined on it for Insert/Update/Delete, then Trigger1 would cause Trigger2 to get fired when a data Manipulation has occured. This is called nested trigger.

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

dheeruchakri

 Profile Answers by dheeruchakri Questions by dheeruchakri

• Oct 10th, 2007

Create Procedure TestExportasBeginxp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'EndAll the Best.- Dheeraj.

Dheeraj Chakravarthy

• Oct 10th, 2007

Create Procedure TestExportasBeginxp_cmdshell 'bcp "SELECT * from YourDatabase.dbo.YourTable" QueryOut d:Temptest.xls -S alexissqlsrv01 -U dpi -P Value*() -c -T'EndAll the Best.- Dheeraj.

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

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

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

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

Genie_Cool

• Jun 1st, 2007

If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the pr...

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

In dynamic SQL method 4 in  queries(select ) there are variable number of column and bind variable . Other word we can say that until run time we don't how many bind varible there.   Exemple...

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

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy"...

sm

• Nov 9th, 2005

In database table design we are providing Primary key and Foreign keys.And according to primary and Foreign keys tables are functionaly dependent on each other.

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

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Examples for Analytical functions in Sql Server 2005:AVG, COMPUTE, DENSE RANK, NTile, Over, RANK, Row Number, STDEV, SUM, VAR, VARP, WITH ROLLUP

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

Analytical Function:-  return the infornation that about the relative possition of record (ROW_NUMBER,Rank,DENSE_RANK) and  allow to campare with succesor and precedessors when the...

Answer Question  Select Best Answer

Deepek Bhandari

• Mar 30th, 2007

#temp table: the table define with single '#' called local temp table, it can be used only a single project of a databse for exemple if we are making a new query in query builder and declare a #temp t...

Dipti Bhardwaj

• Feb 20th, 2007

Hi Rakesh,Can you guide me what do u mean by limited data  in case of table variables. I read it so many places regading using table variables when data is limited. But not sure the maximim capacity of data could be handled by table variables. Regards, Dipti

Answer Question  Select Best Answer