Database

select convert(varchar,year(getdate()))+ <br />
(select top 1 cast(empsex as varchar) from emp )+<br />
(select top 1 cast((empid+1) as varchar) from emp order by id desc) 

declare @FNID as int<br />
set @FNID = (select max(ID) from firstnames)<br />
declare @LID as int<br />
set @LNID = (select max(ID) from lastnames)<br />
<br />
Insert into users (firstnameID,LastNameID) values (@FNID,@LNID)

DECLARE @FID INT
DECLARE @LID INT

SET NOCOUNT ON

SELECT @FID = [ID] FROM FirstNames WHERE FirstName = 'Fritz'

IF @FID IS NULL
BEGIN
  INSERT INTO FirstNames(FirstName) VALUES ('Fritz')
  SET @FID = Scope_Identity()
END

SELECT @LID = [ID] FROM LastNames WHERE LastName = 'Blignaut'

IF @LID IS NULL
BEGIN
  INSERT INTO LastNames(LastName) VALUES ('Blignaut')
  SET @LID = Scope_Identity()
END

INSERT INTO Users VALUES (@FID, @LID)

big_nige wrote:

Or is it possible to create a table view with the exact name of the original table (deleting the tables of course) and the SP's and reports will still pick up the data?

Rami Said Abd Alhalim wrote:

(the file you've specified is not a valid sql server database file )

isiran wrote:

When I execute insert command, with passing 9 parameters values, by use of executenonguery function I receive "procedure or function "procedure name" has too many argument specified" error massage at line of executing.
What should I do?

isiran wrote:

I don't know what's happend there cause I check every parameters by breakpoint and saw that every parameters were passed

John Mecas wrote:

can anyone explain me this code