SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Converting Row by Row inserts to a single Set Based Insert

  I have a cursor that is used to take data from one table, convert it, and then insert it into anoth…

  Martin Davies-966230

  2 replies

  1 year, 9 months ago

  By: pcfd

• Newbie question

  Hello experts, I'm not a SQL newbie as such. I'm an "accidental DBA" who's been working with SQL Se…

  webrunner

  2 replies

  2 years, 8 months ago

  By: Jeff Moden

• Programmatically copy stored procedure to another db

  I am developing an app that will provide a separate database for each subscriber. When a new databa…

  stuthedog

  3 replies

  4 years, 1 month ago

  By: ztelmis1

• informix 12.10 in a procedure, putting multiple queries on conditions in the loo

  I have a procedure like that: CREATE PROCEDURE PROCEDURE1 (var1 type1) INSERT INTO TEMP select * fr…

  dt128

  1 replies

  4 years, 5 months ago

  By: irgp

• Explanation of Page Splits

  Q1 -- I have read quite a few articles on page splits and am looking for clarification. Am I correc…

  stevec883

  6 replies

  4 years, 9 months ago

  By: Jeff Moden

• Expanding Knowledge

  Ahoi, ive been working with SSIS and SSAS (only Multidimensional, not Tabular) for 1 1/2 years now.…

  ktflash

  1 replies

  5 years, 5 months ago

  By: Brahmanand Shukla

• Employee Time Clock

  I'm working on our first "complex" database. I have two tables. One with for an Employee database w…

  John C. Marx

  7 replies

  6 years ago

  By: mikek4030

• Table Designs

  Hello, I am very new to SQL and am in the process of building my first database.  I have one d…

  kenfred88

  9 replies

  6 years, 11 months ago

  By: sgmunson

• Can I connect to a Centura SQLbase from Excel2013?

  Hello,I am a total idiot about this, so sorry for my simple questions. We have a program (Bewator o…

  peter.hermansson

  1 replies

  6 years, 12 months ago

  By: Sue_H

• Dynamic expression in a view

  Hi all,I have a question. I have a table with a query saved in a column.I want show in other column…

  blade832

  11 replies

  7 years ago

  By: Gail Shaw

• Cursor with multi "Exec sp_executesql @var1 , @var2" error ;-(

  Hello, I have a table with multi-row select statements, and I want to insert the results into a new…

  juliosousa90

  2 replies

  7 years, 1 month ago

  By: juliosousa90

• T-SQL Equivalent to Oracle TRANSLATE

  Hi, everyone.  I'm converting a SQL script from our old Oracle-based Lawson application t…

  Jose Johnson

  15 replies

  7 years, 2 months ago

  By: arr.nagaraj

• 'Cannot join on Memo, OLE, or Hyperlink Object' Error

  I have some SQL in the code of one of my reports that calls fields from linked (SQL) tables and som…

  gomikem

  5 replies

  7 years, 2 months ago

  By: Siva Sham

• What would I do t0 become a DBA?

  Hi I've a masters degree in computer application.I would like to become a database administrator. W…

  bindya_praveen2006

  4 replies

  7 years, 9 months ago

  By: Mr. Brian Gale

• Modify Check constraint

  How to modify an check constraint on a table other than dropping and re-creating, can any one help …

  ttparavindh

  6 replies

  7 years, 12 months ago

  By: drew.allen