Well, the field itself will simply reject any date that isn't in the correct format but if you had a stored procedure to do some bespoke error handling you could...

Yes, continuous push replication. Only the tables are replicated.

I solved the problem by removing the triggers but the idea that the inserted table contains NULL values in the field...

If you are adding an IDENTITY field to an existing table this suggests that the table doesn't already have a primary key and doesn't link to anything. It may...

It is a convoluted subject and one I don't fully understand myself.

It was covered in an article in SQL Server Standard by one of the Brians.

The gist of it is...

The biggest problem is where someone tries to write a query to access a specific user table that is not their user table.

As you know SELECT * FROM Authors will...

No it is not valid syntax.

You could try creating a view and then indexing that.

UPDATE poz

SET tip='k'

FROM pos INNER JOIN juridic ON poz.con = juridic.con

WHERE juridic.dosar='p'

Pass your colleges in as a delimited string and use the following function

CREATE FUNCTION dbo.fnSplitDelimited ( @sInputString1 VARCHAR(8000) , @sSplitChar CHAR(1))

RETURNS @tbl_List TABLE (Id1 Int PRIMARY KEY )

AS

BEGIN

DECLARE@lInputStringLength1Int ,

@lPosition1Int ,

@lSplitChar1Int...

The approach is also useful in modular applications. For example you may have 3 modules that can run as discreet applications but can also run as a single master...

COUNT(*) or count(1) returns a count of all records including NULLS.

COUNT(expression) returns a count of all non-null records.

The first two don't seem to have any performance difference or differences in...

No, this isn't true. Dinar's solution is to bounce the records through a table variable with its own identify variable and this would be sequential.

I have applications that use several separate databases, in fact using multiple databases per application is fairly standard in the world of content management systems.

I would be very careful about...

I would do it using a college table

* CollegeId,

* CollegeDescription

I would either have a separate table to maintain the Parent/Child college relationship

* ParentCollegeId

* CollegeId

or I would put the ParentCollegeId in...

The thing that is hardest for a non-US citizens to appreciate is that the US is, near as damn it, a continent rather than a country.

If the US built a...

So if I understand you correctly you have two locations, for the sake of argument we'll call them demo and live.

At demo you have

* A web server

* A SQL server

At...