Development

• Topics

  Started by

  Posts

  Last post

• Whats are the Advantages of Filegroups in Sql Server 2005

  Whats are the Advantages of Filegroups in Sql Server 2005 ?

  zafar-458126

  16 replies

  17 years, 3 months ago

  By: Dugi

• Inserting Multiple Tables at Once

  Hi, What is the best way to insert data into multiple tables at once using the same unique Id? Exa…

  dale_keller

  6 replies

  17 years, 3 months ago

  By: Grant Fritchey

• Retrieve multiple rows in one row for the same ID

  Hi, I have an sql query that retrieves data for some ID where this ID has more than one data relate…

  obarahmeh

  2 replies

  17 years, 3 months ago

  By: GSquared

• Parent-Child Data

  Hi all, I've two tables Table -A ItemId SubItem Item1 Item A Item2 Item B Item3 Item C Item4…

  SRK-664851

  3 replies

  17 years, 3 months ago

  By: GSquared

• I want to see Report monthwise

  I have two columns in a table. First column as of Date type and another one is of number type.First…

  Manish Kumar-832207

  6 replies

  17 years, 3 months ago

  By: Manish Kumar-832207

• Can the foreign key and primary key be the same?

  Hi all, I have a main user table which stores basic information for which UserID is the primary ke…

  Kayal-717623

  3 replies

  17 years, 3 months ago

  By: Kayal-717623

• SQL Server choosing which index to use

  For simplistic purposes, if I have a table with multiple columns, and have the clustered index on c…

  KTG

  3 replies

  17 years, 3 months ago

  By: Gail Shaw

• Dumb Question

  Hi all, i have something like the below: declare @ss varchar(30) set @ss='ProductID' SELECT @ss …

  Kayal-717623

  46 replies

  17 years, 3 months ago

  By: ricardorv

• Count a value of a node in XML using FLOWR

  All, I want to count all the records where value of Code is "Minor". Does anyone have any suggestio…

  ahmadharis

  4 replies

  17 years, 3 months ago

  By: ahmadharis

• xp_cmdshell & PowerShell

  Hi, i having some trouble with following T-SQL Code This doesn't work: SELECT @Cmd = '"C:\WINDOWS\s…

  Daniel Casado

  7 replies

  17 years, 3 months ago

  By: GSquared

• commit interval

  We are loading about 1.8 million records from a flatfile. what should be the commit interval for lo…

  sabyasm

  1 replies

  17 years, 3 months ago

  By: Andras Belokosztolszki

• tO GENERATE SCRIPT FOR THE STRUCTURE WITH EXISTING TABLE DATA

  hi I want to generate a script,should contains both the structure and the data existing in the …

  patr

  1 replies

  17 years, 3 months ago

  By: Andras Belokosztolszki

• SQL 2005/Mgmt Studio won't close database on exit

  I created a database (development) and tables using Mgmt Studio. When I access the database using M…

  tdhall_75233

  15 replies

  17 years, 3 months ago

  By: Steve Jones - SSC Editor

• How to run a oracle sql script

  How to run a oracle sql script from remote maching using batch file. i am using a VB server from re…

  ruzanhizar2004

  1 replies

  17 years, 3 months ago

  By: GSquared

• returning values from a stored proc (or function?)

  I am trying to create a reusable proc that will generate network ids and passwords for people in my…

  tim densmore

  2 replies

  17 years, 3 months ago

  By: Grant Fritchey