Viewing 15 posts - 1,846 through 1,860 (of 5,393 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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
February 28, 2012 at 3:27 am
Turns out that the Replication Guru says it could work!
He will post his advice later.
-- Gianluca Sartori
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.
-- Gianluca Sartori
February 28, 2012 at 2:49 am
Duplicate post (sort of).
Replies here please:
http://www.sqlservercentral.com/Forums/FindPost1258685.aspx
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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].
-- Gianluca Sartori
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.
-- Gianluca Sartori
February 27, 2012 at 10:32 am
Congrats Lynn! Hope you enjoy your new job.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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?
-- Gianluca Sartori
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...
-- Gianluca Sartori
February 24, 2012 at 3:12 am
Viewing 15 posts - 1,846 through 1,860 (of 5,393 total)