Viewing 15 posts - 346 through 360 (of 812 total)
In sqlserver 2008 r2 the update doesn't return any resultset and no error message.
(2 row(s) affected)
(2 row(s) affected)
What I'm missing?
April 2, 2014 at 1:24 am
Hugo Kornelis (3/30/2014)
Carlo Romagnano (3/21/2014)
Remember that "Filtered indexes" are used only if the WHERE clause matches or is compatible with the filter.View http://www.sqlservercentral.com/questions/T-SQL/105826/
And even then, they are often not used...
March 31, 2014 at 1:21 am
Stewart "Arturius" Campbell (3/24/2014)
Interesting question, thanks Carlothought the lack of a semi-colon between deleted.* and COMMIT would cause an error.
Goes to show...
The lack of a semi-colon causes or would cause...
March 24, 2014 at 2:36 am
Remember that "Filtered indexes" are used only if the WHERE clause matches or is compatible with the filter.
View http://www.sqlservercentral.com/questions/T-SQL/105826/
March 21, 2014 at 2:32 am
marcia.j.wilson (3/18/2014)
Is this what's going on?
-The query initially adds a single row with a value of 1.
- The open query returns the deleted set...
March 19, 2014 at 1:51 am
crussell-931424 (3/18/2014)
It's still a little confusing.
About?
March 18, 2014 at 7:41 am
Hany Helmy (3/18/2014)
Thomas Abraham (3/17/2014)
Thanks for the question, Carlo.Don't know which is more interesting - the option for -1 rows, or the fact that 3% selected it as their answer!
-1...
March 18, 2014 at 1:44 am
These queries demonstrate the two different connection:
select @@SPID
SELECT * FROM OPENQUERY(MyServer,'select @@SPID')
March 17, 2014 at 9:03 am
timwell (3/17/2014)
I got crossed up because the documentation says that sp_serveroption and openquery are for connecting to remote or linked servers. I was thinking the delete was...
March 17, 2014 at 9:02 am
Mikael Eriksson SE (3/17/2014)
Carlo Romagnano (3/17/2014)
Mikael Eriksson SE (3/17/2014)
Using a query...
March 17, 2014 at 7:31 am
Thomas Abraham (3/17/2014)
Thanks for the question, Carlo.Don't know which is more interesting - the option for -1 rows, or the fact that 3% selected it as their answer!
:-D:-D:-D:-D
Unbelievable, but true!
March 17, 2014 at 7:14 am
Stewart "Arturius" Campbell (3/17/2014)
Interesting question, thankswouldn't the correct way to handle deletions from a remote server be
DELETE OPENQUERY(MyServer,'SELECT * FROM tempdb.dbo.a')
In this case, you haven't the DELETED.* resultset.
March 17, 2014 at 2:52 am
Mikael Eriksson SE (3/17/2014)
Using a query like this will show the...
March 17, 2014 at 1:55 am
palotaiarpad (3/12/2014)
According to BOL 'not.funny' should be treated as a failure:
[ @newname = ] 'new_name'
Is the new name for the specified object. new_name must be a one-part name and must...
March 12, 2014 at 7:11 am
"Schema cannot be named Not" ?????
"It could be said the table is not funny" ????
Bad wording?
March 12, 2014 at 2:01 am
Viewing 15 posts - 346 through 360 (of 812 total)