Forum Replies Created
Viewing 15 posts - 3,781 through 3,795 (of 5,356 total)
-
RE: how to tell if data is an int value?
Much ado about nothing ?!?
Hopefully correct, in German
'Viel Lärm um nichts!'
Before guessing any further we should let the original questioner let himself explain if the question is already answered or...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Formatting string
Sorry, this can't be done with T-SQL. This is presentational stuff that is done at the client.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: keep last three backups in a file.
quote:
is it possible (using t-sql) to do full backup of a database to a file so that it keeps only last three...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: VB.NetCentral.com
Although you may find plenty of VB (and VB.Net) sites around, I think it will be difficult to find a good community.
However, if you want to do in VB what...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Service:Determine current windows login user?
Hi 5409045121009
quote:
Got a service running and the service needs to determine if a user is login. Service is...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: What is the best way to learn SQL?
quote:
Expect no phone and it is limited to 1 user license. Went back today and looks like the CDs are no longer...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: how to tell if data is an int value?
After thinking one night over it (and, of course, your mail, Jonathan!) I must admit, I stand corrected.
The solution I've posted is not the best one for this given scenario....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SQL Querries
quote:
nice one,i was talking in general
and the precedences of select, from, where, etc.
tried to search on precedences only to find that *...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Check of Identity
quote:
In a stored procedure i want to check the table has got identity or not ,Plz suggest how can i do that.--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: how to tell if data is an int value?
quote:
Yes, we seem to have interpreted the question differently.I think the question was to evaluate...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: URGENT Manual statistics creation vs Autocreating
Now this is simple statistic.
If you sample contains the whole population you'll get an accurate result.
However, if your sample is large enough, normally >30 observations, your result will be...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: how to tell if data is an int value?
quote:
WHERE ISNUMERIC(STUFF(ColName,1,CHARINDEX('-',ColName),'')) = 1oops, sorry, haven't read that the string after...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: What is the best way to learn SQL?
quote:
Oralce will send you a free developer license copy of its' platform.is this true??? Fully...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Print a report
quote:
You are probably right, but I need it to print from within SQL Server.Are there any additional tools we can use
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: how to tell if data is an int value?
Hi,
not sure if this is what you want
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
DECLARE @i INT
DECLARE @sz1 VARCHAR(50)
DECLARE @vNIL CHAR(1)
DECLARE @bool BIT
--SET @sz1 = 'b'...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 3,781 through 3,795 (of 5,356 total)