Viewing 15 posts - 151 through 165 (of 363 total)
[font="Verdana"]
Select @var = col1 from #t1
EXEC au_info @var
[/font]
May 23, 2008 at 5:59 am
[font="Verdana"]Follow the below URL. http://msdn.microsoft.com/en-us/library/ms177410.aspx?wt.slv=RightRail [/font]
May 23, 2008 at 5:51 am
[font="Verdana"]
If I don't convert date variables to varchar in that dynamic query it will give error (I am assigning total query to a variable @insertsql which is varchar)
Think, if you...
May 23, 2008 at 3:00 am
[font="Verdana"]
set @insertsql = 'insert into customer_table select 455,'+@desc+','+
cast(isnull(@dt1,'') as varchar)+ ','+cast(isnull(@dt2,'') as varchar)+','+cast(1 as varchar)
why are you converting date variables to varchar as...
May 23, 2008 at 2:20 am
[font="Verdana"]
...and when we insert null values from sql query editor it is inserting null values. But, when insert procedure called from application and the null value (DBNull) passed for the...
May 23, 2008 at 1:40 am
[font="Verdana"]Do you mean you need something like this?
company dept
test ...
May 23, 2008 at 12:41 am
[font="Verdana"]Post your table structure. It seems, you nothing (Null) is passed to the date column, insert Default value. Eigther you need to alter table structure or let it as it...
May 23, 2008 at 12:03 am
[font="Verdana"]Can you specify in detail on what bases you wants to update TableA from TableB? What is the exact relation between these two tables?
Mahesh[/font]
May 21, 2008 at 9:21 am
[font="Verdana"]Austin, hope you might have not gone through it. I just found one article related to this issue. Author has mentioned not to use Update method of recordset. For more...
May 21, 2008 at 6:05 am
[font="Verdana"]Better you check the values before insert them into the table. Like
Create Proc {Proc Name}
....
If Not Exists(Select Id From Table Where ID) Then
Begin
{Insert Statement}
End
Else
Begin
{Record already exists}
End
....
try it...
May 21, 2008 at 4:38 am
[font="Verdana"]DECLARE @param varchar(120);
exec sp_01 '11', @param = @output_param OUTPUT;
select @param
I am not sure about this. Even I can't test it right now as I am sitting somewhere else where...
May 20, 2008 at 10:20 am
[font="Verdana"]
@mahesh Bote:
What do you mean? Something like
exec my_sp @output_param OUTPUT;
select @output_param;
?
Yup.:)
Mahesh[/font]
May 20, 2008 at 7:40 am
[font="Verdana"]For more information on JOINS refer BOL.[/font]
May 20, 2008 at 7:20 am
[font="Verdana"]Why don't you go then for Identity column? SQL Server will take care of it. For more information refere BOL.
Mahesh[/font]
May 20, 2008 at 7:15 am
[font="Verdana"]Select E.Number, E.Name, Max(E.Date) As Date, M.Text1
From Entries As E Inner Join Main As M On E.Number = M.Number
Group By E.Number, E.Name, M.Text1
you can use MIN as well depending upon...
May 20, 2008 at 7:07 am
Viewing 15 posts - 151 through 165 (of 363 total)