mithun.gite (12/31/2008)

---

sir

i got my first question answer but still my two questions pending

2) is it really true that we cant create two text column on single table?

3) and please...

nazaninahmady_sh (12/31/2008)

---

i tried to correct it:

alter PROCEDURE Garhasbi1

@Cat1_Value int,

@Cat2_Value int,

@Date_Time datetime

...

nazaninahmady_sh (12/31/2008)

---

Hello,

I wrote a Store Procedure:

-- ================================================

alter PROCEDURE Garhasbi1

AS

BEGIN

declare @Cat1_Value int

declare @Cat2_Value...

yogesh.balasubramanian (12/26/2008)

---

I want to know whether there are any other methods? Since by this method we are restricted to nVarchar max which is 4000. Some of my dynamic queries goes...

metro17 (12/30/2008)

---

Data type is char(12) does not allow nulls .

Eg of a few primary keys...

3BQWDL0000K0

3BQWEB0000K0

3BQWEX0000K0

Is there any formula behind it that is generating this ? If so how do I...

STR() without any length argument gives you a 10 character result where the string is padded with leading blanks. You probably would...

Choose one from TINYBLOB to LONGBLOB.

Given that much NVARCHAR(50) columns it looks llike a ported Access database. Do you really need

- Unicode

- Columns of that width?

To me it seems that many columns can be narrowed...

and if there is a primary key it will count based on that

That's slightly incorrect. COUNT(*) will scan the narrowest available index on that table. This is not necessarily...

select rows

FROM sysindexes WHERE indid IN(1,2,255)

and object_name(id) = 'TableName'

This is usually a good guess at the number of rows, but there's no guarantee that the reported number is correct. If...

Not necessarily. I think.

Consider this

USE Northwind

DECLARE @dt DATETIME

SET @dt = '19960701'

SELECT OrderID, CustomerID

  FROM Orders

 WHERE OrderDate = DATEADD(DAY,7,@dt)

SELECT OrderID, CustomerID

  FROM Orders

 WHERE DATEDIFF(d,@dt,OrderDate)=7

The resultset...

I would suggest you rewrite your SQL into ANSI accepted standards.  Using commas instead of explicitly using JOIN and since you are using commas you don't use the ON clause. ...

DATEDIFF will effectively rule out the use of an index to improve performance. Not the brightest outlook on a large table, if you ask me.

Check out "Maximum Capacity Specifications" in BOL.

Kenneth, I see what you mean, but I think the OP made a copy and paste error as the results of 2. is exactly the base data.