Viewing 15 posts - 16 through 30 (of 5,355 total)
mithun.gite (12/31/2008)
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...
December 31, 2008 at 3:28 am
nazaninahmady_sh (12/31/2008)
alter PROCEDURE Garhasbi1
@Cat1_Value int,
@Cat2_Value int,
@Date_Time datetime
...
December 31, 2008 at 2:14 am
nazaninahmady_sh (12/31/2008)
I wrote a Store Procedure:
-- ================================================
alter PROCEDURE Garhasbi1
AS
BEGIN
declare @Cat1_Value int
declare @Cat2_Value...
December 31, 2008 at 1:53 am
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...
December 30, 2008 at 2:13 pm
metro17 (12/30/2008)
Eg of a few primary keys...
3BQWDL0000K0
3BQWEB0000K0
3BQWEX0000K0
Is there any formula behind it that is generating this ? If so how do I...
December 30, 2008 at 2:07 pm
pvc (12/30/2008)
OK i find it myselfSTR(FIELD1) does the job
STR() without any length argument gives you a 10 character result where the string is padded with leading blanks. You probably would...
December 30, 2008 at 8:22 am
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...
December 30, 2005 at 5:10 am
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...
December 30, 2005 at 5:06 am
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...
December 29, 2005 at 8:49 am
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...
December 29, 2005 at 6:05 am
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. ...
December 29, 2005 at 3:51 am
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.
December 29, 2005 at 3:50 am
Check out "Maximum Capacity Specifications" in BOL.
December 28, 2005 at 3:02 am
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.
December 28, 2005 at 2:58 am
Viewing 15 posts - 16 through 30 (of 5,355 total)