General

• Topics

  Started by

  Posts

  Last post

• Completing a list box with a stored procedure

  Hello, I'm finding how to complete a list box in an Access Project with a stored procedure, whiwh h…

  jremaud

  1 replies

  23 years, 6 months ago

  By: Klaas-Jan

• Creating view dynamically ?

  What is wrong with this sp -------starts here -------- CREATE procedure [GP_MC_Analysis_Vw] ( @Use…

  gvphubli

  3 replies

  23 years, 6 months ago

  By: paras_98

• Paging with SQL & ASP

  I am using ASP as the frontend and using ADO Recordset to page records. While I use paging, I get n…

  paras_98

  1 replies

  23 years, 6 months ago

  By: Andy Warren

• Includes in Query Analyzer?

  In Oracle sqlplus, you can run a script that calls other scripts using the syntax: @<filename>…

  mpsmyth

  5 replies

  23 years, 6 months ago

  By: mpsmyth

• Can we write triggers on system tables

  Hello experts can I write triggers on system tables I tried to write by it gave an error .. is ther…

  gvphubli

  2 replies

  23 years, 6 months ago

  By: Steve Jones - SSC Editor

• Building / Executing a Select statement

  I'm using a stored procedure to build a complex Select statement based on parameters passed to it. …

  funkcommander

  2 replies

  23 years, 6 months ago

  By: funkcommander

• Moving data between databases using ASP

  Hi, I am using ASP to extract information from a database on a remote server (SQL 7) and updating/i…

  Jeff Maahs

  3 replies

  23 years, 6 months ago

  By: Andy Warren

• SQL Mail...

  Hi all, Im new to SQL Mail. When I say xp_startmail, i get a message 'Server: Msg 17952, Level 18…

  parasu

  2 replies

  23 years, 6 months ago

  By: K. Brian Kelley

• Truncation of decimals in a crystal reports report

  We have made a Crystal report report with an ODBC connection to an SQL server database. We see that…

  andre luijkx

  1 replies

  23 years, 7 months ago

  By: Andy Warren

• Find a record with a dual Primary Key

  I have established an ADO connection to a SQL Server database. However, I'm having problems selecti…

  trapezetom

  7 replies

  23 years, 7 months ago

  By: Andy Warren

• Select into #temp_table and deadlocks...

  I just noticed that some stored procedure code creates temporary tables on the fly using select int…

  Ripple

  4 replies

  23 years, 7 months ago

  By: GRN

• limitation

  Hi, I run a insert into a table in SQL SERVER 7.0 with help of a select that run over a couple of …

  sica

  2 replies

  23 years, 7 months ago

  By: Andy Warren

• Passing a value out of a Stored Procedure

  I've created this procedure to count the number of times a particular condition was met in a log fi…

  actinicblue

  2 replies

  23 years, 7 months ago

  By: Ripple

• insert/update image datatype column

  Hi, someone can show me how can I insert/update a row containing an image datatype column ? Table: …

  sergio hi

  1 replies

  23 years, 7 months ago

  By: Andy Warren

• Syncronisation of DataBases

  Hello experts, I have built a small application with database[25 tables] on SQL server now what I w…

  gvphubli

  1 replies

  23 years, 7 months ago

  By: Andy Warren