Explain what are the basic functions for master, msdb, model, tempdb databases?
No Answer is Posted For this Question
Be the First to Post Answer
Relational calculus is what type of language?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Explain the first normal form(1nf)?
What are the different types of collation sensitivity in sql server?
What is statement level trigger?
List out some of the requirements to set up a sql server failover cluster?
Accidentally i deleted my table. How can i get that table?
What are the different types of normalization?
* 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
How to find tables without indexes?
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?