The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio


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

Post New Answer

More SQL Server Interview Questions

What is oltp (online transaction processing)?

0 Answers  


Can we join two tables without primary key?

0 Answers  


What are the advantages dts has over bcp?

0 Answers  


How to display a past time in days, hours and minutes?

0 Answers  


Explain the types of indexes.

0 Answers   Accenture,






Can you move the resources after pausing the node? : sql server database administration

0 Answers  


How to find 6th highest salary from Employee table ?

10 Answers  


How can I create a new template for import ? : sql server management studio

0 Answers  


What is lock escalation?

1 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  


How do I make a resultset scrollable?

0 Answers  


How column data types are determined in a view?

0 Answers  


Categories