Viewing 15 posts - 7,051 through 7,065 (of 26,490 total)
Based on your last post (please note that I drop your table at the end to clean up my Sandbox database):
create table dbo.estr(
custo int,
product varchar(20),
val int,
billed_date datetime
);
insert into dbo.estr(custo,product,billed_date,val) values('10','Milk','2013-04-11','2000');
insert...
December 30, 2013 at 7:38 am
[font="Arial Black"]Merry Christmas to One and All from Afghanistan![/font]
May you all enjoy this festive time with family and friends. Please take a moment and remember those who are from...
December 24, 2013 at 10:51 am
At $75.00 USD or less, just buy the Developer Edition. I find it well worth the cost.
December 22, 2013 at 8:39 am
bkshn (12/22/2013)
I run code bellow.
declare @SQLstring nvarchar(max) , @ExeCommand nvarchar(max),@OutString nvarchar(max)
set @SQLstring = ' EXEC [dbo].[xmlGenerate] 20, 100001, 1 '
EXEC sp_executesql @SQLstring , N'@OutString nvarchar(max) output',...
December 22, 2013 at 8:24 am
sharpcnet (12/22/2013)
December 22, 2013 at 8:16 am
Care to provide a better description of the question?
I am not sure if you are asking what the difference between the parameters declared as input/output to the procedure and variables...
December 22, 2013 at 8:11 am
Well, not sure where to start since there is nothing from which to work, no DDL, sample data, expected results, or what you have tried so far to solve your...
December 22, 2013 at 8:08 am
Looks to me like you will have to uninstall and reinstall SQL Server with new license keys. As far as I know you can't just change the key. ...
December 21, 2013 at 10:42 am
ScottPletcher (12/20/2013)
And my original point that somehow upset so many was this since this code:
WHERE ( SomeCharacter IS NULL OR SomeCharacter = '' )
is both clearer and performs better, then...
December 20, 2013 at 5:34 pm
Greg Edwards-268690 (12/20/2013)
Grant Fritchey (12/20/2013)
WayneS (12/20/2013)
December 20, 2013 at 10:11 am
To the best of my knowledge, no. As long as your client has the proper documentation to show that the SQL Server software is properly licensed that should be...
December 20, 2013 at 7:24 am
IT2012 (12/19/2013)
December 19, 2013 at 2:51 pm
In SSMS I created your table (dropping the FK reference), then ran the insert into the table with no errors. Not sure what could be happening.
December 19, 2013 at 9:33 am
ScottPletcher (12/19/2013)
December 19, 2013 at 8:57 am
Have you looked in the error logs to see if there is more information there?
December 19, 2013 at 8:47 am
Viewing 15 posts - 7,051 through 7,065 (of 26,490 total)