Showing posts with label procedures. Show all posts
Showing posts with label procedures. Show all posts

Friday, March 30, 2012

Help on Stored Procedures

I am learning to make a ASP web site and feel that if i can do it the harder way using some stored procedures instead of using multiple datasources on each page requiring that it might be better.

So i am wondering what are these used for:

DECLARE vs just entering "@.param1 varchar(30)"When i use "DECLARE @.rc int" i get the error "Incorrect syntax near DECLARE"
How to return values to ASP page in Visual Studio 2005
How to use @.@.rowcount - doesn't seem to work for me?i tried using
DECLARE @.rc int
SET @.rc = @.@.rowcountWhen to use GO, BEGIN etcIf i want to use the variable only in the procedure, and not needed to be inputed, do i need to put it in the CREATE PROCEDURE (section)?Should i use my own stored procedures or VS2005 created ones using datasources? not really procedures but SQL, in SQL can i do like IF ELSE? if i use my own i cant use the Optimistic Concurrency right? and whats that?

You need to read some basic tutorials on stored procedures.

http://www.awprofessional.com/articles/article.asp?p=25288&rl=1

http://www.functionx.com/sqlserver/Lesson16.htm

http://www.quackit.com/sql_server/tutorial/sql_server_stored_procedures.cfm

Also, Tatworth gave you some good links when you asked about this a few days ago.http://forums.asp.net/p/1118089/1757710.aspx#1757710

Monday, March 26, 2012

help on learning stored procedures

Can anyone tell me about some good online tutorials for learning stored procedures in SQL Server 2000?

Any help will be greatly appreciated.

Thank You.it's not a matter of learnign 'stored procedures' as learning SQL, or more specifically T-SQL

try www.sqlteam.com

Friday, February 24, 2012

help ME SQL2000

hello to all,
I have installed two serveur with sql server 2000,
one server a store launch one procedures and all it goes
two server error : Serveur MSg446, level 16 been 9 linens 1 CANNOT resolve COLLATION conflict for equal to operation.
I do not succeed to understand the type of problem you can help
thanks me
maurizioI'm unsure what the procedure is trying to do :confused:|||Originally posted by ncapi
hello to all,

I have installed two serveur with sql server 2000,
one server a store launch one procedures and all it goes
two server error : Serveur MSg446, level 16 been 9 linens 1 CANNOT resolve COLLATION conflict for equal to operation.
I do not succeed to understand the type of problem you can help
thanks me
maurizio

Istruction :
CREATE TABLE #zeta (
a VARCHAR(6) NOT NULL,
b DECIMAL(9) NULL
)

ALTER TABLE #zeta
ADD
CONSTRAINT zK_t
PRIMARY KEY (a)

SELECT RET.ID_R
FROM EL, RET, AN, #zeta
WHERE
EL.a LIKE @.P_COD_4 AND
EL.a1 = @.P_COD_1 AND
EL.a2 = @.P_COD_2 AND
EL.a3 = @.P_COD_3 AND
RET.ID_E = EL.ID_E AND
RET.COD_STATO = 2 AND
AN.ID_1 = RET.ID_1 AND
#zeta.a = EL.a
)