Database

BEGIN
  insert into resume_details (resume_id, resume_name) values (default, resume_name);
  select resume_id into record_identity from resume_details where resume_name = resume_name;
  return record_identity;
END;  

select Salesman, [1] as Jan,[2] Feb,[3] Mar,[4] Apr,[5] May,[6] Jun,<br />
    [7] Jul, [8] Aug, [9] Sep, [10] Oct, [11] Nov, [12] Dec<br />
from (<br />
select salesman, OrderID, datepart(month,order_date) as month<br />
from orders<br />
where datepart(year,order_date) = 2010)<br />
AS SourceTable<br />
PIVOT (COUNT(OrderID) FOR month in ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS PivotTable

CREATE TABLE [dbo].[Example](
     [Site] [nvarchar](50) COLLATE Latin1_General_CI_AS NOT NULL,
     [Accident] [nvarchar] NOT NULL,
     [Occations] [int] NOT NULL,
) ON [PRIMARY]

CREATE TABLE Incidents (
    Site varchar
    IncidentType varchar,
    IncidentDate Date,
    Incidentinfo varchar,
    ...
)

mark_w_ wrote:

I think thats what I need, but not sure.

Simon_Whale wrote:

you can't

tan873 wrote:

how to zip file with xp_cmdshell in sql server 2005

irr::core::stringc test = "Select name from profile WHERE name LIKE '%";
test += str.trim();
test += "%'";
result.clear();
result = pManager->SQLdb.Query(test);

T.RATHA KRISHNAN wrote:

If I use LIKE key word,it doesn't fully serve my purpose.

T.RATHA KRISHNAN wrote:

I've to restrict the number of records in a table. i.e I don't want to update the table if it already has 10 records in it. How to do this?