T-SQL

• Topics

  Started by

  Posts

  Last post

• GRANT ALL

  I don't understand why when I use the following Syntax: GRANT ALL TO PUBLIC after I have created ob…

  chandlbj

  4 replies

  22 years ago

  By: David Burrows

• access temporary table in a user defined function ??

  Hi All ,        I have a store procedure SP1 who is using a temporary ta…

  georgia

  4 replies

  22 years ago

  By: tymberwyld

• eliminate duplicates

  Please help in SQl 2000 How do you return the first record for each ID in a select query. I Have a …

  eily

  6 replies

  22 years ago

  By: eily

• Update table, easy question

  I am trying to update the Appointment table as follows: UPDATE Appointment @ApptID Datetime SET Che…

  smknox

  2 replies

  22 years ago

  By: smknox

• Use of contains with image data types

   I made a full text index over an image column in conjunction with a string column which retai…

  Stefan Ardeleanu

  3 replies

  22 years ago

  By: Jonathan Tomkins

• Transforming rows to name value pairs

  Hi, Does anyone know where I can find a link to some sample/example code to transform fields from …

  Allan Ferguson

  1 replies

  22 years ago

  By: rockmoose

• xp_cmdshell

  hi all, SQL Server 2000 SP3 Windows 2000 Server i want to execute an application through sql. i use…

  Ramesh Kilputhur Sridharan

  5 replies

  22 years ago

  By: Kenneth Wilhelmsson

• Auto Re-Compile SP and Views Possible?

  When a new field is added to a table, all the Views and Stored Procedure that is using that table n…

  johna1

  1 replies

  22 years ago

  By: Angela But

• how to get inserted records on the basis of inserted dates

  i dont have date column in the tables, but i want to retrieve records who are 1 month old from the …

  sukhoi971

  5 replies

  22 years ago

  By: Robert Stewart

• Check if date range is available?

  Hi, I have a problem with generating script that will check during insert that my new date interval…

  shepetovka

  4 replies

  22 years ago

  By: shepetovka

• Update Statement

  Greetings All,   I have a table (tableA)  With Columns (FileNumber, WeekNumber,Departemen…

  iadams

  6 replies

  22 years ago

  By: iadams

• Orderlines into columns dependant on positive or negative quantity

  Hi I need to create an excel report from the next table (SQL 2000) : Columns are like orderlines &n…

  jvElecenter

  2 replies

  22 years ago

  By: ZenDada

• Report

  I have a table like Mydate COL1 COL2 COL3 4/1/2004 2.3 7.6 10 4/2/2004 …

  rs

  6 replies

  22 years ago

  By: rs

• Need some good design advice!

  I have a table with many columns whose values should exist in the various look up tables. Example..…

  ekalos

  4 replies

  22 years ago

  By: Frank Kalis

• Using Cursor Help

  Hello. I am trying to run a sql statement using a cursor. Checked the syntax and in QA and doesn't …

  cmartinz

  4 replies

  22 years ago

  By: cmartinz