TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ahmed fahd
NA
58
46.1k
what is wrong in this procedure
Dec 23 2012 9:34 AM
i test my code in vb.net it's ok has no mistakes
so the probelm is here also this query was working with the code but i don't know what happend :(
some one can tell me my
create PROCEDURE
Customes_Tables_Update
(@Cust_newName nvarchar(50),@Cust_Name nvarchar(50),@Cust_Addrs nvarchar(50),@Brch_ID int,@cust_id int)
AS
if
@Brch_ID <> 0
UPDATE
Customes_Tables
SET
Brch_ID = @Brch_ID
WHERE
(Cust_Name = @Cust_Name or cust_id=@cust_id)
if
@Cust_newName <>
null
UPDATE
Customes_Tables
SET
Cust_Name=@Cust_newName
WHERE
(Cust_Name = @Cust_Name or cust_id=@cust_id)
if
@Cust_Addrs <>
null
UPDATE
Customes_Tables
SET
Cust_Addrs = @Cust_Addrs
WHERE
(Cust_Name = @Cust_Name or cust_id=@cust_id)
Reply
Answers (
4
)
there an easy way to combine to SQL databases ? Both DBs ha
how to margin different data in database same structure