Database

Nitin.Jen wrote:

Wat is meaning of IDENTITY(1,1)....??

Nitin.Jen wrote:

Can we create Database of Music Files using SQL Server 2000.

Nitin.Jen wrote:

please give an example

Eric.W wrote:

B/S arch

<br />
CREATE TABLE #MyTempTable (salary decimal(28,12))<br />
INSERT INTO #MyTempTable  <br />
SELECT salary FROM employeedetails<br />
GROUP BY salary <br />
<br />
CREATE INDEX salary <br />
ON #MyTempTable (salary DESC)<br />
<br />
SELECT * FROM #MyTempTable<br />

followait wrote:

Sometimes toInsert contains single quotation mark(s), how to do deal with it efficiently?

pCmd->CommandText=_bstr_t(L"INSERT INTO tmp(id,a,b,c) "
			L"VALUES(?,?,?,?)");

followait wrote:

pCmd->CommandText=_bstr_t(L"INSERT INTO tmp(id,a,b,c) "
L"VALUES(?,?,?,?)");

INSERT INTO tmp(id,a,b,c) VALUES(@id,@a,@b,@c)
CommandObject.Parameters.Add(@id,value);
CommandObject.Parameters.Add(@a,value);
CommandObject.Parameters.Add(@b,value);
CommandObject.Parameters.Add(@c,value);

select * <br />
from (select username,designation, count(*) as points <br />
      from (select username,designation <br />
	    from messages <br />
	   union all <br />
	    select username,designation <br />
	    from replies<br />
	   )t1 <br />
      group by username,designation<br />
     )t2<br />
order by points desc