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, 5 months ago by Chris Wooding.

My boss has been very proactive in this area - we already had a weekly "Tea and biscuits" meeting, but he's moved that to Teams and we join in from...

I'd suggest that you look at some of the Stairway articles on this site. All the ones I've read have been extremely  well-written. You can pick topics that cover areas...

As the database is using a case-sensitive collation, I don't see why the 2nd option wouldn't work.

To find out which values are causing the problem, you could use TRY_CAST(YourColumn AS DATE). The values that can't be cast will be null in the new table. Then you...