Mention the differences between having and where clause.

1055

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1627

What is use of dbcc commands?

1062

How to delete database objects with "drop" statements in ms sql server?

1080

How to change the password of a login name in ms sql server?

1009

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2224

How to use user defined functions in expressions?

1082

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1744

What are the 3 types of schema?

1103

Are resultset updatable?

945

Which sql server table is used to hold the stored procedure scripts?

1057

Explain multiserver query

1031

What factors you will consider calculating the storage requirement for that view?

940

What are the essential components of sql server service broker?

1016

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1135