1.what are diff types of joins , and explain diff between cross join and full ou

1.what are diff types of joins , and explain diff between cross join and full outer join
2.diff types of views
3. Diff types of index
4. What is diff b/w stores procedure and function procedure
5.diff between double and int in SQL
6.diff between char and varchar in SQL.
7.Oracle or SQL whice you will preferred and why.

Question Posted / krishna

0 Answers
1664 Views
Aptroid, I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers C3I, eSoft, iPRO Solutions, Wipro,

What is public role in sql server?

0 Answers

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers

What are the types of model in sql server and explain

2 Answers TCS,

What is efficiency data?

0 Answers

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers 247Customer,

How to assign null values to variables or columns?

0 Answers

What are the different types of stored procedures?

0 Answers

Different Types of Functions ?

2 Answers Satyam,

* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2

0 Answers

What is the library index called?

0 Answers

What are the main sources of data?

0 Answers

For more SQL Server Interview Questions Click Here