Which data types generate inaccurate results if used with an = or <> compa

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

Question Posted / anjani kumar

0 Answers
1065 Views
I also Faced
E-Mail Answers

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

More SQL Server Interview Questions

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers Techno Solutions,

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers

How to generate create procedure script on an existing stored procedure?

0 Answers

* 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

Explain user defined views?

0 Answers

Why main is user defined function?

0 Answers

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers

What are constraints?

0 Answers

What are functions in the sql server?

0 Answers

What do you mean by stored techniques? How would we use it?