Forum Replies Created
Viewing 15 posts - 1,576 through 1,590 (of 5,356 total)
-
RE: ODBC
Hey, you've edited your post
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: ODBC
To add to this, I don't see a PWD argument, or am I missing something
What about having a look here: http://www.connectionstrings.com/
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: How to insert an image
Glad to see it works.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Insert a text file in a BLOB Field
See, if this helps:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: RAID configuration
Still I would go for the second option. And make sure you have a good backup and recovery concept.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: VB function to SQL UDFunction - Working Days
Actually it would make sense, among other things, if you would use the DATETIME data type for @BeginDate and @EndDate.
And probably even more easier would it be to do a...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Left pad field
There is no Left pad function as this can be considered a presentational issue you have
Try this: DECLARE @MeineZahl INT
SET @MeineZahl = 99
SELECT
REPLACE(STR(@MeineZahl,10), '...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SQL Server 2005 Features
To add to Steve:
Search my site for 2005. Returns 21 links. Too much to post here. Probably another really interesting one is that to the Beta newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Extended Stored Procedures question
Extended stored procedures are not stored in any table. They are usually in a DLL file. You can find this out by running something like this:
USE master
GO
EXEC sp_helpextendedproc...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Better way to Update only those values changed?
And Frank, what are you doing drinking California Zinfandel? They make it a couple of miles east of here, but didn't you guys invent it?
AFAIK, is Zinfandel "the" classical American...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Mandatory photo at 1,000 posts?
With age comes wisdom
...but you still run faster, or what?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: RAID configuration
I would use the second configuration, but change it to RAID 5, or even better RAID 10 for data files. In any case separate tempDB on its own array.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Exit From sp
RETURN ?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Mandatory photo at 1,000 posts?
Nice one, Dave.
Btw, I am younger than you and have more hair
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Mandatory photo at 1,000 posts?
Is that better?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 1,576 through 1,590 (of 5,356 total)