T-SQL

• Topics

  Started by

  Posts

  Last post

• Where is it best to place "where conditions" in the join or inthe final where statement

  Is it best practice to ensure filtering is done at the time of an inner join or at the end with a f…

  firthr

  19 replies

  22 years ago

  By: Kenneth Wilhelmsson

• Displaying serial nos for output rows.

  Hi, I want to know if there is any possibility to add a column for a dynamically constructed sql qu…

  lucky-80472

  1 replies

  22 years ago

  By: Kenneth Wilhelmsson

• Raising custom messages: a procedure and a trigger.

  I have a stored procedure. The stored procedure made an update on a view. Let's say that the view i…

  Stefan Ardeleanu

  7 replies

  22 years ago

  By: Kenneth Wilhelmsson

• Trying to import a text file via a trigger

  Hello there, I'm new to this forum, and also to SQL Server. I'm trying to customise a (compiled) th…

  Di Strapps

  3 replies

  22 years ago

  By: Di Strapps

• Format Files?

  Hi every Body I'm trying to do a Bulk insert from a text file containing this kind of dat…

  ouertani neked

  1 replies

  22 years ago

  By: bp

• New To Triggers

  I have two tables [tbl_Contracts] and [rev_Contracts] the records in tbl_Contracts are updatable vi…

  millersmith

  2 replies

  22 years ago

  By: millersmith

• need help with a select cursor

  I am trying to pull some data from two tables that share a foreign key.  I am not having much …

  Stephen Harris

  1 replies

  22 years ago

  By: Stephen Harris

• Table Name Qualified Differently in Subquery gives Incorrect Result

  Hi, I've got 5 versions of a query that we think ought to return 9 rows.  But one version, th…

  anndstevens@gmail.com

  5 replies

  22 years ago

  By: Jonathan Tomkins

• Copying table structures without inheriting identity property

  Select top 0 or using a where 1=0, whether using a field list or *, seems to ALWAYS copy the identi…

  cmore

  3 replies

  22 years ago

  By: cmore

• FETCH NEXT problem

  Hi Im having a bit of problems with this script: declare @sourcetable table (nr int, tekst varchar(…

  Ahlforn

  4 replies

  22 years ago

  By: Razvan Socol

• Transact-SQL Debugger

  I used to be able to step through the SP's, but now the debugger runs the sp without the ability to…

  Tad

  10 replies

  22 years ago

  By: Rohit @ SQL

• catch 22 query

  I have a problem whereby I need to update a table using set based sql. The update gets its info in …

  SteveB-74825

  9 replies

  22 years ago

  By: SteveB-74825

• select query in CDNOTS

  Hi, I was using xp_sendmail to do this: ___________________________________ declare @query_string =…

  shoayb

  1 replies

  22 years ago

  By: philcart

• Conditions for return codes

  I have a calling procedure that loops through 5 possible searches to produce a result set. Bas…

  demicoq

  2 replies

  22 years ago

  By: demicoq

• Auto-Reporting all constraint violations in an import

  I'd like to get a sanity check on this, and any comments regarding 'been there done that watch…

  cmore

  5 replies

  22 years ago

  By: Jeff Moden