The default constraint will only work on inserts not updates. The code sample below demonstrates this.

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_TEST_CONSTRAINT

(

TC_ID INT IDENTITY(1,1) NOT NULL

...

As a quick fix, add a HOST entry for the server on the client...

Quick thought, look at sys.partitions and sys.tables

😎

If I remember correctly, Itzik Ben-Gan wrote an article on paging result set, both with and without offset fetch, suggest you look at it.

😎

Edit: added link.

karthik82.vk (8/31/2014)

---

Hi,

I have a data of 100 PostalCodes and parcels associated with it. Each postal code will be having multiple parcels. My aim is to find the count of parcels...

This is more for fun than being an attempt to solve the problem, although the code can easily be amended to produce the desired results. It uses an inline Tally...

Here is an alternative method without recursion, uses Tally table type looping instead. The code uses Chris's sample data to produce comparable output. It is simplified and limited to that...

TomThomson (8/30/2014)

---

Eirikur Eiriksson (8/30/2014)

---

sharonsql2013 (8/30/2014)

---

I am trying to do an average with the following case statement

Select

AVG(Case when TotalHours < = 60 And TotalHours > 0 then TotalHours else...

sharonsql2013 (8/30/2014)

---

I am trying to do an average with the following case statement

Select

AVG(Case when TotalHours < = 60 And TotalHours > 0 then TotalHours else 0 end)AVGWithin60

AVG(Case when...

Just in case you missed this from the previous instance of the question, modified to return blank if no HardDrink

😎

USE tempdb;

GO

SET NOCOUNT ON;

CREATE TABLE #TEMP (T_ID INT IDENTITY(1,1),UserName varchar(20),Drink varchar(20),Value...

Shadab Shah (8/29/2014)

---

Hi Experts,

There would be a better solution then , the one mention above by me.

If some body has it would be great to know. Just to improve on...

Can you ping the servers in both directions from each other using the server names, not the ip address (oops that sounds twisted:-))?

😎

The Menu (translated to SSC'lect)

Post and Spam

Post,...

Greg Edwards-268690 (8/30/2014)

---

Jeff Moden (8/29/2014)

---

Ok... the dust bunnies are in an uproar and the hunt is on for "lost sock" as the only possible source of the leak for the...

First thought and if I remember correctly, set the NetworkDtcAccessTip (Transaction Internet Protocol (TIP)) to 1. Do check on technet though as my...