What are the difficulties faced in cube development? : sql server analysis services, ssas
No Answer is Posted For this Question
Be the First to Post Answer
How is table type constraint applied to a table?
What are the parts of a function?
* 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
Is it possible in sql table to have more than one foreign key?
which backup strategy you are following at ur company
What is user-defined multi-statement table-valued function?
What is local temp table?
Write a SQL queries on Self Join and Inner Join.
How to create user messages with print statements in ms sql server?
How to create new tables with "select ... Into" statements in ms sql server?
What are the advantages of using stored procedures in sql server?
List some case manipulation functions in sql?