here's a testable solution you can adapt to your real data;

this gets each table, and a comma delimited list of column names.

use this as a model, and change it to...

i'd like to see where you got a statistic or article stating UNION was a vector for hackers; might be interesting reading.

I'm more under the impression that SQL injection is...

I believe there was another recent thread that said scheduled jobs that are executing use "Microsoft SQL Server Management Studio", i believe, which was very misleading, since it's not really...

as far as i know, every login has access to master and tempdb; but they can hardly see anything that has not been granted permissions to them in those databases;...

if this is for a class or homework, we can point you in the right direction;

from experience, your structure is wrong;

individual products or items on the invoice need to have...

well, if a given id exists more than once in your tbl_directdebits, it will insert multiple rows.

...from tbl_directdebits where id= @id

does this query return any rows?

SELECT id, count(id)

FROM tbl_directdebits...

i don't userstand the logic of dropping it and adding it...why not delete, reseed any identities, and insert into again?

your error is due to the fact that

a stored proc...

agreed; what...

yeah, i didn't see a value in it either;

the grant for GRANT VIEW ANY DEFINITION TO AppInsightUser

lets the login see the metadata without having to be a user int he...

You can't.

fragmentation occurs, for example, when data is...

from the page you posted, someone suggested this code

SELECT *

FROM

[dbo].bookPageFromAddress(@address) addresses

outer apply [dbo].[imageFileFromBookPage](addresses.Book, addresses.Page) foo

you said it didn't work, but didn't say why, or whether you...

i think the key on the error is Level 19 that's a really high error number; I'd bet the lock is waiting on the database growing and getting more space...

It seems like most of the time i'm tuning, i have a specific query plan , either from a query, a procedure, or from the cache when i checking top...

just had the same issue on a database hosted on a web server.

the database was limited to 250 meg, and not allowed to auto grow.

check the properties of the database,...

here's my first guess on what you are after...some SUM(CASE statements to get your subtotals:

SELECT SUM(CASE

WHEN prd_cd='1'...