Wednesday, 15 April 2015

c# - How to insert values from a table in another along with other values in sql server? -


I am working on the project in which I need to insert data from one table to another, say me Table 1 (col1, col2, col3) and I have a table 2, so I wrote the following: -

  Enter in Table 1 (col1, col2) value ((@ Constant), ( 

How is it to know that @Constant is a parameter used in the stored procedure?

  Include in Table 1 (col1, col2) SELECT @constant, col2 to table 2  

No comments:

Post a Comment