I would like to download the SQL Server 2005 Hands-On lab material. I downloaded and installed SQL Server 2005 and the SQL Server 2005 Beta 2 Resource DVD. I never got the following directory structure that is referenced in the hands-on labs: C:\SQL Labs\.... The download location of the ...more >>

I am very new to sql, and have been managing by making queries in Access and tweaking the sql as needed. This one I can't figure out, though. It seems to not like my ">" or "<" . Getting "incorrect syntax near '<'." What's wrong?? Thanks in advance. SELECT TOP 100 PERCENT aipdn.Data0...more >>

Hello, I am totally new to SQL Server and need to learn from ground zero. So I downloaded the SQL Server 2000 Evaluation Edition, and would like to get a feel for the software. Can I work with this without having a dedicated server. I currently work with Microsoft Access and work off our co...more >>

I am a NEWBIE at this as I am stepping up from A2k. In A2k the autonumber used as the primary key allows formatting in which text can be used. Does MS SQL Server 2000 allow it as well? If so how does one go about it? Several A2k databases are also being considered for upsizing and they hav...more >>

Hi I am getting an error message from the following query using Crystal reports 8.5,win98OS,SQL Server 2000. Your help is really appreciated Error message : Syntax error near }. Can I use oj syntax twice in a query??? SELECT DISTINCT National_Oxygen_TEST_Customer."Name", Nation...more >>

Can anyone advise me of the syntax for getting a summary count ? This is a sample of the procedure if you can help, CREATE PROCEDURE PlannedPaymentas begin delete from pp_detail delete from pp_master insert into pp_detail(FULL_CHECK,VENDOR_CODE,TRANSACTION_NO, TRANS_AMT,disc...more >>

Is it possible to add an instruction to rollback the entire procedure, if any part of the procedure fails ?...more >>

Hi i am running the following query generated using crystal reports 8.5 designet,win98,sql server 2000. i get the following error message. i am not sure where i could put the alias for the table "The column prefix sales_cr_memo_header does not match with a table name or alias used i...more >>

Hi all, Im writing a product using MS-SQL, using a Magic as my programming language. When I execute a large process (such as a backup, or a long running query) through a Magic task, the user has to sit through a blank screen while it runs though processing. The problem is that the task ...more >>

hi :) ! hello every body i want to learn Sql Server so plz i want to know how to do create a new table in sql server if any one help me and also give me site about sql server because i want to learn it and to be very well of sql Server ...more >>

Are there any good tools in SQL Server 2000 for generating test data to populate a database? Or do I have to look for third party solutions? Any suggestions welcome. Jim ...more >>

I want to change some Databases' name. But the only way I know is backup the database, and change another name when recovering it. Is there any other way that is easier than that below? thanks zlf ...more >>

does anyone know how to get SQL Enterprise manager to display a field that currenly shows <Long Text>. Is there a Cache setting some where ... or another way to get it to display those fields with TONS of data? i want to edit the data through Enterprise manager but cant when it shows <long...more >>

Hello. I had a table with identity column set to datatype [smallint]. I've reached near 32800 records. That's the limit for [smallint]. So, I've changed the identity datatype to [int], that SHOULD allow me to have more records. But the error continues. "Arithmetic overflow error convertin...more >>

Any thin good book as an introduction to the SQL Server? Particularly I need a manual for OSQL and for security under Windows XP Pro. I have problems with managing accounts, permissons and remote data connectivity....more >>

Hi, I am trying to access data from a Sage Line 100 database to populate tables in SQL 2000. If I use the following syntax in Query Analyser I only get the first row of a table returned: select * FROM OPENROWSET ('MSDASQL','DSN=SageLine132',UID=admin;PWD=;','select * FROM STO_DEPOT_NA...more >>

ok i am basically searching a field for a piece of text then replacing it with new text heres what i have (it works BUT) UPDATE tablename SET columnname = REPLACE ((SELECT CAST(columnname AS varchar(8000)) AS columnname), 'text looking for', 'new text') that will work.. however, t...more >>

Could anyone direct me to the " how to use binary data"? Thanks, Jim...more >>