General

• Topics

  Started by

  Posts

  Last post

• Help with date function

  I have a table that has x number of records. I need (for reporting purposes) a query that will ret…

  Vik Nat

  2 replies

  22 years ago

  By: Vik Nat

• Freeware Client Utility for SQL Server 2000?

  Hi I need a freeware client utility for DMO operations to connect to a SQL Server (2000). Any sugge…

  sridharj_ap

  6 replies

  22 years ago

  By: Ferguson

• Using Multiple Databases

  I was wondering if it was possible to use two MS SQL databases for one App. I have a customers db w…

  lmod

  2 replies

  22 years ago

  By: lmod

• DB Maintenance Plan

  Hi! What are the most important options I need to include in creating DB Maintenance Plan? Like how…

  rivendell

  3 replies

  22 years ago

  By: rivendell

• COUNT(*) returns incorrect count

  send: bit column (updated daily) select count(*) from table where send = 1 11.5 million rows drop a…

  Oscar Zamora

  8 replies

  22 years ago

  By: Oscar Zamora

• display date in format mm/yy or mm/yyyy

  I'm pretty new to SQL programming (as you will probably be able to tell with my question). I need …

  NyteeKnight7

  2 replies

  22 years ago

  By: NyteeKnight7

• Debuging

  Ia m running stored procedure in debugging mode and instead of going line to line debugger just goe…

  nalrud

  3 replies

  22 years ago

  By: K. Brian Kelley

• Shared Memory Error

  when i connect to query analyzer i get Error: [Microsoft][ODBC SQL Server Driver][SHARED MEMORY]Sql…

  sqlquery-101401

  3 replies

  22 years ago

  By: Allen Cui-55137

• SQL Standard versus Entreprise edition

  Hi all, I have a question: do you know about articles that will point out clearely the advantages o…

  tulcanla

  3 replies

  22 years ago

  By: tulcanla

• Insert Dupicates: Stored Proc vs. Trigger

  Hello All, I have a table with about 100000 rows. When someone is inserting SSN on the ASP page I i…

  barsuk

  2 replies

  22 years ago

  By: noeld

• Returning Null Results

  I have a table with 54 million rows. When I run this query: select count(*) from search_results whe…

  GeoffOs

  2 replies

  22 years ago

  By: GeoffOs

• Remote Connection through VPN

  Hi there, today I tried for the first time to connect to SQL Server via telephone line and VPN. I r…

  Frank Kalis

  12 replies

  22 years ago

  By: Frank Kalis

• Saving Database Diagram as JPEG?

  I created a database diagram for my database; and i need to find a way to view it outside of SQL Se…

  deek

  2 replies

  22 years, 1 months ago

  By: noeld

• Retrieve Binary data from binary data type

  hi all expert, Can i know, how to retrieve the value from binary data type by using VB6.0 and using…

  KenChen

  2 replies

  22 years, 1 months ago

  By: KenChen

• Using EXISTS to find a temporary table

  I'm working on a stored procedure which uses temp tables. Since I often get things wrong multiple t…

  blackblade

  2 replies

  22 years, 1 months ago

  By: blackblade