Viewing 15 posts - 76 through 90 (of 137 total)
msh083 (2/3/2016)
GilaMonster (2/3/2016)
You've given them names. First and Second in your code example. You can reference them by those names in the last query.What are you trying to do?
i want...
February 4, 2016 at 2:43 pm
dbaduck (10/19/2015)
If you have a default instance then you use the word DEFAULT or default in your path.SQLSERVER:\sql\localhost\default
Thanks, Default worked for what I needed.
dbaduck (10/19/2015)
cd SQLSERVER:\sql\localhost
dir
You should...
October 20, 2015 at 7:38 am
Hello, great stairway!
I have two instances of SQL server installed, 2008 R2 SP1 and an EXPRESS version I think installed with Visual Studio.
I am able to navigate to
SQLSERVER:\sql\localhost\SQLEXPRESS...
October 19, 2015 at 3:34 pm
Eric M Russell (10/15/2015)
I believe Excel is more often used for professional data analysis than MS Access. What functionality is missing from Excel that she finds in MS Access?
I am...
October 15, 2015 at 2:32 pm
g.britton (10/1/2015)
timwell (10/1/2015)
October 1, 2015 at 3:19 pm
With regard to last_access_time, there is a note from a Michael Quinlan on the version of the FileTable Schema page that comes up on the search in technet with some...
October 1, 2015 at 8:06 am
I have implemented some very simple logging to just have a record of changes and internet activity.
(I have "inherited" a habit of prefixing field names with an abbreviation of...
September 25, 2015 at 8:26 am
Lynn Pettis (9/8/2015)
SQLAddict01 (9/8/2015)
.
Then doesn't this give you what you want?
Select
*
from
backups
where
databasename not in (select databasename from backups where...
September 10, 2015 at 11:02 am
Is MDS implemented as a specialized database using SQL Server?
I suppose the DBA usually is the one who is responsible because it's data.
Just curious. This is the first I...
August 14, 2015 at 7:56 am
Of course we have to assume that neither username nor gender are "a computed column, a UDT column, a spatial data type column, or a hierarchyID data type column" as...
June 5, 2015 at 8:20 am
When I was scripting a table with a varchar(max) field I noticed it includes:
TEXTIMAGE_ON [PRIMARY]
In MSDN for CREATE TABLE https://msdn.microsoft.com/en-us/library/ms174979(v=sql.120).aspx it says:
TEXTIMAGE_ON { filegroup| "default" }
Are keywords that indicate that...
January 22, 2015 at 12:33 pm
Sean Lange (12/12/2014)
... Also, the link for documentation is a pretty bad choice since it is the sql 2000 version. There is no reference at all to sp_configure. ...
A better...
December 12, 2014 at 8:18 am
Viewing 15 posts - 76 through 90 (of 137 total)