Viewing 15 posts - 241 through 255 (of 1,494 total)
It is difficult to tell exactly what you are doing but a trigger on a log table sounds a bad idea. All the triggers will be within the transaction so...
May 20, 2023 at 4:05 pm
I am not sure about SSIS but, assuming your object is a DataTable, try SqlBulkCopy:
https://www.howtosolutions.net/2016/07/dotnet-save-datatable-into-database-table/
May 11, 2023 at 7:47 pm
I am confused. You say you are using EFS which I would expect to be used by Linix but you then mention C: which would be used by Windows. I...
May 10, 2023 at 9:05 pm
I have not needed to do this but can think of two options to get live Oracle data; neither of them are particularly appealing.
Option one:
May 6, 2023 at 5:56 pm
Our network team have just installed their new backup system, called Cohesity, on one of our servers. It seems to work in a similar way to Datto. My backup routine...
April 18, 2023 at 10:38 am
,ROW_NUMBER() OVER (ORDER BY datalc, cm desc) AS RowNum
Using the above on 20140812 the first cm (RowNum = 1) will be 98 so your rules make the...
April 18, 2023 at 9:41 am
Seemed to double post
April 18, 2023 at 9:40 am
I didn't have a problem with it. If you want condescending, you have to read some Joe Celko posts.
For someone with a mathematical background, I do not think Joe...
April 18, 2023 at 8:14 am
Okay Phil Parkin criticizing a questioner is poor etiquete.
Umm.... The OP has form. I would say that repeatedly not providing DDL and test data is poor etiquette.
April 18, 2023 at 7:24 am
I want to align a Date column (datetime2(7)) with the same full resolution date of SysStartTime column populated by SQL in temporal tables.
Maybe I am misunderstanding something but why...
April 4, 2023 at 4:05 pm
The text data type has been depreciated for sometime and the remarks in the following state that CHARINDEX cannot be used with image, ntext, or text data types.
https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16
I suspect...
April 3, 2023 at 10:27 am
I know this is old, but is there STILL no way to do this?
Maybe.
You could try looking at row level security (RLS) on sys.databases but I suspect this will...
March 28, 2023 at 10:30 am
Viewing 15 posts - 241 through 255 (of 1,494 total)