Database

cdotpal wrote:

BTW the primary key in my table is of integer type.. so I expect it would be over 11 billion or so

Frank Kerrigan wrote:

for an integer indentity column you'd only get 2 Billion rows as it'll only use the positive side of the Integer

Frank Kerrigan wrote:

I was going to get an int table and fill it with more than 2 billion rows, but that seemed rather sad just to prove my point

Colin Angus Mackay wrote:

Yes, very sad indeed.

ma se wrote:

Shipping (1) -- (M) ShippingInShippingType (M) -- (1) ShippingType

(1) -- (M) is one to many.

I am trying to get the shipping name from the Shipping table, together with the shipping type information.

FROM
  ShippingType
    INNER JOIN ShippingInShippingTypes 
      ON ShippingType.ShippingTypeID_PK = ShippingInShippingTypes.ShippingTypeID_FK
    INNER JOIN Shipping 
      ON ShippingInShippingTypes.ShippingID_FK = Shipping.ShippingID_PK;

FROM Shipping INNER JOIN
 ShippingInShippingType ON Shipping.field = ShippingInShippingType.field INNER JOIN
ShippingType ON ShippingInShippingType.field = ShippingType.field

<br />
use northwind<br />
<br />
DECLARE @MyLike nvarchar(50)<br />
DECLARE @mySQL nvarchar(200)<br />
<br />
<br />
SET @MyLike = '''%AN%'''<br />
<br />
SET @mySQL = 'SELECT * from Employees Where FirstName Like '  + @MyLike <br />
<br />
exec sp_executeSQL @mySQL<br />

<br />
<indentity impresonate="true" userName="username" password="password"><br />