T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• copying 1 table with indexes to another same server

  i want to create a stored procedure that allows a user to run it with the name of the table they wa…

  roy.tollison

  8 replies

  15 years, 10 months ago

  By: roy.tollison

• Split characters in a column and insert in new rows

  Hi , I am trying to split characters from a row and insert them one by one in new rows . I am inser…

  Aspg

  7 replies

  15 years, 10 months ago

  By: LutzM

• Removing duplicate rows with IDs in two columns

  Hello - I have a program which scans the database looking for possible duplicates by matching accor…

  dbursey

  5 replies

  15 years, 10 months ago

  By: dbursey

• Identifying a trigger

  Hey folks . . . I've set up a simple trigger, using the syntax as follows: create trigger [some tr…

  Ray K

  2 replies

  15 years, 10 months ago

  By: Ray K

• Alter PK to Cluster

  This PK has lots of foreign key constraints so I would like to not have to drop and recreate anythi…

  Mel3405

  9 replies

  15 years, 10 months ago

  By: jeff.mason

• Insert enddate using startdate

  HI, I have two date columns in table , startdate and enddate .Enddaet column is null currently .Now…

  Aspg

  17 replies

  15 years, 10 months ago

  By: Eugene Elutin

• date time diff

  i want the date differece to be showed as 05 days, 04 months, 04 year and my code is declare @d d…

  scottichrosaviakosmos

  5 replies

  15 years, 10 months ago

  By: David Dubois

• Table defintion SQL query

  Is there a sql command that displays a table defintion ? Ie columns and data types.... TIA

  chris.sennett

  1 replies

  15 years, 10 months ago

  By: Gail Shaw

• Export SQL data to XML format

  We have data in our SQL Server database that we need to export into an XML file to submit to a vend…

  Maxer

  1 replies

  15 years, 10 months ago

  By: Mike01

• Max count of rows per hour and minute (concurrent sessions)

  I have a table with the following: [start_time] --datetime ,[end_time] --datetime ,[duration] -- in…

  Cliff.Parker

  2 replies

  15 years, 10 months ago

  By: Eugene Elutin

• The multi-part identifier could not be bound - works in query not in function

  My query runs fine when I just run it in a query window in SQL 2008 mgmt studio, but if I try to us…

  MI-Jason

  5 replies

  15 years, 10 months ago

  By: Mohit K. Gupta

• List all SQL servers in multiple domains

  Hi There, Does anyone know how to list SQL Servers in multiple domains? I have a query which lists…

  allanro

  8 replies

  15 years, 10 months ago

  By: YSLGuru

• Binary Matrix table

  I have a table with 5 columns CERATE TABLE #tmpMatrix(a bit, b bit, c bit,d bit,e bit) and wants to…

  jagat.patel

  4 replies

  15 years, 10 months ago

  By: jagat.patel

• To seach a string in the entire database

  I am looking for a script that i can provide to a user so that he can search for a string the word…

  SQLTestUser

  2 replies

  15 years, 10 months ago

  By: Lowell

• Yet another FOREIGN_KEY / INSERT question

  Add this to the thousands of FK questions that have been asked! Here's the deal. I have an existin…

  Ray K

  11 replies

  15 years, 10 months ago

  By: mtillman-921105