Viewing 15 posts - 16 through 30 (of 180 total)
This was removed by the editor as SPAM
May 30, 2019 at 11:11 am
May 30, 2019 at 10:56 am
Or load the data into a staging table first, and then load the original target table from the staging table. The staging table could have all columns as varchar(100) or...
May 22, 2019 at 12:54 pm
If the .ndf files are being used by Full Text Indexing you will not be able to remove the files without first dropping the full-text indexes and then removing the...
May 20, 2019 at 2:43 pm
It looks to me like those .ndf files have been created by or for use with the Full Text Search feature.
May 20, 2019 at 2:31 pm
The table variable was there just as an example. I used this to put your sample data in the table to demonstrate it working. You can replace that part with...
May 20, 2019 at 10:36 am
If you still want to extract the datetime from the file name you could use something like the code below.
DECLARE @File TABLE ([FileName] NVARCHAR(255) NOT NULL PRIMARY...
May 17, 2019 at 2:20 pm
Definitely tell your boss. They might know about the ON DELETE CASCADE foreign key constraint....
There may well be other stuff affected that you do not know about. Tell them what...
April 18, 2019 at 3:12 pm
Does DATEDIFF not work for you?
select *, DATEDIFF(DAY, StartDate, EndDate) from #T;
April 16, 2019 at 2:01 pm
I'm using SSMS v 17.9.1 and have that functionality. From the Query editor window when I enter Ctrl+U focus jumps to the dropdown list of Available Databases. If I hover...
March 18, 2019 at 9:41 am
Does the list of server groups returned by the first query contain the server groups you have created?
If it only contains the 5 built in groups then I'm...
January 18, 2019 at 8:35 am
It's BIDMAS these days Joe - http://www.bbc.co.uk/bitesize/ks3/maths/number/order_operation/revision/2/
August 1, 2018 at 8:35 am
Presumably you are then going to use the new parameter somewhere in the stored procedure and you are going to have to eyeball the SQL code to work out how...
August 1, 2018 at 8:19 am
A Partitioned View may work in this situation.
August 1, 2018 at 8:11 am
I would usually use the System Information Schema views to generate a batch of SQL to run for cases like this.
If all the...
July 31, 2018 at 7:26 am