Viewing 15 posts - 7,591 through 7,605 (of 8,761 total)
Here is a modification of the trigger which allows for multi-row inserts and uses the CONVERT function.
😎
CREATE TRIGGER dbo.scancode_scancode_autogen
ON SCANCODE
AFTER Insert
...
August 4, 2014 at 9:49 pm
Quick thought, check the parameters, columns and the values data types as this is a datatype conversion error.
😎
August 4, 2014 at 2:28 pm
Tara-1044200 (8/4/2014)
is there any difference in features that don't get by purchasing standard edition?
The main difference would be some components like fuzzy matching and grouping are Enterprise only, everything else...
August 4, 2014 at 2:21 pm
Koen Verbeeck (8/4/2014)
Lynn Pettis (8/4/2014)
Whom ever has the Great Mystical Crystal Ball, you are needed here.I am afraid I have left it in my other coat...
I'm relying on the ESP...
August 4, 2014 at 1:57 pm
suresh0534 (8/4/2014)
Below is the Exception:
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'INFORMATION_SCHEMA.Columns'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
...
August 4, 2014 at 1:38 pm
mike 57299 (8/4/2014)
I am trying to generate a hex value automatically at time of insert. The column used for the hex # is an identity column. ...
August 4, 2014 at 1:03 pm
SQLRNNR (8/3/2014)
Eirikur Eiriksson (8/3/2014)
Jeff Moden (8/3/2014)
TomThomson (8/3/2014)
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
Heh......
August 3, 2014 at 1:51 pm
Jeff Moden (8/2/2014)
Eirikur Eiriksson (8/2/2014)
The datetime format is still the same upto and including 2014.😎
Thanks Eirikur. I've never looked at it but figured it might be so. That...
August 3, 2014 at 12:25 pm
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
Heh... what's really cool about Grant is...
August 3, 2014 at 10:33 am
Jeff Moden (8/3/2014)
TomThomson (8/3/2014)
Jeff Moden (8/2/2014)
Grant Fritchey (7/16/2014)
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.
Heh... what's really cool...
August 3, 2014 at 9:59 am
LutzM (8/3/2014)
after a semi-internal discussion the answer we agreed on is:Yes.
If you need a more detailed answer please provide a more detailed question.
Seriously? I thought that this time it was...
August 3, 2014 at 8:25 am
Please to read the links Lynn provided, it makes things so much easier if one has a proper structure and data sample.
For the fun of it (and feeling lucky...
August 3, 2014 at 8:12 am
If the appearance of the resume adds a value to it then selecting a font isn't enough. One should properly layout the document using the likes of Scribus, InDesign or...
August 3, 2014 at 6:58 am
Where was that Crystal Ball again when one needs it, certain I've seen it somewhere...
😎
August 3, 2014 at 6:47 am
Further on Lutz's last post, the solution to your problem is down to the actual, literal and exact data, at this point without the actual, literal and exact data...
August 3, 2014 at 6:42 am
Viewing 15 posts - 7,591 through 7,605 (of 8,761 total)