Forum Replies Created
Viewing 15 posts - 4,051 through 4,065 (of 5,356 total)
-
RE: I would like to create a function that......
aargh, missed the point with the function.Sorry about that!
Like NPeeters said it won't work. After executing your statement your variable is out of scope. So you...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: I would like to create a function that......
Hi lenardd,
quote:
How would you code something like this in Dynamic SQL? I basically want to grab the value of the field...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Thanks for this site ! Any similar for DB2
quote:
When somebody else is spending the money, well I suppose there is nothing you can do. Often though if you present a...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: New Discussion Forum
quote:
20 minutes to figure that one out! Snitz, gotta love it. You have to insert rows into the subscripion table. Why would...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: CSV Nesting and Parsing
quote:
Kindly do not suggest normalising the table(s) as I wish to resolve it as is.any...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: New Discussion Forum
Subcription possible?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: I would like to create a function that......
Hi,
quote:
I would like to create a function that retrieves the value of a field by passing the string name of the table...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: A way to prevent users from using QA or EM?
Hi Cindy,
quote:
Why do you need to lock down access through Query Analyzer/Enterprise Manager? If it's to prevent users doing things outside the...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Query to get first number
quote:
Gee, that's a lot of budgets. You, know, the IDENTITY field was designed for this. It would be a LOT...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: A virtual drink for everyone !!!
quote:
Frank - could the camera have been farther away from everyone and still be in the room?--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: QOD 29/08/2003
Hi Thierry,
quote:
[ all connections except the one ] is not equal to [ everyone ]I...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Query to get first number
Hi reeder17,
quote:
We have a script to get the first available ID number in a table. We are looking for a faster way...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: DBA Atributions
quote:
I visit that part of the forum but are few job posting that didn't help me. I am relatively new to this...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Arithmetic overflow
quote:
Could somebody help me, an application givefollowing message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 32768
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: A virtual drink for everyone !!!
quote:
I think I'll start counting from the other left sideSo do...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
aargh, missed the point with the function.
Viewing 15 posts - 4,051 through 4,065 (of 5,356 total)