Forum Replies Created
Viewing 15 posts - 4,561 through 4,575 (of 5,356 total)
-
RE: Converting hex to int
Hi timingskey,
quote:
The following qry returns hex values. I need to know if there is a way to convert the hex values... -
RE: Capture user info
Hi Carl,
quote:
I have added a column to a table (Userid) and am trying to capture the user id of the user inserting... -
RE: return TOP
Hi gofrin,
quote:
I have this problem, I need show data from DBon HTML page. But in DB I have lot or record,
so for...
-
RE: Bad practices
quote:
I'm assuming blind panic took over for awhile
Don't ask!
-
RE: Bad practices
Hi Ritch,
quote:
Thats a classic!!yes, now I can laugh over this!
Cheers,
Frank
-
RE: Optional search conditions
Hi Tomi,
quote:
I have a search page on my website where people can enter lots of search conditions. They can also leave all... -
RE: Bad practices
Hi Ritch,
quote:
I was thinking (and yes it hurt) that as this is a fairly big forum which has a lot of consolidated... -
RE: Best practice when to use an index Part II
Hi James,
quote:
It is kind of the same reasoning as a bit field not needing an index.It is assumed the majority of...
-
RE: Identity column on result set
Hi Jeremy,
quote:
Is there a way of creating an identity column, or similar, on a result set?I have the situation where I am...
-
RE: Optional search conditions
Hi Tomi,
quote:
Not that it's any easier but would sp_executeSQL also be a good alternative? I mean, to build up the query dynamically.... -
RE: Optional search conditions
quote:
Thanks, Frank!Yes, I know I can specify a default value to parameters in a SP. That's what I've done with my example:
-
RE: Numbering the ResultSet - Equivalent of Rownum
Hi accent-atlant,
quote:
Do you test it on 1000000 row??? I have slow perfomance...
I guess it should...
-
RE: Import Excel to SQL hangs when Spreadsheet is open
Hi Karen,
quote:
I have a DTS package that imports an Excel spreadsheet into a SQL table (and then executes a stored... -
RE: SQL Newie needs help
Hi Jigsam,
quote:
So it is possible its just hard to do and time consuming? An SQL insert statement couldnt just chuck it where... -
RE: Best practice when to use an index Part II
Hi Steve,
quote:
1. no index used, full scan required.2. no index used with functions
3. no index used
Viewing 15 posts - 4,561 through 4,575 (of 5,356 total)