Viewing 15 posts - 19,531 through 19,545 (of 59,072 total)
Tac11 (9/23/2015)
How do I execute below scripts using CMD:
Please Note: SQL server 2008r2, default instance with window Authentication.
1. Select * from Adventurewoks2008.Person.Person where Id = 5
2. Exec usp_getemployee...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 5:53 pm
Just to ask the question again...
Jeff Moden (9/22/2015)
Just a quick question and apologies for not following/reading all of the posts that have occurred since the last time I dropped...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 5:44 pm
Don't drop or disable the clustered index.
As someone already said, if you disable the clustered index, none of the data will be available.
If you drop the clustered index,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 5:39 pm
chris-1111548 (9/23/2015)
Hi there,
we import orders for our clients from .csv text files that they provide us each day.
For us to achieve the maximum discount from Royal Mail our items...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 4:54 pm
kdejan87,
Does the table have any kind of column(s) that would indicate the correct order of the transactions?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 4:40 pm
kdejan87 (9/23/2015)
View fourth answer and tell me your opinion
[font="Arial Black"]ALL [/font]the answers are incorrect because there is no column that enforces the order of the data in the original data....
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 4:36 pm
Mitch C. Stein (9/23/2015)
I know SQL 2012 will back up and restore from network drives.
So will everything from 2005 and up. And, 2005 also had the "COPY ONLY" feature......
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 8:20 am
WayneS (9/22/2015)
Everyone needs to just walk away from there. No more posting to...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 8:16 am
Now, if we could just get the OP to participate in his own thread... 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 8:04 am
bkshn (9/21/2015)
HelloI want to save 999999999 as real data in sql.
but it saved 1+E09.
Could you help me how can I save 999999999?
thanks alot
The question here is, do you know what...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 23, 2015 at 6:54 am
We have what I call a DevNetOps team made up of several teams.
[font="Arial Black"]OPS[/font]
Infrastructure, Windows, Email, VMs, Overall Security, Telephone System, UPS, Emergency Diesel, VPN's, DR, Remote DR, backups to...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2015 at 9:50 pm
Here's what I used to read from an ACCESS table using the ACE drivers. This will also read from an ACCESS View or Stored Query... no linked server required....
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2015 at 9:10 pm
Ok... once you've downloaded from the URL that I gave in my previous post, you need to following these (below) instructions instead of the ones that are posted on the...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2015 at 8:41 pm
pietlinden (9/22/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2015 at 8:28 pm
serviceaellis (9/22/2015)
Ok, example of how to do that?
Understand that until you posted code, I didn't have table names, column names, nothing... it's important to post the whole problem if you...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 22, 2015 at 8:21 pm
Viewing 15 posts - 19,531 through 19,545 (of 59,072 total)