Database

Select top 5 LastName,  count (*) as [Count] from TBL where lastname = 'Cruz'<br />
group by lastname order by [Count]  Desc

Select top 5 LastName, count (*) as [Count] from TBL where lastname = 'Cruz'<br />
group by [Count]

CandyMe wrote:

Select top 5 LastName, (Select count (*) from TBL where lastname = 'Cruz') as Count from TBL where lastname = 'Cruz'

CandyMe wrote:

I mean my query doesn't work and have researched over the internet.

Select top 5 LastName, <br />
(Select count (*) from TBL where lastname = 'Cruz') as Count <br />
from TBL where lastname = 'Cruz'

insert into mytesttable (MyDateField) values (getdate())

CREATE TABLE [MyTestTable] (
    [IDColumn] [int] IDENTITY (1, 1) NOT NULL ,
    [DateCreated] AS (getdate())
) ON [PRIMARY]

Skanless wrote:

1. If you are new to a database, is there a way that you can quickly find out relationships between the tables?

Skanless wrote:

2. I need to retrieve information on all the tables in a database to find out which tables have a rowcount of more than 50,000 records then delete some record which thus reducing the table to 50,000 rows so as to make space. Is there a way to do that? and if so, what is the syntax to obtain this?

Skanless wrote:

3. How can I cascade constraints when deleting records from a specific table?

DataTable DT = new DataTable();
if(m_DB is SqlConnection)
{
	m_DA = new SqlDataAdapter(Query,(SqlConnection)m_DB);
	m_CB = new SqlCommandBuilder((SqlDataAdapter)m_DA);
	((SqlCommandBuilder)m_CB).QuotePrefix="[";
	((SqlCommandBuilder)m_CB).QuoteSuffix="]";
	((SqlDataAdapter)m_DA).Fill(DT);
}