SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Trigger - accessing updated and deleted

  Below is the first part of my first attempt at a Trigger... I want to: * see if they entered a date…

  billross

  1 replies

  15 years, 6 months ago

  By: Matt Miller (4)

• Stored Procedure to determine status

  This is my attempt to create a stored procedure that returns a status based on conditions in other …

  billross

  5 replies

  15 years, 6 months ago

  By: billross

• Stored Procedure to determine status

  This is my attempt to create a stored procedure that returns a status based on conditions in other …

  billross

  1 replies

  15 years, 6 months ago

  By: Gail Shaw

• SQL 2000 Connection problem

  Hello people, I have a very big problem which I don't understand: Warning: mssql_connect() [functio…

  darkston3e

  5 replies

  15 years, 7 months ago

  By: Linda Johanning

• SQL 2000 DTS/Job Name

  Hi all, I would like to ask if how can I retrieve/is there a way I can get DTS/Job Name given only …

  Kicking_Fish0713

  1 replies

  15 years, 7 months ago

  By: Greg Charles

• new user login Problem

  I have installed SQL 2000 on my local system. Now i have added a new user login with no server role…

  lawanggina

  1 replies

  15 years, 7 months ago

  By: DNA_DBA

• Counting Days

  I have to provide a report that shows the number of days a project spent in various workcenters. I …

  chad_hainline

  3 replies

  15 years, 9 months ago

  By: Ron McCullough

• Cannot check vales returned from a function in a CASE statement

  quite a simple query i just want to check the scores before inserting them INSERT INTO Tablex(a,b,…

  kunal.bhattacharya.01

  3 replies

  15 years, 9 months ago

  By: ChrisM@Work

• Sending test emails - SQL Server 2005

  Hi, I am setting up notifications in SQL Server 2005 that will be triggered if a job fails. I want …

  jr-691257

  1 replies

  15 years, 9 months ago

  By: ksullivan