SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Check for Record SP

  Just a quick easy question for you guys: In an SP, the author has the following syntax: IF EXISTS (…

  smknox

  3 replies

  20 years ago

  By: Ninja's_RGR'us

• SQL Newbie - warning message

  I'm in the process of moving over from Ms2000 to SQL, I'm using a ms adp as my front end. What my p…

  Michael Graves

  2 replies

  20 years ago

  By: sushila

• Issue with Sum of field from two table

  Hello friend! I am facing the problem in the query. I have sql server 2000 on windows xp plateform.…

  Basit Ali Khan

  12 replies

  20 years ago

  By: Basit Ali Khan

• alternative method of copying SP''s

  Hi,   I want to copy all of the Stored Procedures in one dbase to another. I have used the imp…

  paul welsh

  6 replies

  20 years ago

  By: Phil Yardley

• Using ISNULL with a Convert

  I need to convert the DateTime from a table.  So far have this... CONVERT(varchar, n.TestDateT…

  in2nat

  2 replies

  20 years ago

  By: ron k

• Uploading a file - page cannot be displayed

  hI,   We have an asp front end on an sql dbase. We upload .sta files on a regular basis. I hav…

  paul welsh

  1 replies

  20 years ago

  By: Phil Yardley

• sql2000 + isa2004 on same box

  so basically what i got is win2003, sql2000 and isa2004 all on one box and with two network cards p…

  Rob G-147384

  1 replies

  20 years ago

  By: lionshome

• Preventing Return Values from Nested SPs.

  In the SP below I call an existing SP within the main SP to assign a FY to a variable with I use in…

  fryere

  9 replies

  20 years ago

  By: Farrell Keough

• How do I run a Sql Profiler trace from the command Line

  Morning people, I've just spent some time building a trace  to be rolled out to several Server…

  Paul Pennock

  1 replies

  20 years ago

  By: sswords

• Need help with query

  I have a table that contains several columns. However, I am only concerned with two of them:  …

  hmbtx

  7 replies

  20 years ago

  By: hmbtx

• The best way to handle look up tables

  I am working on an ADP project with SQL 2000, my clients will be connecting mainly through WAN. I h…

  Sherif Maamoun

  4 replies

  20 years ago

  By: Sherif Maamoun

• HELP PASSWORD VALIDATION HELP

  Hi All, For some reason my SQL server will not allow any one to connect. My server starts right up.…

  Chewy

  1 replies

  20 years ago

  By: Ninja's_RGR'us

• Suggestions Please "[37000][Microsoft][ODBC SQL Server Driver][SQL Server] Could not complete cursor operation because the table schema changed after the cursor was declared."

  Hi recieving this error message does anybody have any advice in order to overcome this issue? &nbs…

  Martin-223426

  5 replies

  20 years ago

  By: Rick Phillips-220796

• dlookup

  I've got a dlookup problem, i'm working on an adp recreating from an mdb. I've got a main form call…

  Michael Graves

  1 replies

  20 years ago

  By: Michael Graves

• Is there a way to simulate VBPropercase function in SQL server functions or procedutes

  I need to simulate the VB Proper Case function to capitalize first letters of names entered by user…

  Sherif Maamoun

  3 replies

  20 years ago

  By: Sherif Maamoun