from http://www.windowsitpro.com/Article/ArticleID/14025/14025.html

there's a difference between a primary key, which technically can span multiple columns, and a column that has the identity function on it to auto generate the next value of...

i didn't think actual database backups were labeled with a version... i thought only the server had an @@version, and the data was always backed up to an 8.00 version,...

In our shop, we have an application that uses either a SQL Server or Oracle database. As a result, we have lots of dev servers with SQL or oracle, or dev...

i'm under the impression that SQL7 must be installed first as a default instance.

after that is installed, you could install either/both SQL2000 and SQL 20005 as named instances on the...

i think any error raised with a level above 16 would fail, so in any script, you could simply add this line:

 RAISERROR ('Testing to see if a job fails for...

it also looks like the variables required are available in the third function; in that case it might look more like:

FROM (SELECT * FROM dbo.

the problem is your FROM statements in function 3:

FROM dbo.fnWTRCenPrtDivData INNER JOIN

dbo

.fnWTRTerrierData ON fnWTRCenPrtDivData.

create function ufn_test(

@name1 varchar(30)='Walmart',

@name2 varchar(30)='cookies')

returns varchar(255)

BEGIN

return 'I go to ' + @name1 + ' to buy ' + @name2

END

GO

SET NOCOUNT ON

select dbo.ufn_test (default,default)

select dbo.ufn_test ('Sears',default)

select dbo.ufn_test ('Sears','wrenches')

typically you get the results of a function like this:

select dbo.fnWTRCenPrtDivData(param1,param2)

if any of the parameters are supposedly optional, where they assume a value, you need to use the...

there's a few issues here:

a stored proc isn't going to return a set or records from a different database unless you explicitly refer to the database:

select * from master.dbo.cities

if itis...

almost, i replaced every </TD> with &nbsp;</TD> as there are a few places where the cells have no contents; they render as <TD></TD>, so they don't look right in the...

I found that to be a great script as well; the only change I made was adding a &nbsp; to the closing </TD> tag so that cells didn't appear wierd...

could you add a check constraint that says column2 must be less than or equal to column 1?

that would prevent 3,2 or 2,1 from inserting.

that way you enforce the order...

isn't this kind of situation used when you have multiple locations using the identical database, and you need to merge the databases back together at some point? also, i thought...