T-SQL

• Topics

  Started by

  Posts

  Last post

• Using sql_variant as a parameter

  I have to write a proc that updates constants used in my website. On my ASP page I know what kind o…

  Rob Reid-246754

  9 replies

  20 years ago

  By: Rob Reid-246754

• For script guru''s

  I have a database with nearly 1000 tables.  Several of the tables have a specific column.…

  fizzleme

  4 replies

  20 years ago

  By: fizzleme

• Pass a parameter in a stored procedure

  I need to create a stored procedure that imports Application IDs from another sp instead …

  Alice Sanders

  1 replies

  20 years ago

  By: Ray M

• Multiple rows into a variable

  Hi all. I saw this done in a Script O' The Day, but I can't find it.  Basically I need to stor…

  eljeffo

  5 replies

  20 years ago

  By: Sean Scott

• Help me with this t-sql

  Hi Db Gurus, I have table with this following data 100000133 100000217 343 100000323 1000…

  babuganesh2000

  9 replies

  20 years ago

  By: Jeff Moden

• selecting count(*) from a table into an int variable

  ive been trying this a number of ways; Declare @numRows int select @numrows = select count(*) fr…

  winston Smith

  3 replies

  20 years ago

  By: Andreas AJV

• selecting from a table name in string format

  is there some way to allow this to execute, using a function or something?:   select * from 'c…

  winston Smith

  2 replies

  20 years ago

  By: winston Smith

• Stored Function Tables

  Hi All, Can anyone tell me what is Stored Function Tables in Sql Server. Thanks in ADVANCE, Regards…

  VivekKumar Gupta

  19 replies

  20 years ago

  By: Vee

• Your Opinion about the... SQL syntax

  I see (so far) that most of the Topics concern questions about 'how can i do this in SQL...' a…

  Andreas AJV

  5 replies

  20 years ago

  By: Steve Jones - SSC Editor

• How to determine the Key columns of a view.

  the INFORMATION_SCHEMA tables get me alot of information but i can't find anything to determine the…

  Jake Peters

  2 replies

  20 years ago

  By: Jake Peters

• Calling a Linked Sever

  Hey Guys, I need some help I have 2 SQL Server 'servers', one is connected to the orther through a …

  Felipe Dalorzo

  2 replies

  20 years ago

  By: Felipe Dalorzo

• Count with a Union

  I have this query SELECT     cs.Name, COUNT(req.RequestId) AS Total, imp.UserId…

  LuckyInc

  6 replies

  20 years ago

  By: Farrell Keough

• Joining 2 Tables and Eliminating the Redundant Data

  Hi All, I have a following scenario Table A usr city jo sf jo la Table B usr city …

  Jol

  1 replies

  20 years ago

  By: Sameer Raval

• Question about using SoundEx to find Client Name Duplication

    I have a Client list of about 175,000 plus records.  It is not my own.  We are sur…

  Farrell Keough

  4 replies

  20 years ago

  By: Wavesailor

• free online SQL Formatter

  http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.htm This free online SQL Formatter is a&…

  james-312924

  3 replies

  20 years ago

  By: Patrick Folan