SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• SQL brian teaser...

  I want to select a range of identity numbers (PK) like this SET @select = '1,10,5,15,18,20' Note: 1…

  Digs

  70 replies

  16 years, 2 months ago

  By: Jeff Moden

• write to text file using sql

  I want to write sql output of many queries to one file (that will be created by sql) I use bcp but …

  Ali.M.Habib

  8 replies

  16 years, 2 months ago

  By: Ali.M.Habib

• Insert date into table from spreadsheet

  We have a table in a database where HR information is automatically imported minus the hire date. I…

  JALB

  2 replies

  16 years, 2 months ago

  By: Elliott Whitlow

• SQL tables not accepting Inserts, Updates or Deletes by any means.

  At least twice a week I'm running into a situation where the SQL tables will not accept Inserts, Up…

  Thumperfla

  4 replies

  16 years, 2 months ago

  By: Gail Shaw

• Execute stored procedure in AFTER UPDATE trigger

  Hi there, I have a stored procedure I want to execute when some field in a table gets updated. So I…

  conversar

  3 replies

  16 years, 2 months ago

  By: conversar

• N00b SQLS2008 to SQLS2000 Syntax Problem

  Hi I'm using SQLS2008 and I need to target SQLS2000. I've generated a change script using SMSS' "Au…

  AndrewJacksonZA

  4 replies

  16 years, 2 months ago

  By: AndrewJacksonZA

• Problems converting Date to Numeric

  Good day all, trying to use the code below in order to convert a Date to a numeri…

  Mitch2007

  3 replies

  16 years, 2 months ago

  By: Mitch2007

• Link Access tables to SQL server

  I know how to link SQL server tables to Access. That's not the issue. I use data supplied by others…

  She Through Whom All Data Flows

  6 replies

  16 years, 2 months ago

  By: She Through Whom All Data Flows

• i want to get database name,database owner and database size in a single query(insted of sp_helpdb)

  Hi all, Thanks for quick reply...but in sysdatabases there is no coloumn for size of the database. …

  jayasree.lingala

  5 replies

  16 years, 2 months ago

  By: george sibbald

• SQL and Banner Systems (Orical 10g)

  I am relatively new to the Banner/Orical 10g platform and I am working on doing specialized queries…

  DBCOORD

  1 replies

  16 years, 2 months ago

  By: Steve Brett

• Select data from one table to another.

  Good day all, I am re-writing an existing Access app to SQL server 2000 and I ha…

  Mitch2007

  4 replies

  16 years, 2 months ago

  By: Steve Jones - SSC Editor

• Backing up File Folders sitting on Server

  Can SSMS 2005 backup file folders thats sitting on the Server? I have a folder where scanned docume…

  Marv_SQL

  1 replies

  16 years, 2 months ago

  By: John Rowan

• SQL Command Help with Case statement

  Hello All, Below is the SQL for getting the President Name when (Rank is 700) But also I want…

  kam7395

  5 replies

  16 years, 2 months ago

  By: GSquared

• Identity and uniqueIdentifier and custom id

  Identity and uniqueIdentifier and customid Is there any CustomID method where I can create my own I…

  Digs

  31 replies

  16 years, 2 months ago

  By: Digs

• Arithabort error when trying to query a view

  Hi Newbie here i'm afraid - I have a view in SQL 2000 that works (ie displays without error in En…

  geeb

  1 replies

  16 years, 2 months ago

  By: arun.sas