all groups > sql server programming > august 2003 >
You're in the

sql server programming

group:

SQLSP3


SQLSP3 ismail Awadat
8/2/2003 10:32:44 PM
sql server programming: Hello Prof.
I am on SQL Server 2000 with VB6 and I made My stored
procedure on SQLServer 2000 With no any SP but when i
installed SP3--SQLSP3-- All Stored Procedure worked on
Good way only the delete Stored Procedure didn't work
by the way they where working in greate way befor SP3
and the Table design and table view data is changed from
from-left-to-right to from-right-to-left view if any one
now any thing about my problems please contanct me and
send to me any solustion.

Regurds
Re: SQLSP3 oj
8/2/2003 11:16:56 PM
can you post the codes here so we can see. also, i suggest you take a look
at sp3 readme file. there are quite a bit of changes relating to sqlserver
security in sp3.

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net



[quoted text, click to view]

Re: SQLSP3 ismail awadat
8/3/2003 12:37:02 AM
dear prof.
here is my code that u asked i hope u find the problems
and if u know how to make the screen Left-toRight Again please tell me
CREATE PROCEDURE [delete_LOCATION_TABLE]
(@Lo_Num_1 [nvarchar])

AS DELETE [HelpDB].[dbo].[LOCATION_TABLE]

WHERE
( [Lo_Num] = @Lo_Num_1)
GO




*** Sent via Developersdex http://www.developersdex.com ***
Re: SQLSP3 Itzik Ben-Gan
8/3/2003 5:29:04 PM
Ismail,

Try running sp_updatestats in your database to update statistics.

BTW, choosing NVARCHAR as the parameter's datatype means NVARCHAR(1). Is
that also the datatype of the column Lo_Num?

--
BG, SQL Server MVP
Solid Quality Learning
www.solidqualitylearning.com


[quoted text, click to view]

AddThis Social Bookmark Button