SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• How to Assign values of a column to values of another column and insert these two values in a table

  Hi, Pls find below the code and the requirement that i need help on Code to create tableA and inser…

  royston_pledger

  2 replies

  17 years ago

  By: royston_pledger

• Replace values in a column with values from another column

  hi, For example , TableA TableB column1 …

  royston_pledger

  6 replies

  17 years ago

  By: royston_pledger

• how to create a flat file in client machine

  Hi, I WOULD WRITE A STORE PROCEDURE, WHICH WILL CREATE VIEW SCRIPT AS A FLAT FILE WITH EXTENSION .S…

  shamshudheen

  1 replies

  17 years ago

  By: tbeadle

• Trigger Help

  I'm really new at Triggers, I tried to do some research on my own, but was confused so I was hoping…

  mbender

  23 replies

  17 years ago

  By: toniupstny

• table(s) design for a particular problem

  Hi there, I have a design issue for how to best store data. I have two tables Bench and Index as f…

  Christopher Klein

  1 replies

  17 years ago

  By: Christopher Klein

• Using SQL Server Express from Access and Upsizing Wizard

  I have an existing Access data base with a lot of legacy code, and I recently posted asking for a "…

  notquitexena

  1 replies

  17 years ago

  By: Matt Miller (4)

• Is this query possible?

  Hi could someone please point out if this solution is possible or perhaps if I should consider an a…

  RynoB

  2 replies

  17 years ago

  By: RynoB

• Incorrect syntax near 'sp_detach_db'

  Hi all, in order to speed up the process of detaching a db (SQL2000), zipping it and attaching it a…

  Michael Baas

  4 replies

  17 years ago

  By: RBarryYoung

• Cannot add a primary key

  Hello all, I keep getting this error message when I try to right click a column and set it as prima…

  David Poluxt

  4 replies

  17 years ago

  By: RBarryYoung

• create xml file from tables for web services

  Hi, I am pretty new to XML and webservices. Basically I have a table that is loaded every few hours…

  andrew.fong

  1 replies

  17 years ago

  By: RBarryYoung

• calling a stored procedure(with no return parameters) from jdbc

  Hi, I have a stored procedure that requires two input parameters and no return parameter.. The proc…

  royston_pledger

  1 replies

  17 years ago

  By: royston_pledger

• Help with error messages

  Hi all! I'm new to sqlserver (using 2000) at $WORK and I've inherited a project that has been done…

  rbarlow-756272

  2 replies

  17 years ago

  By: Cliff Jones

• SQL 2005 Reporting Services with Services Pack 2

  I am new to SQL 2005, and just update it to services pack 2. Now the problem is that I want to ins…

  orlandodtorres

  4 replies

  17 years ago

  By: wilkimatt

• Connectionstring for SQLEXPRESS

  Hello I'm trying to make an application where I can import excel sheet to a datagridview in VB.NET2…

  Ven-712413

  2 replies

  17 years ago

  By: Ven-712413

• How to import XML data into SQL SERVER with batch?

  Hi, I am a dummy in programming, but I would need help in inserting multiple datasets into SQL Serv…

  glatz

  1 replies

  17 years ago

  By: RynoB