Forum Replies Created
Viewing 15 posts - 2,101 through 2,115 (of 5,356 total)
-
RE: Connect from Linux/Solaris to SQl Server 2000
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: date range query
Also staying away from using CONVERT should perform slightly better, as SQL Server does not need to query the syslanguages system table.
Every litlle bit helps
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Change the name of the column
You should use sp_rename for this case.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Need some good design advice!
As per BOL the max number of table in a SELECT statement is 256.
Here is something from Inside SQL Server 2000
Multiple-Table Joins
According to some folklore, SQL Server "does not optimize"...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: xp_cmdshell
Yup, while
exec master..xp_cmdshell 'time' seems to hang
exec master..xp_cmdshell 'time/t' will work fine.
The only way I've found to start such a programm is to use DTS (yuk!) with a win32...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Need help creating dynamic "USE" statement... Thanks.
Having fun with more dynamic dynamic sql
DECLARE @stmt NCHAR(1000)
SET @stmt = 'USE Frank_3 ' + CHAR(13) + 'DECLARE @stmt NCHAR(1000)' + CHAR(13)...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: SCM Utility
There is an undocumented (for obvious good reasons
) xp in SQL Server named xp_servicecontrol. You can use it to start and stop...--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Building Sequence no
Just out of curiosity, James.
Why a UDF?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Table Id of table within a database
Take a look at OBJECT_ID() in BOL.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: can any one suggest me how to page the results of an SQL
http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Need some good design advice!
Why use a trigger?
If I understand you correct create relationships between the various tables.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: serious problem
The datatypes DECIMAL and NUMERIC are the same in SQL Server.
Will ...SET RMCPL_MD_POINTS= +@EchVpoin not work?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: serious problem
Change it to something like
SET @EchVpoin = 1/2.
or
SET @EchVpoin = 1./2
to force SQL Server not to assume that you want an integer result
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Building Sequence no
Quick and dirty, this should work
select Cust_No, Tel_No,
(SELECT COUNT(*)
FROM
WHERE Cust_No = s.Cust_No
AND Tel_No <= s.Tel_No) AS Seq_No
FROM s
This might also be interesting
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Taking parsed string and assigning variables without using a temp table
http://www.sommarskog.se/arrays-in-sql.html might give some ideas.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 2,101 through 2,115 (of 5,356 total)