Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
how to write simple query
Ajinkya Ban
Mar 19 2013 6:15 AM
1.3k
Reply
hi
this is my sp
UPDATE Con
SET Category1code =c1.Category1Name, Category2Code=c2.Category2Name
FROM Contacts Con
INNER JOIN Category1 As c1
ON Con.Category1Code = c1.Category1Code
Inner Join Category2 As c2
ON Con.Category2Code = c2.Category2Code
just i want write above sp into simple query like
SqlConnection Con=new SqlConnection();
SqlCommand cmd=New SqlCommand("how to write above sp here",con);
please give me solution
thanx in advance.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
How to get all order ID which not payed in SQL Server 2008?
insert Hindi using stored procedure only in MSSQL 2008 only