Viewing 15 posts - 166 through 180 (of 328 total)
I was interested in this problem so I made up some ddl. (I'm allowed to do this as I'm not a volunteer 😉 )
CREATE TABLE ABC
(
Date DATETIME,
Amount INT,
Category VARCHAR(10)
)
INSERT INTO...
April 23, 2012 at 3:15 pm
'EXEC d1' didn't work for me. whats this d1 supposed to be?
April 19, 2012 at 12:43 pm
LOL I'm using RBAR right now!!!! That said, why not just return 0 in your UDF and then continue your evaluation to see if the CLR UDF is what you're...
April 19, 2012 at 10:15 am
Ok my apologies, according to your supplied info, RESERVASJON.MDF is indeed the name of your database so that was my mistake in dropping the '.MDF'. Also, IBOAT\IIS_IUSRS was the username...
April 19, 2012 at 10:00 am
well maybe I assumed too much here, did you create a database using sql statements or are you using a database file somebody gave you?
In this statement, the argument to...
April 19, 2012 at 9:06 am
"C:\USERS\IFLOAT\DESKTOP\WEBSITE3 - SVEIN-EDITION\APP_DATA\RESERVASJON.MDF" is not really a good database name, more likely the database name to use is just 'RESERVASJON' or whatever name you gave while issueing "create database" statement....
April 19, 2012 at 8:27 am
Some things come to mind in considering a project like this.
Obviously its a big topic but handling security for multiple users will differ according to their roll and I think...
April 18, 2012 at 10:19 am
you could maybe classify the errors by the effect they have. maybe the error can display a warning, terminate a statement, terminate an entire batch, or even drop the connection.
Alternatively,...
April 18, 2012 at 9:41 am
Eugene Elutin (4/17/2012)
zojan (4/17/2012)
If you want log steps of the SP_ you can use loging into log_table....
Not good option for SQL Server as there is no direct equivalent to autonomous...
April 17, 2012 at 9:21 am
I would expect varbinary to act the same as ntext. The reason I would try casting to varchar is to get it to convert to one byte per character (or...
April 17, 2012 at 9:01 am
I don't really know the particulars, but ntext I think is a unicode format and it really does take two bytes to store each character (most of the time, occasionally...
April 17, 2012 at 8:08 am
SELECT SUM(I1) FROM TABLE_THAT_HAS_I1_AS_A_COLUMN
April 16, 2012 at 2:05 pm
I've run into various difficulties along those lines. I've saved at least two links:
The second link seems to have some extended conversations about this. I saved the links for myself...
April 13, 2012 at 7:53 am
Just out of curiosity, how do some of these run? Do estimated execution plans display for anything? Not that I have any answers or anything, just a curious case especially...
April 12, 2012 at 11:58 am
Viewing 15 posts - 166 through 180 (of 328 total)