Database

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

-- Alter an existing function called JoinBase
-- It takes an integer as a parameter called @JID
-- It will return a VARCHAR with a maximum size of 200 characters.
ALTER FUNCTION dbo.JoinBase(@JID INT) RETURNS VARCHAR(200)
AS 
BEGIN

-- Two local variables are declared
DECLARE @JEX VARCHAR(200),
@Qualification VARCHAR(20)

-- A cursor is declared. 
-- It will return the results of the SELECT statement one row for each loop
DECLARE c1 CURSOR LOCAL FAST_FORWARD FOR
select enb from I_EM inner join Ew on I_EM.e_id=Ew.e_id and empid=@JID
ORDER BY e_name
OPEN c1

-- Loops until the cursor has exhausted all the rows from the SELECT
WHILE (@@FETCH_STATUS = 0)
BEGIN

-- This line won't even compile because @Qual doesn't exist
-- but it is supposed to get the value of enb from the SELECT
-- statement into the local variable @Qual (@Qualification)
FETCH c1 INTO @Qual

-- If the fetch was successful
IF (@@FETCH_STATUS = 0)
BEGIN

-- Append @Qual into the existing list.
-- If the list doesn't exist create one as a blank string
-- The end result is a comma separated list mad up of each
-- @Qualification/@Qual returned from the query.
SET @JEX = IsNull(@JEX + ',', '') + @Qual
END
END

-- Close the cursor
CLOSE c1

-- Returns the result to the caller
RETURN @JEX
END