Viewing 15 posts - 3,676 through 3,690 (of 5,109 total)
tarekj - Monday, May 22, 2017 7:43 AMThen what is the best practice to backup sql database to the cloud?
Uploading the files...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 23, 2017 at 2:07 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 8:55 am
Sounds like the Login is set to a different language. You can check with the following sql (replacing the string with the real logins):USE master;
GO
SELECT...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 7:36 am
tarekj - Monday, May 22, 2017 6:09 AMThis will copy the whole file every time I sync it which is 10 GB!
You'll...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 6:31 am
Usable DDL & DLM:CREATE TABLE #Shift
(Eid int,
Shift_Start datetime,
Shift_End datetime);
GO
INSERT INTO #Shift
VALUES
(1,'20170522 20:00:00.000','20170523...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 6:28 am
Considering that you didn't provide any DDL or DLM, this entire thing is guesswork. Personally, however, I'd strongly consider your database design. For example, why are there two tables for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 4:16 am
tarekj - Sunday, May 21, 2017 9:33 AMHow can I make automated sql differential backup onto onedrive?
I'm not sure there's a direct...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 2:37 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 22, 2017 at 2:00 am
If they do contain NULLs then perhaps:=COUNT(Fields![Your Nullable Column].Value, "[Your dataset Name]")
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2017 at 6:20 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2017 at 5:44 am
solus - Friday, May 19, 2017 5:32 AMIve changed the varchar sizeALTER FUNCTION [dbo].[ConvertStringToTime]
(
@T VarChar(4)
)but im still getting null returned
For what values?...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2017 at 5:39 am
You've declared @T as a varchar(1)(
@T VarChar
)
Edit:
This means most of your values will be truncated:'1300' -> '1'
'900' ...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2017 at 5:13 am
Spam.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 19, 2017 at 4:42 am
Viewing 15 posts - 3,676 through 3,690 (of 5,109 total)