The trigger (and insert) would be on the view if you're trying to prevent insert into dbo.Badgeid and instead insert into Badgeid2.

Are you saying you also still want data inserted...

1. Assuming you're doing this in SSMS, you need a GO statement after your trigger definition.  Otherwise, your insert and select are just part of the trigger definition, and are...

Not the original question, but bubbling up unchanged error is another advantage of THROW. If you want to bubble up the error, unchanged, you can simply call THROW, and it...

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

"SELECT CASE WHEN NULL = NULL THEN 'No' ELSE 'Yes' END AS Result

Result would be no because one null value cannot be equal to another because null means 'UNKNOWN'."

Perhaps just...

You probably want a covering index like:

CREATE NONCLUSTERED INDEX ncix_PropertyProduct_Cover ON dbo.PropertyProduct
(
Warehouse ASC,
Product ASC
)
INCLUDE(Id,PropertyId,Value);

SELECT CAST(ROUND(COLUMN_A*100.0/(CASE WHEN COLUMN_B = 0 THEN -1 ELSE COLUMN_B END),2) as decimal(5,2)) as "Percentage"

You lost the ROUND() function's length parameter in that version

You can use gzip. But make sure you use 7z.exe, not 7za.exe -- https://sevenzip.osdn.jp/chm/cmdline/index.htm:

7za.exe supports only 7z, xz, lzma, cab, zip, gzip, bzip2 and tar formats.

https://sevenzip.osdn.jp/chm/cmdline/switches/type.htm:

If -t{archive_type} switch is not...

Use the command line executable: https://sevenzip.osdn.jp/chm/cmdline/index.htm

DENY CONNECT ANY DATABASE TO [login]

I don't have a solution to the problem as stated, but as a workaround, my suggestion/question would be:

Could you just create a subscription with the report rendered as a PDF? ...

Is ProximityCardNumber really an nvarchar(11)?  Does it really need to be?  (Not if  ProximityCardNumbers are numeric strings like the sample... Of course, if this this a vendor database, your control...

• This reply was modified 6 years, 4 months ago by ratbak.

https://www.diva-gis.org/gdata

https://hub.arcgis.com/datasets/a21fdb46d23e4ef896f31475217cbb08_1

https://gadm.org/download_country_v3.html

http://www.maplibrary.org/library/index.htm

And many others of varying reliability.

You'll need to use a GIS converter to import into SQL Server.

To get plan reuse, you need to use stored procedures or parameterized queries: https://www.red-gate.com/simple-talk/sql/t-sql-programming/performance-implications-of-parameterized-queries/

2005.

Both work, but sp_change_users_login "is in maintenance mode and may be removed in a future version of Microsoft SQL Server."

Fortunately, it's as simple as wrapping the database name in brackets -- i.e.,

BACKUP DATABASE [update] TO DISK = N'C:\SQLBackups\update.bak' WITH INIT

Your vendor is at best, uninformed about...