Viewing 15 posts - 2,041 through 2,055 (of 7,502 total)
dito.
Never seen it being used that way, never been pointed to this "feature" at any course followed and so we just never used it that way, but this opens a...
May 16, 2011 at 11:53 pm
Maxer (5/16/2011)
...I could store it in a temp table and return that.
...
AFAIK the scope of a returned result set is the calling proc, unless you store it in a table...
May 16, 2011 at 12:30 pm
theunique1011 (5/3/2011)
...
A little bit of feedback / progress would be welcome. :blink:
Please do keep in mind we don't want to give you a hard time by not just giving you...
May 16, 2011 at 1:11 am
You are using SQLusers that have another internal id on the sqlinstance that hosts your stand-by database.
If these accounts are only supposed to use that database, you could try to...
May 11, 2011 at 12:26 pm
Brandie Tarvin (5/11/2011)
The Science Fiction and Fantasy Writers of America (SFWA) will be in Washington D.C. on May 20th, doing...
May 11, 2011 at 6:04 am
GilaMonster (5/10/2011)
ALZDBA (5/10/2011)
Steve Jones - SSC Editor (5/10/2011)
May 10, 2011 at 2:22 pm
GSquared (5/10/2011)
May 10, 2011 at 2:02 pm
Steve Jones - SSC Editor (5/10/2011)
May 10, 2011 at 1:59 pm
Thank you for the suggestions on the Beer1 vitamines. 😉
Added to the list.
May 10, 2011 at 7:14 am
Koen Verbeeck (5/9/2011)
Any tips from the professionals around here...
May 10, 2011 at 4:57 am
BenWard (5/10/2011)
asp does not seem to like varchar(max) - I can only assume a colleague changed the table for some reason whilst I was on holiday!
appologies for...
May 10, 2011 at 3:20 am
can you provide:
- @@version info ?
- ddl of both objects
- did this start all of a sudden or is this a new release ?
- can you find anything in sqlserver...
May 10, 2011 at 2:43 am
How about:
SELECT ....
FROM dbo.scr_fct_exact_access scr_fct_exact_access
where seconds_since_epoch < datediff(ss, '1970-01-01', '2011-05-07')
May 10, 2011 at 12:53 am
SQLkiwi (5/9/2011)
GilaMonster (5/9/2011)
If there's no where clause on the query, select * from tbl will return all columns, all rows. The presence of nulls changes nothing.
Here's an interesting exception: SELECT...
May 10, 2011 at 12:43 am
Viewing 15 posts - 2,041 through 2,055 (of 7,502 total)