Database

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.

CREATE FUNCTION MillisecondsSinceMidnight
(
    @in DATETIME
)
RETURNS INTEGER
AS
BEGIN
    DECLARE @retval INTEGER
	
    SET @retval =
            DATEPART(ms,@in) +
            DATEPART(ss,@in) * 1000 +
            DATEPART(mi,@in) * 60000 +
            DATEPART(hh,@in) * 3600000

    RETURN @retval
END