I think you need something like this (below). As mentioned by Ratbak, you'll need to drop indexes and foreign keys before making the change and you should definitely run it...

• This reply was modified 5 years, 7 months ago by Chris Wooding.

When adding the reference to the non-managed database, you should set "Suppress Reference Warnings" to True. I think that will get around your problem.

Are you able to see whether it's blocked by another transaction? The fact that it returns null on the occasions when it takes a long time suggests some other process...

Jeff's comment about the cut-off for 2 digit years reminded me that the millennium bug was "fixed" at one place I worked by using YY>20 as the cutoff to guess...

If they've asked to be able to search for two area codes at a time, it won't be long before they ask to search for 3 or 4 or more....

We do the same as others have mentioned. Load into a table where the columns are wide nvarchar and then validate afterwards. We use TRY_CAST and TRY_PARSE to check whether...

My guess at the logic is that the seats are in pairs. Single children can sit anywhere there is a space, but siblings need to sit together, so their seat...

It would be nice if the object explorer in SSMS had a node under each database for triggers so that you could see them all in one place.

I think 2FA can be good when it's well implemented, but a chore when it's not done well. For example, my bank sends a PIN to my mobile when I...

Another point to consider; if the primary key is also a foreign key in other tables, there could be a significant impact in using one that takes up 16 bytes...

Thanks. That gives exactly what I need.

All our SQL data changes have to be made via a script. The script is written by the developer and peer reviewed before being executed by the Release team. Obviously...

INSERT INTO table2
SELECT col1, col2 FROM table1 t1
EXCEPT
SELECT col1, col2 FROM table2 t2

I very proudly stuck with my "stupid" phone for many years precisely because the charge lasted over a week. All it could do was handle texts and phone calls (and...

If the text part could appear before the number part, you could use Alan Burstein's pattern exclude function thus.

create table #temp
(
columnTextNumbers  nvarchar(50)
)
insert into #temp (columnTextNumbers) 
values
('3.5A'),
('5.50kg'),
('35.70kg'),
('9m'),
('£4.99')

select...

• This reply was modified 5 years, 11 months ago by Chris Wooding.