Viewing 15 posts - 751 through 765 (of 1,048 total)
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 12, 2012 at 12:17 am
gr888 question,,
GO GO GO 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 11, 2012 at 3:19 am
good basic question of LIKE..
I like it 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 11, 2012 at 3:08 am
good one.. new thing to knw abt partioning
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 11, 2012 at 3:06 am
good basic question...
🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 11, 2012 at 2:59 am
answer results in an error message of Arithmetic over flow
+1 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 11, 2012 at 2:55 am
nice +2
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 7, 2012 at 4:19 am
good one 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 7, 2012 at 4:19 am
good question...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 7, 2012 at 12:17 am
good basic question 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 6, 2012 at 11:43 pm
easy one for the end of the week :-):hehe:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 6, 2012 at 11:36 pm
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...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 6, 2012 at 3:39 am
gr8 question....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 5, 2012 at 11:02 pm
nice basic question neglecting ':' part
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 11:17 pm
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:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
December 4, 2012 at 6:36 am
Viewing 15 posts - 751 through 765 (of 1,048 total)