Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Explain about builtinadministrator?


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

Post New Answer



More SQL Server Interview Questions

How to get the definition of a stored procedure back?

0 Answers  


optimization techinques

0 Answers   Wipro,


explain declarative management framework (dmf) in sql server 2008?

0 Answers  


How many types of subqueries are there in sql server?

0 Answers  


How to use subqueries with the in operators in ms sql server?

0 Answers  






Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  


How to convert character strings into numeric values?

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  


difference between truncate, delete aur drop?

2 Answers  


What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,


what is the difference between openrowset and openquery?

0 Answers  


How to rebuild the master database?

0 Answers  


Categories