salliven (5/14/2013)

---

I'm managing more Microsoft replication.

But Microsoft replication is slow and inflexible. Our replication program is fast and flexible (example: maximum 0,5 sec replication latency,...

Something like this?

It assumes that all the values for INCOMING_VALUE will be numeric.

select right('00000' + cast(CAST(INCOMING_VALUE as int) as varchar(5)), case when CAST(INCOMING_Value as int) > 9999 then 5 else...

How do you know that? I am not disputing it, I am curious if you know that as...

rightontarget (5/14/2013)

---

Hi all,

I've copied a database to a new server. How do I make database on original server inaccessible to users while I am checking that everything is OK with...

PSB (5/14/2013)

---

Hi,

I have a query where it returns exact same value for all fields except 1 field.

Example

CREATE TABLE #Temp1 ( recid int identity (1,1),SiteID INt,TankID INT,TNo INT,PDate DateTime,Gallons INT,Status1...

By setting the compatibility mode. You can right click the database in object explorer -> Properties ->...

That is how it works salliven. When you manually insert values into an identity...

Sapen (5/14/2013)

---

Sean Lange (5/14/2013)

---

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and is effectively doing...

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and is effectively doing the same thing...

OK I am trying to help you but you don't seem to want to put in even as much effort as I do. You are getting paid for this and...

Didn't we just go through the do's and dont's of posting yesterday? Can you please post some ddl and sample data along with desired output?

I did it for you yesterday....

jjgier (5/14/2013)

---

Hey Everyone,

I have a set of IF THEN logic that create additional fields. Does anyone have a great grasp of how to convert the attached examples from IF...

I absolutely agree with Eugene that this is not a good idea but you can work with by using your own reseed.

CREATE TABLE #table (id int IDENTITY (1,1), col1 int)

INSERT...

If it is an update you after it would be something like this:

Update YourTable

Set Country = 'GB'

where Country IS NULL

lenar.chavez (5/14/2013)

---

Hello. I'd appreciate help with a bit of code that can help me retreive data from one table in my DB.

The issue here is that on the same table...