T-SQL

• Topics

  Started by

  Posts

  Last post

• Deleting records from table

  We run on a Windows 2000 Advance Server SP4/ SQL 2000. I'm writing a scripts (below) to delete reco…

  antonio.reyes

  6 replies

  13 years, 10 months ago

  By: Lynn Pettis

• SELECT TOP 50 Percent not returning 50 Percent

  Ran accross this and can't figure it out. Why does this return 8 rows and not 7? I can limit the …

  ehlinger

  8 replies

  13 years, 10 months ago

  By: ehlinger

• Change DEFAULT value for a column

  I have a column: ALTER TABLE dbo.bat_Batches ADD Version int  NOT NULL CONSTRAINT DF_bat…

  Richard Lesh

  7 replies

  13 years, 11 months ago

  By: MKKAMIL

• Where to find ignore dup key in system tables

  Hello, Does someone know where to find 'ignore_dup_key' parameter for an index in SQL 2000 system t…

  daniel.gueguen@netamine.fr

  13 replies

  13 years, 11 months ago

  By: Ninja's_RGR'us

• HOW TO TRANSPOSE COLUMNS TO ROWS USING T-SQL

  I am still new in t-SQL.  i have a table which i would like to transform its columns into rows…

  allan audi

  10 replies

  13 years, 11 months ago

  By: Jeff Moden

• converting special charectors to positive or negative numbers

  I’m dealing with a situation where I import data from file. many columns contains negative or posit…

  kutemom09

  10 replies

  13 years, 11 months ago

  By: David Lester

• DATE Datatype issue

  Hello Friends, ..I am working on a column and want to give ""DATE"" datatype not the ""Datetime"" f…

  sqlquest2575

  1 replies

  13 years, 11 months ago

  By: drew.allen

• Finding the next date after a start date that is a certain day of the week

  Hi all, Been trying to figure out a decent way of getting the next specified day of the week from a…

  kangarolf

  8 replies

  13 years, 11 months ago

  By: Edward Boyle-478467

• Need Better Way of Converting Rows to Columns

  Can someone please tell me what I am doing wrong? I am using SQL Server 2008 and I am looking for …

  AeroNC

  5 replies

  13 years, 11 months ago

  By: AeroNC

• Error converting data type DBTYPE_DBDATE to datetime.

  Hi all ..Please help..This has been driving me nuts.. I have a linked server is SQL to a Pervasive …

  Ray Waldron

  4 replies

  13 years, 11 months ago

  By: Sergiy

• Expensive Query and missing indexes

  I have following query running very very slow. Though I have some indexes created on this table but…

  Kay1632

  3 replies

  13 years, 11 months ago

  By: Gail Shaw

• Extracting Documents (.pdf, .doc, .xls, etc) stored in image type fields in multiple rows

  Hi, We have a legacy database in SqlSERVER 2005 where documents of all types have been stored. We …

  nancy g

  13 replies

  13 years, 11 months ago

  By: Sean Lange

• how to join two tables with non equal conditions?

  I have two tables: create table #A(aYr int, aCol int) insert #A(aYr,aCol) values (2008, 2) insert #…

  sliu

  3 replies

  13 years, 11 months ago

  By: Cadavre

• Using the INTERSECT command in a function

  Is there a way to write this without an intermediate variable? CREATE FUNCTION dbo.CreditOverlap ( …

  SQLOzzie

  6 replies

  13 years, 12 months ago

  By: SQLOzzie

• difference between unquie and PK constraint

  I understand that unique constraint makes sure that each values in a column are unique (allows no d…

  JakeSA

  2 replies

  13 years, 12 months ago

  By: JakeSA