T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Sp to find and replace data in the email column

  Hi, I need to write a SP which is used to find the old email id which we pass and replace with the…

  anjan.ashok

  7 replies

  18 years ago

  By: Grant Fritchey

• Rollback Trans

  I am trying to test performance for a store proc which does many inserts and updates on the tables.…

  Mike Levan

  1 replies

  18 years ago

  By: JWOL

• Counting child rows in related table in 'main query'

  Hi, From with in a query on a parent table, I want to get the number (COUNT) of related rows in a c…

  Rich Caine

  4 replies

  18 years ago

  By: Mark Cowne

• How to find latest executed query in sql server 2000

  hi ... How to find latest executed query in sql server 2000 regards ..

  Rohan -708182

  7 replies

  18 years ago

  By: Gail Shaw

• Select value from parent table.

  CREATE TABLE TEST1 (B1 int PRIMARY KEY,B2 varchar(20)) CREATE TABLE test (A1 int,A2 int REFERENCES …

  Ashwin M N

  4 replies

  18 years ago

  By: Ashwin M N

• Restrict EXEC permisisons on a stored proc

  I have a stored proc that I only want one user (and the dbo) to be able to EXECute. This doesn't wo…

  Barkingdog

  1 replies

  18 years ago

  By: RBarryYoung

• Need help with % in a search

  I have this code: :IF UserInput(100,100,450,350,"Gimme your information!",{"nCLIENTPO,50,200,150,50…

  Angela S.

  3 replies

  18 years ago

  By: GSquared

• Best way to select same table twice within same query, once as "lookup table"?

  I have a table BOM containing two fields, ALLOY and MATERIAL, which contains all possible materials…

  Gilles Willard

  3 replies

  18 years ago

  By: Gilles Willard

• Query using SUM and MAX()

  I am having a brain freeze. I really should know how to do this, but the old thinker isn't working …

  lduvall

  11 replies

  18 years ago

  By: lduvall

• WHERE clause

  I'm trying to filter my WHERE clause: WHERE (c.CustomerID = '3942') AND (ol.DetailTableID '6…

  hayess-788389

  5 replies

  18 years ago

  By: Jeffrey Williams

• Showing the records random

  Dear All, I'm looking for a way to query the table's records absolutely in random in different time…

  zoroufi

  4 replies

  18 years ago

  By: Jeff Moden

• Query in two tables involving chars

  hi,i'm developing one software in ASP.NET/VB.NET using SQL Server 2005 and at this moment i need to…

  nandoliveira

  7 replies

  18 years ago

  By: Matt Miller (4)

• T-SQL CONTAINS

  I have created a function which has varbinary and keyword as varchar(100) as parameters. I need to …

  umaramiya-724626

  5 replies

  18 years ago

  By: Mauve

• datetime: 1245-03-05

  Hi there, Is it somehow possible to insert dates in a datetime column which are earlier than 1753 A…

  dankwart menor

  22 replies

  18 years ago

  By: Gail Shaw

• Function blows up when used with a timestame starting with a zero

  ALTER FUNCTION [dbo].[convertFloatDate] (@date float) RETURNS VARCHAR(20) AS BEGIN declare @ADateti…

  jarceri

  2 replies

  18 years ago

  By: SwePeso