Viewing 15 posts - 12,451 through 12,465 (of 13,461 total)
the original function did not encode <> symbols as well as quotes and ampersands;
this is a little better; someone critque this function please:
ALTER FUNCTION HTMLEncode(@OriginalText VARCHAR(8000))
RETURNS VARCHAR(8000)
BEGIN
DECLARE...
September 12, 2007 at 7:54 am
ha!
once again, stealing/borrowing Jeff Modens example and running with it, here's a TSQL function:
--===== Create and populate a 100,000 row test table.
-- Column RowNum has a range of 1...
September 12, 2007 at 7:12 am
obviously you can do this on the application side, but not natively in TSQL...looks like you'd need a function.
I bet the .NET HTMLEncode and HTMLDecode functions would be perfect for...
September 12, 2007 at 6:43 am
As you suspect, no there's no surefire way to prevent anyone from connecting to a database and copying the schema, nor the data. I know you probably spent a lot...
September 12, 2007 at 5:53 am
I'm pretty sure \r is the row terminator for unix, and \n is the terminator for pc based text files. I've never used \n and \r together, that would be...
September 11, 2007 at 12:00 pm
here's an example that i based off of one of Jeff Modens examples...hey I'm learning:
there'sa huge advantage performance wise to use a tally or numbers table.
--Your Sample Table :
CREATE...
September 11, 2007 at 11:30 am
you are thinking about it wrong...you should create a new role that has db_datareader writes, and then any additional rights you want toa dd. don't try to change the existing...
September 10, 2007 at 12:02 pm
oops sorry i skimmed over that part.
SQL server will automatically use all availalble processors. if you had a 4 proc, but licensing for only two, you'd be out of compliance...
September 10, 2007 at 9:27 am
there's lots of links on microsoft on this;
licensing is per physical processor, not per virtual processor/core .
If the motherboard has a single socket in it, (if you could afford it)...
September 10, 2007 at 8:12 am
Assuming you have SQL server installed on your laptop, you should be able to open Query Analyzer, Press F8, which will open the object browser...find the database>> open the treeview...
September 6, 2007 at 5:56 am
won't make any difference as far as databases go.... they are backed up to a specific format for SQL 2005,a dn in a manner backwards compatible with non-service pack-ed 2005...
September 5, 2007 at 3:42 pm
yes, i mean run a trace in profiler, preferably against a test database, but it doesn't matter.
start a trace, and make them duplicate the error when the trace is running.
stop the...
September 5, 2007 at 1:51 pm
I doubt it's happening every time right? I always call these intermittent network issues;
it's nothing to do with the code or even with SQL server, but the network;
it could be...
September 5, 2007 at 1:18 pm
from some page on microsoft:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
SQL Server 2005 64-bit versions include support for extended systems, also known as Windows on Windows (WOW64). WOW64 is a feature...
September 5, 2007 at 12:01 pm
you said you were hyperlinking to the IttNumber; why can't you simply change the hyperlink to include the Id and the IttNumber? then you can obviously use it on the...
September 5, 2007 at 11:39 am
Viewing 15 posts - 12,451 through 12,465 (of 13,461 total)