Viewing 15 posts - 61 through 75 (of 2,037 total)
Hi MSzI
I'm currently working on an updated version which handles IDENTITY-Inserts as configurable
Hi Lisa
I don't think you can use SSMS to handle BLOBs like XML files. I'd suggest using SQLCMD...
February 10, 2010 at 3:46 am
tosscrosby-60625 (2/3/2010)
Florian Reischl (2/3/2010)
analysisparalysisflagrantisIsn't that a bodily function usually, but not always, associated with men?
Sometimes it is.
Read this "word" last evening in a book "Use Case Driven Object Modeling with...
February 3, 2010 at 6:34 am
CirquedeSQLeil (2/2/2010)
That's not a good sign
I really think it will be a good day. However, today it's Groundhog Day in Punxsutawney 😉
I'll never forget this song:
February 2, 2010 at 1:55 am
Hi
Primary key is always unique, as soon as you try to insert duplicate data, you get an error.
Options:
Don't insert duplicates...
January 31, 2010 at 12:04 pm
Forgotten...
I'm not sure if CLR needs to be enabled. Probably you have to execute the following statement:
EXECUTE sp_configure 'clr enabled', 1;
RECONFIGURE;
There are some requirements for monitored SQL statements.
You cannot use...
January 31, 2010 at 12:00 pm
Hi
Well, without any changes, it wont work. But you don't need to change any tables or other schema objects. Service Broker needs to be enabled on remote database by following...
January 31, 2010 at 11:40 am
Hi halifaxdal
Sorry, I forgot one thing. My answer implies some .NET code. I don't know if it is possible to use Service Broker in a pure SQL environment.
Would it be...
January 31, 2010 at 9:41 am
Hey Paul
Thanks for the way better description. 🙂
One additional information. There is one more restriction with INSERT INTO ... EXECUTE. It cannot be used recursive. Means, if your...
January 31, 2010 at 9:17 am
If you want to change the columns data type have a look to BOL for ALTER TABLE and ALTER COLUMN.
If you want to change the output, not the stored data,...
January 31, 2010 at 2:20 am
What about having a look into BOL for XML methods like "nodes" and "value"? 😎
Tip: FOR XML doesn't work in your case, it works to create XML, not to parse.
Greets
Flo
January 31, 2010 at 1:45 am
Viewing 15 posts - 61 through 75 (of 2,037 total)