RE: NULL values in source table don't add up
I'm not quite sure that I fully understand you, NPEETERS. Could you please expand a bit more on your suggestion. I appreciate your time and effort. Thanks.
2003-07-10
1 reads
events
RE: Backup and Restoring from on Server to another
I suggest reading the Books OnLine (refered to as BOL). It installs with SQL Server (Go to START>Programs>Microsoft SQL Server>Books OnLine). Go to the Index tab and enter: BACKUP DATABASE Read the information there and then enter: RESTORE DATABASE Both will also give examples. -SQLBill
2003-07-09
RE: vanishing databases and servers
no such joy i'm afraid. I'm actually working out of my apartment at the moment and it doesn't have a phone line. is there any way to fool it into thinking its connected
2003-07-08
RE: tempdb log ig growing
I have found the following link helpful in trouble-shooting this problem in the past: http://www.wamoz.com/giant_tempdb.asp
2003-07-07
RE: SQL 2000 Upgrade
You should run setup from SQL Server 2000 CD to upgrade SQL Server 7.0 to SQL Server 2000.
2003-06-18
RE: isql -S error
Quoted from BOL about the definition of instance. "There are two types of instances of SQL Server: Default Instances The default instance of the SQL Server 2000 database engine operates the same way as the database engines in earlier versions of SQL Server. The default instance is identified solely by the name of the computer […]
2003-06-11
RE: isql -S error
Thanks for the input. I may confused you guys by saying "named instance", actually from the server (say instanceserver) which is running named instance, I cannot run "isql -S otherservers", not to itself. and otherservers is ok to run "isql -S instanceserver" mworku, use Ip address get the same error.
2003-06-11
RE: paging - showing 10 records at a time, etc.
Use some key, order by the key, select the top XX where you are > last key. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-11
RE: Using variables within IN
DECLARE @SomeVariable varchar(10) SET @SomeVariable = '1,2,5' SELECT * FROM TableA WHERE CHARINDEX(CAST(ColumnB as varchar),','+@SomeVariable+',') > 0
2003-06-11
1 reads
RE: IF clause in cursor
quote: can I user If condition in cursor Yes, you can use it same as if you aren't in a cursor.
2003-06-06
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers