SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• SQL 2000 and the Domain controller

  In setting up a new Microsoft SQL 2000 server, does that server need do be added to the domain? Can…

  Joe Orlando

  6 replies

  19 years, 9 months ago

  By: Rudyx - the Doctor

• Problems with error handling...

  Hello! I am new to SQL Server and I am trying to save the error if there is one, and some more info…

  Derek Jander

  16 replies

  19 years, 9 months ago

  By: sushila

• Dumb question about using < in a select statement

  I'm new to sql server, but queries in other servers allow this: SELECT clinno, ssn, dateof, IIF…

  Jim Muir

  5 replies

  19 years, 9 months ago

  By: scking

• Regarding EM.........

  Hi!! I have some query about Sql server.. When we enter in sql E.M , If I right click on any table…

  Papillon

  1 replies

  19 years, 9 months ago

  By: sushila

• A table with only one column

  I am designing a DB and am struggling which is the best way to define the lookup tables. The scenai…

  huaxing wu

  4 replies

  19 years, 9 months ago

  By: Steve-3_5_7_9

• Newbie Feeling Inadequate!!!

  OK, I am a very good designer in MS Access. I am also pretty good using ASP and VBScript (well, I u…

  Nicholas J. Phillips

  8 replies

  19 years, 9 months ago

  By: Gift Peddie

• OPENROWSET from SQL Server to AS400

  I am trying to duplicate an Access pass-thru query on SQL Server 2000, but I need help with the syn…

  George Lassiter

  1 replies

  19 years, 9 months ago

  By: Jo Pattyn

• SQL statement question

  Hi Gurus, Here is a simple question: I have a table with columns as StockId TransactionId Amount MS…

  bhavna dalal

  4 replies

  19 years, 9 months ago

  By: Farrell Keough

• run series of scripts

  I have about 40 or 50 scripts to run on my database, one of which is causing all records in one tab…

  smknox

  2 replies

  19 years, 9 months ago

  By: Ian Goethert

• How to capture errors in Stored Procedures

  I have a Delphi application that uses ADO to call SQLServer 2000 stored procedures. When errors oc…

  James Chan

  4 replies

  19 years, 9 months ago

  By: DCPeterson

• cursor that uses its stored procedure''s parameter

  I wrote a SP that contains a cursor. This cursor needs to use the SP parameter for the cursor …

  Duc Tran-261305

  2 replies

  19 years, 9 months ago

  By: Duc Tran-261305

• debug a SP

  I am trying to become familiar with the debugger in SQL server 2k. I open QA, select the SP I want,…

  smknox

  5 replies

  19 years, 9 months ago

  By: Brett Stinson

• 4000 varchar field - efficient if data is 6 char or 1000 char???

  Using SQL 7 Question: will the database automatically truncate the field to the size of the data st…

  Jason Carlson-261159

  1 replies

  19 years, 9 months ago

  By: Farrell Keough

• Store pdf etc in Image Column

  Hi, I want to store a file (probably .pdf or text) in a table. I presume that I should use an Image…

  dec_obrien

  2 replies

  19 years, 9 months ago

  By: dec_obrien

• Migrating To Active Directory

  Hi We have a couple of SQL Server boxes which are part of an NT domain structure, some using Window…

  Mick Campbell

  2 replies

  19 years, 9 months ago

  By: dbuchan