ok it looks like you want to keep track of multiple results, but you wanted separate tables...

rethink the logic a bit;

why not create ONE table, and add one column CalledResultSet,...

--sql doesnt have an instrRev function, but separate functions you can combine to do the same thing:

--so you have to use substring and reverse:

declare @str varchar(1024)

set @str = '/pna/v3/pg/product/manual/display/0,,2076_15221_49434,00.HTML....

i use this to find tables or columns that contain some string all the time;

usage: sp_find Customer

CREATE procedure sp_find       

@findcolumn varchar(50)       

as       

begin       

 set nocount on       

 select sysobjects.name as TableFound,syscolumns.name as...

Here's my take:

no backups are a sign of an in-experienced DBA, or a developer who happens to have to wear the DBA hat. Unfortunately, he's been lucky up till now hiding...

As i understand it, the database is it's own self contained unit, and doesn't have info about other instances that exist;

There's a few metadata functions, like  SELECT @@SERVERNAME,@@SERVICENAME,@@VERSION ,...

I'm curious as to why you think you need to update the system tables directly anyway. What are you trying to accomplish? there might be a better way to do...

because there is no central source which captures which servers exist, you can't really query it.

you can ask the operating system to poll all the servers that are advertising...

OK, if you look at the procedure, it's pretty much getting two values for each companyId: the sum(moneyamount) and the sum(number of shares)

you can get the same information from a...

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...

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...

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...

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...

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...

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...

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...