-
How we can make sure that the SQL query does not return NULL values?
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
-
What is the difference between "translate" and "replace"?
Read Best Answer
Editorial / Best Answer
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')
ResultIndia is my country
Pakistan is my country
Ex 1: Sql Server replace function similar to Oracle Translate Replace functionDeclare @Str varchar(100)
set @Str='Think You'
print @Str
print replace(@Str,'i','a')
ResultThink 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
- 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
-
Difference between Primary Key and Aggregate Key?
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
-
Why can a "group by" or "order by" clause be expensive to process?
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...
-
How is a database table managed, if it is being modified by two or more user's simultaniously?
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
- 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
-
What are data objects?
Rekha
- Jan 15th, 2007
Stored procedures,views,tables,database diagrams are the data objects
-
What is the difference between sql server,database server and oracle server?
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..
-
-
Explain about Dead-locks in Sql Server database
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 ...
-
Where can i get more information on SQL Server cursors? please help...
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
-
How to change rows into column and columns in to rows using sql query in MSSQL?
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
-
Which index is created with primary key linear indexbinary indexclustered indexnon clustered index
Badri
- Jun 18th, 2007
Clustered index
-
Explain real time situation where you would use clustered and Non-clustered Indexes?
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...
-
Where do we use @@Rowcount
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
- Jul 30th, 2007
In the stored procedures to the total counts of the rows affected by the query.
-
What is the pivot operator in MS SQL Server2005? What is the use of it and how do we use it
neel_desai
- Oct 11th, 2008
You can use the PIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expressio...
Mitul Bahl
- Sep 24th, 2007
The PIVOT operator rotates rows into columns, optionally performing aggregations or other mathematical calculations along the way. It widens the input table expression based on a given pivot column an...
-
How do I lock a column
How do I lock a column, once records are entered into the table they can not be edited. Also how can I lock the field where only certain values are accepted?
binita007
- Dec 21st, 2010
For this purpose, Views are there in SQL Server.You can Create a view by leaving the column you need to restrictUser can edit all the fields in the view except the one you restrict .Binita.
-
How to create table with same strecture of the existing table in same data base in sql server2000
ramakrishnasri
- Dec 6th, 2007
Hai,here is the example for ypour qustionselect * into emp1 from emp where 1=9execute this u can have the structure of the new table as old with out the data in the new tablei hope it will solve your problem
-
How to find the list of system databases in a SQL Instance.
-
Creating SQL Server GUID
Question: Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure
anjan_maity
- Aug 7th, 2008
Create a out parameter.Set?value with NewId() which return a guid.then insert it into a table.
sutanu_halder
- Dec 14th, 2007
GUIDs are created by the newid() function. If the default of the primary key is set to NewID(),a new GUID is generated for any new row. In addition, the newid() function may be declared within an inse...
-
Data Reader or Dataset
If you are doing website project, which one is used dataset or data reader? Why?
kirangiet
- Aug 17th, 2010
There is no hard and fast rule like if it is a Web Site project we have to use Data Reader/ Dataset. Its depends on requirement. We can use both of them. We need to understand the pros and cons of bot...
sreyas kvm
- Feb 3rd, 2008
Data reader is used to fetch data from a databaseaccording to users condition.Data reader is used with the select statement.For Eg.to selecting a value from a database in our project, in c#.net w...
SQL Server Interview Questions
Read Best Answer
Ans