SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Combine Queries

  Good morning All, I need to combine the two queries but there are certain records I need to display…

  kabaari

  4 replies

  16 years ago

  By: John Rowan

• help with after update Trigger

  Hi guys and girls! Im just entering the SQL world and i find it great. I´ve been asked to make an a…

  igngua

  3 replies

  16 years ago

  By: GSquared

• Sql Advanced Query

  Folks, Can anyone help me out to get the most of Advanced Sql Queries (Tutorials). Websites,article…

  lefrancisco1

  2 replies

  16 years ago

  By: Grant Fritchey

• Multi-Users and Stored Procedures

  I just saw a post on a forum that said if two users fire the same stored procedure at the same time…

  FredS-1001785

  4 replies

  16 years ago

  By: Grant Fritchey

• Search, No results, Give Suggestion

  Hi guys, I have a Search and Result pages in asp.net. If the user searched for a word but if he typ…

  monzulu

  1 replies

  16 years ago

  By: dbo.benyos

• Simple Oracle Store procedure

  Hi, I want to write simple oracle store procedure like in sql server. Is it necessary to use cursor…

  pandeharsh

  2 replies

  16 years ago

  By: DNA_DBA

• Database Names With Hyphens Issue

  Hi Folks can someone tell me why I am getting an error on this sql when i try it with a database na…

  JC-3113

  3 replies

  16 years ago

  By: GSquared

• ROW data repeating

  Good afternoon all and Thanks in advance! I would like to run the below code but I need the defects…

  kabaari

  2 replies

  16 years ago

  By: kabaari

• Clustered Index question

  Hi All, I am having some confusion over something I have read regarding clustered indexes and the …

  Ness

  8 replies

  16 years ago

  By: Ness

• Trying to build a generic Stored Procedure

  I have a simple Stored Procedure that returns a record set to my app. I would like to pass a param…

  FredS-1001785

  7 replies

  16 years ago

  By: Lynn Pettis

• Calculating the Second Sunday jus giving the month alone

  Folks, Hwo to Calculate the second sunday of the particular month Example -- the user input i…

  lefrancisco1

  3 replies

  16 years ago

  By: arun.sas

• Calculation Question

  Hi, I am learning SQL, and want to make some application code more database orientated. I am lookin…

  Matthew24

  6 replies

  16 years ago

  By: Matthew24

• Using INSERT/DELETE/UPDATE within a stored procedure called from INSTEAD OF

  When an INSTEAD OF trigger on a table calls a stored procedure that contains SQL which then acts on…

  david.c.holley

  2 replies

  16 years ago

  By: david.c.holley

• UPDATE table2 with value from table1 on INSERT into table1

  Good morning all, And thank i advance. I need to "UPDATE table2.ID with value from table1.ID on INS…

  kabaari

  6 replies

  16 years ago

  By: kabaari

• Confused Copying a Database on Same Server

  Hi Folks I made a copy of the Northwind database yesterday and called it comvault_test I checked in…

  JC-3113

  6 replies

  16 years ago

  By: JC-3113