Viewing 15 posts - 1 through 15 (of 21 total)
Ah, this could be it.
Thanks much all!
July 27, 2015 at 4:45 pm
sure, it is basically simple statement:
-- from ServerA
create table Testdb.dbo.t1 (c1 datetime, c2 smalldatetime)
-- from ServerB
insert into ServerA.TestDB.dbo.t1 select getdate(), getdate()
I'm getting this from SQL 2008 R2 only.
The...
July 27, 2015 at 4:25 pm
Thanks all.
We decided to use DPM for FULL backup only and Log backup will be handled by native SQL backup.
October 23, 2014 at 11:16 am
I know double post it not a good manner but this was by an accident. The first post was timed out, thought that didn't work. my bad
October 22, 2014 at 7:48 am
Well, DPM is our corporate level backup solution so I have no control, we have to use it. We're doing this because we need another process to parse transaction...
October 22, 2014 at 7:44 am
Thanks for the input~
May 21, 2014 at 10:05 pm
Thanks jay81 but SYSTEM_USER won't work since it'll return current login info but we're using one shared account for all users.
As Jeff suggested, CONTEXT_INFO() might work that I'm playing around...
April 18, 2013 at 1:50 pm
Thanks Jeff.
It seems like there's a way if we use CONTEXT_INFO() function, I'll do more research on it.
Thanks again~
April 17, 2013 at 9:19 pm
thanks for your input.
I tried not to go this route but there are no other choices but track all the changes thsi way, unfortunately.
1. The PK will be Clustered.
2. I'm...
March 21, 2013 at 6:02 pm
This should work:
INSERT INTO TableName -- assuming you have a table already
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;HDR=YES;Database=FileName.xlsx',
'SELECT * FROM [SheetName$]') ...
January 19, 2013 at 12:31 pm
You can update the table
UPDATE tableName
SET col1 = REPLACE(col1, '"', '')
However, I'm still not clear why not converting the file to Excel or change the output using different field terminator...
January 18, 2013 at 8:30 am
How about convert the .csv to .xlsx and then use Improt/Export wizard or use SELECT INTO ... FROM OPENROWSET/OPENQUERY or SSIS. You'll have many choices with Excel format, which...
January 17, 2013 at 1:48 pm
Viewing 15 posts - 1 through 15 (of 21 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy