How and why use sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is advantage data architect?
How to provide values to user defined function parameters?
How to delete a login name in ms sql server?
How get current date in SQL server 2000
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
what is a cursor and what is its use?
what are constraints? Explain different types of constraints? : Sql server database administration
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>
can you any body tell me why are go for the rebuild the master database.what is the reason?
* 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 can we get count of the number of records in a table?