T-SQL

• Topics

  Started by

  Posts

  Last post

• Parameter syntax

  I'm working with some developers on a web service that must access data on both SQL Server and orac…

  Mardy Gazzo

  1 replies

  21 years ago

  By: Farrell Keough

• Simple Client Side SQL Capture Utility

  Hello All, I am new to the SQL server world so forgive me if I am asking things that are pretty bas…

  Bob Benishek

  4 replies

  21 years ago

  By: Bob Benishek

• Get text from parent table for 2 fields in child table.

  Hi I have a table containing contact details for people in a company (tblContacts). In a second tab…

  Brendan Collins

  8 replies

  21 years ago

  By: ron k

• Simple Transaction Question...

  I rarely right procedures as I typically provide adhoc T-SQL support.  However, that is changi…

  rhunt

  2 replies

  21 years ago

  By: rhunt

• Try to find duplicates, but creating LOCKS?

  Hi there, I'm trying to compare products listed in our customer database (CRM) to the live internet…

  Nicholas Wang

  5 replies

  21 years ago

  By: Gopal-49563

• How to select from database passed as param without dynamic sql?

  Hi,   I have a scenerio were I have various stored proc's which handle inserts, updates etc on…

  John Mason

  9 replies

  21 years ago

  By: AC Lupu

• Using In Statement in Stored Procedure?

  this is my stored procedure CREATE PROCEDURE sp_Test_FOR_InStatement @sStr as char(50) AS set @sStr…

  CMitesh

  6 replies

  21 years ago

  By: Jonathan

• dynamic sql problem

  Hi All,    When i execute the below piece of code in query analyzer its throwing error &…

  nsrao

  5 replies

  21 years ago

  By: Gail Shaw

• CASE in computed column

  I've successfully used the following statement in queries CASE WHEN TYPE='O' THEN ORGNAME ELSE LAST…

  Scott Bernardi

  5 replies

  21 years ago

  By: Scott Bernardi

• Using Filename as a variable & changing character date YYYYMMDD into a proper date

  Hi Folks, I am currently running a process that bulk uploads lots of files with the filename b…

  daveangel

  3 replies

  21 years ago

  By: Frank Kalis

• changing how data is returned and grouping

  Hello, I have a query that currently returns Code Name Project A Grade Hrs Day 5 Jones…

  orchidseb

  1 replies

  21 years ago

  By: Frank Kalis

• DTS Error Handling

  Hello, I need a bit of help.  I have a large data load issue.  The data comes from a lega…

  MUnderwood

  4 replies

  21 years ago

  By: philcart

• dump logs on a list of databses on an instance

  Is there a t-sql script to dump logs on a list of databses on an instance? Thanks!

  John Tabor

  1 replies

  21 years ago

  By: mdaniel

• Sum and Group by

  Hello, I am not sure where I can find anything about grouping by number. To be more specific : Tabl…

  Vichka

  8 replies

  21 years ago

  By: Vichka

• Adding constraint to very large table

  Hello, I ran the following statement in test and it took forever to run and the trans log grew by s…

  Vik Nat

  7 replies

  21 years ago

  By: noeld