What is the difference between having clause and where clause in sql server?


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

Post New Answer

More SQL Server Interview Questions

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  


What is a field name?

0 Answers  


What does it mean to be in union?

0 Answers  


What is de-normalization and what are some of the examples of it?

0 Answers  


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  






‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  


How to connect sql server management studio express to sql server 2005 express?

0 Answers  


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  


What is difference between primary key and foreign key?

0 Answers  


How to execute multiple stored procedures at one time in sql server?

0 Answers  


What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  


How to rename an existing column with sql server management studio?

0 Answers  


Categories