Database

imshally81 wrote:

today inserted record,yesterday inserted record,last 7 days inserted record,last 30 days inserted record and last year inserted record..

ZeePain! wrote:

This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.

pubududilena wrote:

Internal Return Rate

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

SELECT     p1.name as p1name, isNULL(p2.name, '') as p2name , J.text<br />
FROM         person p1 INNER JOIN<br />
                      job J ON p1.persID = J.creatorID LEFT OUTER JOIN<br />
                      person p2 ON J.responsibleID = p2.persID<br />
WHERE     (J.id = 1)

<br />
SELECT Description,COUNT(DISTINCT id_Stud)<br />
FROM Studenti, Istituti<br />
WHERE Studenti.id_Istituto = Istituti.id_Istituto<br />
GROUP BY Description;<br />

ventomito wrote:

what are the letters "i" and "s" ?

SELECT * FROM MyTable t
INNER JOIN OtherTable o ON ....

SELECT * FROM MyTable AS t
INNER JOIN OtherTable AS o ON ....

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

Colin Angus Mackay wrote:

I prefer to make this more explicit by writing it like this

john1113334 wrote:

Is it possible to connect to sql 2005 over internet?

john1113334 wrote:

would also apreciate some security aspects that need to be considered

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

R. A. Abbasi wrote:

I need to include a column in an SQL Server table, which can hyperlink to some text stored somewhere inside or outside the same database.