Now right click on the procedure and select 'modify', get the alter proc script and change the procedure name to 'rename_by_alter'. Execute the script.

How can we modify the stored procedure...

gr888 question,,

GO GO GO 😛

good basic question of LIKE..

I like it 😛

good one.. new thing to knw abt partioning

good basic question...

🙂

answer results in an error message of Arithmetic over flow

+1 🙂

nice +2

good one 🙂

good question...

good basic question 😛

easy one for the end of the week :-):hehe:

first ensure that the value you are getting in @pid is int or varchar. If column data type is varchar then use CAST for it.

Hope, It will works for you...

gr8 question....

nice basic question neglecting ':' part

if i have 50 columns in a table of datatype varchar then do i need to manually change the collation using ALTER for each column..:w00t: