You can do it by using sp_executesql instead of "Execute".

sp_executesql allows to specify output parameters.

Do you store date and time in your datetime column or just a date?

If you need to store only date and your table is going to contain very large volume...

No.

What I mean by in-line SQL is the required functionality is implemented in the SELECT query itself.

Let say you want to format the date field somehow exotically.

Having it done in...

Working with very large datasets (in one of the largest datawarehouse implementations based on SQLServer in the world) we found that from performance point of view it always better to...

I have an idea for Read and Write method which will not use any separators to simulate serialization of Dictionary. I will do it on Monday.

Is anyone know the best...

Ah -- but did you realize that you need to use "UNION ALL" instead of just "UNION" statements here -- otherwise, SQL will sort each selected "row" in order to...

The best use of SELECT without FROM

IS DRAWING PICTURES

(switch to text output before execution):

select '0000^===========\0000' as [picture]

union select '000/^\__________\\000'

union select '00//0\\__________\\00'

union select '0//000\\__________\\0'

union...

Sorry, it most likely will not work as it looks like since 2005 sp2 updates to sys catalogs are not allowed (special thanks to MS as they always now better:-)).

I've...

My stupid laptop keyboard...

To update system catalogs, you will need to use DAC and run server in single-user mode.

I have not tried it myself. Just idea:

There is a table called sys.identity_columns

It contains the details of all identity columns.

Try to change it!

You will need to use DAC...

Also, you can create trigger on insert/update which will look up your surname...

you can update view in SQL Server. Read about "instead of" triggers

BTW, what you're trying to do is looking very wrong...

You can create view for that

I would suggest you first copy your data into another temp table with sorting out overlapping date ranges ad then proceed with the query.

But if you are lazzy you can...

Didn't anyone told you that "SELECT * FROM TABLE" is a bad habit 🙂

I afraid you will not be able to achieve what you want with UDF.

I can suggest to...