Viewing 15 posts - 1,846 through 1,860 (of 5,394 total)
Not exactly. You do something with that parameter, right?
You persist it to one or more tables and that's what gets logged in the transaction log.
That's an interesting question...
February 28, 2012 at 3:55 am
Locking hints cannot be specified against TVFs:
SELECT *
FROM dbo.someFunction() AS F
OPTION (TABLE HINT(F, NOLOCK))
Msg 8724, Level 16, State 1, Line 2
Cannot execute query. Table-valued or OPENROWSET function 'F' cannot be...
February 28, 2012 at 3:27 am
Turns out that the Replication Guru says it could work!
He will post his advice later.
February 28, 2012 at 3:18 am
I would use a view for this. OUTER JOIN both tables and define a column "RecordSource" based on which base table contains the ID.
February 28, 2012 at 2:49 am
Duplicate post (sort of).
Replies here please:
February 28, 2012 at 2:46 am
Changes on the Publisher will always be propagated to the Subscribers. That's the reason why you set up replication. 😉
I don't know if it can be done, but I highly...
February 28, 2012 at 2:34 am
Not the same exact issue you're facing, but this article[/url] contains a lot of information about DTC permissions to apply on Windows in order to let distributed transactions work.
Hope this...
February 28, 2012 at 2:27 am
If you want a stored procedure template with transaction / error handling, you can check out my stored procedure code template here[/url].
February 28, 2012 at 2:22 am
New view will always open the query designer, there's no way around it.
You can use the query templates (CTRL + ALT + T) and double click Views-->Create View.
February 27, 2012 at 10:32 am
Congrats Lynn! Hope you enjoy your new job.
February 27, 2012 at 6:39 am
sumitagarwal781 (2/27/2012)
To delete data through a view example.
I'm not saying it can't be done, but some restrictions apply.
BOL says:
The view referenced by table_or_view_name must be updatable and reference exactly one...
February 27, 2012 at 5:36 am
As long as you update data from a single table, yes.
As far as deletes is concerned, I don't think you can force deletion from a specific table and I guess...
February 27, 2012 at 4:44 am
I don't understand if the use of EXISTS in this context is unclear to you or if it's clear but you would like a different approach.
Can you clarify please?
February 24, 2012 at 8:19 am
If I understand correctly, this should do:
-- CREATE A TABLE FOR TESTING
CREATE TABLE testTab (
cd varchar(max),
someColumn varchar(max)
)
GO
-- INSERT SOME TEST VALUES
INSERT INTO...
February 24, 2012 at 3:12 am
Viewing 15 posts - 1,846 through 1,860 (of 5,394 total)