T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Recursive Insertion using SQL 2005

  Hi, I have a task where in i will send the ID in the below example ID=1 and i need to make a exact …

  dakshinamurthy-655138

  1 replies

  17 years ago

  By: RBarryYoung

• Help needed - How to insert / update / delete mapping table records automatically

  Hi, I am using SQL Server 2005. Through store procedure and ASP.Net web pages, I am doing all CRUD …

  nzkks1

  3 replies

  17 years ago

  By: nzkks1

• OPENQUERY

  I am new to coding in the TSQL environemnt at least in a complex manner. I have more of main frame,…

  rjern

  5 replies

  17 years ago

  By: rjern

• Select for xml

  Hi friends when i select from my Region Table like this: Select 'Region' as [xsi:type],* From Regio…

  dr_csharp

  10 replies

  17 years ago

  By: dr_csharp

• compare words of one string that are in another string in different order

  Hi I have the following table, and I want to obtain the IDs of the rows that have column1 with at l…

  isaac.bs

  1 replies

  17 years ago

  By: Florian Reischl

• Avoid the inclusion and removal of records from a table

  There is a table that needs to be manipulated but it requires controls to prevent the inclusion of …

  xavendano

  3 replies

  17 years ago

  By: RBarryYoung

• Avoid the modification of a specific field

  How can using a T-SQL triggers to prevent the modification of several fields that belong to a table?

  xavendano

  1 replies

  17 years ago

  By: RBarryYoung

• Trigger for updating date ?

  I have a web page for updating personal information that is connected to the table "tblPerson". An…

  dforsman

  9 replies

  17 years ago

  By: Steve Jones - SSC Editor

• Performance implications of writing to tempdb all the time

  Hi All, I was just wondering where SQL 2005 could help here in terms of improvements and new featur…

  Dean Jones-454305

  13 replies

  17 years ago

  By: noeld

• Need help with joining new table to existing query

  I have 3 tables with data as below. create table user_table ( userid int not null identity(1,1)…

  gyessql

  2 replies

  17 years ago

  By: gyessql

• Read from Text file

  I have a folder drop where apache server logs files are dropped. I need to periodically read the fi…

  psteja2000

  15 replies

  17 years ago

  By: Ramesh Saive

• Is it a proper indexing method for boosting performance?

  I am using SQL Server 2005. This is for an ASP.Net application. I am wondering how to boost query p…

  nzkks1

  4 replies

  17 years ago

  By: Florian Reischl

• KEEP COLLATION as it is

  Database Server has collation 'SQL_Latin1_General_CP1_CI_AS' but one table has one column with co…

  mayank jarsaniya

  2 replies

  17 years ago

  By: mayank jarsaniya

• Column values disappear after adding ORDER BY clause

  Hi All, Can anyone help explain the following behaviour: The following query works fine but isn't o…

  bryanpsmith

  5 replies

  17 years ago

  By: Lynn Pettis

• top row number within partition

  i am ranking a select using row number with partition. Is there a way of adding another colum that …

  Jules Bonnot

  9 replies

  17 years ago

  By: RBarryYoung