Viewing 15 posts - 511 through 525 (of 533 total)
but when i rerun the stored procedure with different parameter values...once again it starts with 999,998....it should be like that...whats my mistake?
September 26, 2011 at 7:34 am
Ya thanks Buddy... i got fixed it...
September 26, 2011 at 7:29 am
sorry pal, i didn't understand that
September 26, 2011 at 7:20 am
CREATE PROCEDURE Sp_Coded (@TableName varchar(15), @ColumnName varchar(10), @CodeID int, @Number bigint, @MaxLength int) AS
BEGIN
DECLARE @MySql varchar(5000)
SET @MySql = 'select 1501 as JurisID,' +...
September 26, 2011 at 7:13 am
DECLARE @JurisID int, @CodedID varchar(4), @CodeIDDescr varchar(60), @SrcCodeDescr varchar(60), @IsConverted int, @DecNumber bigint
here i declare @DecNumber as a variable, how do i declare it as identity column or something?
September 26, 2011 at 7:12 am
yeah i did that...and the problem is solved now...
September 26, 2011 at 6:38 am
i have a stored procedure which passes the values dynamically....
this is my destination table...
JurisID CodeID CodeIDDescr SrcCodeDescr PnxCodeValue IsConverted
1501 6002 SOU SOU SO 0
1501 6006 NTR NTR NT 0
1501 6002 EA EA EA...
September 26, 2011 at 6:34 am
sorry buddy....il get the details from him and i would be posting it on the forum for the answer..
September 26, 2011 at 6:27 am
its like stop operating the database...or broken up..
September 26, 2011 at 6:21 am
i don't know what exactly the problem is ? actually one of my friend asked me what is the way to retrieve the table if it is crashed out..?
i don't...
September 26, 2011 at 5:41 am
Hi,
is it possible to retrieve the crashed database back?
Thanks
September 26, 2011 at 5:11 am
Thanks for the comments given
is it possible to retrieve the crashed database back?
September 26, 2011 at 5:05 am
Viewing 15 posts - 511 through 525 (of 533 total)