Viewing 15 posts - 256 through 270 (of 3,221 total)
L' Eomot Inversé and Hugo Kornelis
May I thank both of you for the discussion which developed. For myself the main purpose of any one's...
October 8, 2012 at 6:54 am
L' Eomot Inversé
It's a question with a correct answer, no scope for argument for that (as I have come to expect from Ron's questions, which seem to be always accurate...
October 7, 2012 at 8:51 pm
Is this what you require ?
DECLARE @String VARCHAR(8000),@Delimiter CHAR(1)
SET @Delimiter = '-'
SET @String = 'A-ab-xx-y-vv-w w-'
select @String, REPLACE(@String,@Delimiter,',')
Result:
(Orinial) ...
October 7, 2012 at 6:04 am
Did you move the RESOURCE data base ?
Read this it may be of assistance:
http://www.mssqltips.com/sqlservertip/1544/sql-server-backup-and-restore-of-the-resource-database/
You can also try moving the master database on a different location without moving the Resource database...
October 6, 2012 at 11:08 am
kapil190588 (10/6/2012)
When 'x' is getting inserted with WITh(ignore_dup_key=ON) then in select statement why 'x' is not getting returned?
Read carefully from the cited reference:
When this option is in effect,duplicates are merely...
October 6, 2012 at 10:14 am
Sean Lange (10/5/2012)
ben.brugman (10/5/2012)
bitbucket-25253 (10/5/2012)
October 5, 2012 at 12:38 pm
Hugo Kornelis (10/5/2012)
kyliedude (10/5/2012)
Give me my point!
If points are that important for you, you can have one of mine. Heck, you can have all of mine. Last time I checked,...
October 5, 2012 at 7:41 am
I have what I call a sandbox DB to hold scripts, some T-SQL and have it set up so as to be able to search by key words, for example...
October 5, 2012 at 7:34 am
L' Eomot Inversé (10/4/2012)
bitbucket-25253 (10/4/2012)
Note in all of the following the bolding of parts of the explanation has been done by myself.
...
...
...
As for running my own tests, if...
October 4, 2012 at 2:28 pm
L' Eomot Inversé
Note in all of the following the bolding of parts of the explanation has been done by myself.
When using BOL, at least the copy available to myself
SQL...
October 4, 2012 at 8:14 am
rmechaber (10/3/2012)
L' Eomot Inversé (10/3/2012)
rmechaber (10/3/2012)
length
Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types. For CONVERT, if length is...
October 3, 2012 at 11:53 am
Jason Selburg (10/3/2012)
Good grief Joe, did you forget to take your meds this morning? You complain about the rudeness of the OP, look at your response. Talk about rude!!!
+1
+1
October 3, 2012 at 10:09 am
rmechaber (10/3/2012)
Kevin Gill (10/3/2012)
rmechaber (10/3/2012)
The CAST('xyz' AS VARCHAR) works the same as the initial DECLARE: if no length is specified for a VARCHAR, it defaults to 1.Rich
But that suggests that...
October 3, 2012 at 10:04 am
Like many things in SQL "It depends" is most likely the most consistent.
Read this and with the knowledge gained test the use of the indexed view, and determine if the...
October 2, 2012 at 9:13 pm
Viewing 15 posts - 256 through 270 (of 3,221 total)