SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Long runing Database Integrity Check after aborted index creation.

  Hi, I was wondering if I can get any advice on a problem we our having. An index was being created …

  Peacob00

  1 replies

  14 years, 2 months ago

  By: Shark Energy

• Service broker

  is there any way i can get the names of the queues from any table or something. i need to put all t…

  kritika

  4 replies

  14 years, 2 months ago

  By: Johan Bijnens

• To show data of items not purchased

  Hi Gurus, below is the data CREATE TABLE [dbo].[TT]( [Cust] [int] NULL, [Item] [int] NULL) GO INS…

  mathewspsimon

  3 replies

  14 years, 2 months ago

  By: mathewspsimon

• What happens when a database is created???

  I just wanted to know what exactly happens when a user defined database created?? Which entries are…

  Sgar...

  4 replies

  14 years, 2 months ago

  By: Gail Shaw

• BULK INSERT on Notepad txt file

  I've created a text-file in notepad containing [font="Courier New"]test1<crlf> test2<crlf&…

  anon 47318

  3 replies

  14 years, 2 months ago

  By: Welsh Corgi

• sql server agent

  I have sql server 2005 sql server agent is running my job which cmdexec is not run and i get error …

  shriya

  1 replies

  14 years, 2 months ago

  By: Welsh Corgi

• An unhandled exception has occurred in a component in your application

  Hi all, i need help.. About SQL SERVER 2008, when I attempt to create query a notification shows li…

  codenamekav

  1 replies

  14 years, 2 months ago

  By: LutzM

• DateTime or nvarchar

  Dear Friends, I know it seems Strange but please help me on this. My manager wants to change all da…

  ashkan sirous

  13 replies

  14 years, 2 months ago

  By: Rich Mechaber

• Will a composite PK be used in future queries

  Will a composite PK be used in future queries (JOIN/WHERE) if only 1 of the 2 columns is used. I a…

  whattheETL

  9 replies

  14 years, 2 months ago

  By: PaulB-TheOneAndOnly

• probem with declare

  hi, please help Need some help, i´ve this query --------------------------------- DECLARE @_type I…

  carlos cachulo-318532

  18 replies

  14 years, 2 months ago

  By: Jeff Moden

• Preventing Repeated Results in Query

  Hi, I am running a query that joins two tables. The results are returned in duplicates - Is it poss…

  cajun_sql

  5 replies

  14 years, 2 months ago

  By: Orlando Colamatteo

• Need Help with Logic

  Hi Friends, My possible result sets(o/p) from joining two tables are Possible o/p 1: c1 c2 c3 1…

  rara

  2 replies

  14 years, 2 months ago

  By: SQLBOT

• Gerenciador de relacionamentos entre tabelas

  Boa tarde galera, tudo bem? Seguinte, estou precisando de uma ferramente que identifique o relacion…

  levi_emix

  3 replies

  14 years, 2 months ago

  By: SQLBOT

• when you do Union all, does the order of the columns matter? (sql server 2008))

  when you do Union all, does the order of the columns matter?

  applebutton

  5 replies

  14 years, 2 months ago

  By: Gail Shaw

• need some group by multiple rows help

  Hi, My group by query returns this (based on my table with mulit columns and rows with 0 values): A…

  chukostar

  3 replies

  14 years, 2 months ago

  By: bopeavy