Viewing 15 posts - 2,836 through 2,850 (of 2,894 total)
You can do it by using sp_executesql instead of "Execute".
sp_executesql allows to specify output parameters.
May 25, 2010 at 4:52 pm
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...
May 25, 2010 at 3:22 pm
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...
May 24, 2010 at 5:23 am
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...
May 24, 2010 at 4:23 am
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...
May 22, 2010 at 2:21 am
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...
May 22, 2010 at 2:11 am
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...
May 21, 2010 at 4:00 pm
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...
May 21, 2010 at 3:41 pm
My stupid laptop keyboard...
To update system catalogs, you will need to use DAC and run server in single-user mode.
May 21, 2010 at 3:28 pm
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...
May 21, 2010 at 3:27 pm
Also, you can create trigger on insert/update which will look up your surname...
May 21, 2010 at 1:49 pm
you can update view in SQL Server. Read about "instead of" triggers
BTW, what you're trying to do is looking very wrong...
May 21, 2010 at 1:47 pm
You can create view for that
May 21, 2010 at 1:20 pm
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...
May 21, 2010 at 11:33 am
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...
May 21, 2010 at 10:58 am
Viewing 15 posts - 2,836 through 2,850 (of 2,894 total)