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...
-
RE: Formatting string
Sorry, this can't be done with T-SQL. This is presentational stuff that is done at the client.
Frank
-
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... -
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...
-
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... -
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... -
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....
-
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 *...
-
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. -
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...
-
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...
-
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...
-
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...
-
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
-
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'...
Viewing 15 posts - 3,781 through 3,795 (of 5,356 total)