Viewing 15 posts - 16 through 30 (of 51 total)
QuietCoder - Friday, January 12, 2018 2:20 PMHow can I do this in SQL server?select Trunc(createdate) + 3/24
from OrdersThanks
SELECT DATEADD(HOUR, 3/24,...
January 12, 2018 at 2:43 pm
The Developer Edition has all the features of the Enterprise Edition, so you can use/test every SQL Server feature there is.
January 9, 2018 at 8:51 am
Further down this page it lists downloads for version 16:
December 11, 2017 at 1:19 pm
More of an SSMS thing, but intellisense for Synonyms would be helpful. Use one in a query and everything is red-squigle.
December 1, 2017 at 2:04 pm
This one can be tough to and figure out. Happened to us twice. Ended up that an application developer had started a transaction using ADO, and before that transaction was...
October 16, 2017 at 2:50 pm
ORMs like EF can be very useful when you know what you're doing and when you need to revert back to good ol' ADO. I have strong DB design skills...
September 27, 2017 at 9:21 am
August 1, 2017 at 2:54 pm
July 17, 2017 at 7:17 am
July 7, 2017 at 10:49 am
June 28, 2017 at 8:57 am
set @sql = 'exec sde.next_rowid, @owner, @table, ' + convert(varchar(5),@objectid) + 'OUTPUT';
Here you are only setting the value for the @sql variable. The exec is...
June 27, 2017 at 1:43 pm
June 27, 2017 at 12:14 pm
Suth - Tuesday, June 27, 2017 7:22 AMBut the Output would only be good for returning errors ?
No, he means the...
June 27, 2017 at 7:28 am
Please don't double post. You have working T-SQL and SSIS solutions on this thread:
https://www.sqlservercentral.com/Forums/1882790/Extract-String
June 22, 2017 at 3:25 pm
Didn't know this was SSIS. Here is the T-SQL from my first post translated:
SUBSTRING(@[User::FilePath], LEN(@[User::FilePath]) - FINDSTRING(REVERSE(@[User::FilePath]), "\\", 1) + 2, 3)
June 22, 2017 at 2:53 pm
Viewing 15 posts - 16 through 30 (of 51 total)