T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to read text file into SQL Table

  Back in Oracle 10, I had developed a solution based on treating a text file as a SQL Table. Now I h…

  BOR15K

  7 replies

  15 years ago

  By: BOR15K

• How to reduce the execution Time In Indexed T-SQL

  hi, I am having table which contains more than 5,00,000 records. Using where condition i retreive …

  brainblower13

  2 replies

  15 years ago

  By: Bhuvnesh

• Strange Query Which I Can't Seem to Join On

  This is a query I pulled from SQL Profiler: SELECT invoice.contactid, invoicedetail.invoiceid, RecT…

  mpartridge

  2 replies

  15 years ago

  By: mpartridge

• FROM OPENROWSET - (failed to retrieve text for this error. Reason: 15105).

  Hi all, I'm having some issues when executing the following SQL; SELECT BulkColumn FROM OPENROWSET(…

  InvisibleCat

  2 replies

  15 years ago

  By: Jim McLeod

• stored procedure help in dynamic SQL

  select template_id, template_name, template_content, template_group, template_section, delete_ind, …

  njdevils39

  1 replies

  15 years ago

  By: Sean Lange

• Change user by variable

  Hi All, I need to create more than 30 views at a time, for that I have written some automation scri…

  arup chakraborty

  3 replies

  15 years ago

  By: Orlando Colamatteo

• proc on a view quicker than the same proc with table joins

  hi, i was working on a huge complicated proc and later realised that may be i can use base tables d…

  ekant_alone

  3 replies

  15 years ago

  By: SQLRNNR

• use a if/update with in the initial select statement

  Hi I have a table of data that contains the following. I need to do a select on the table that ass…

  LoosinMaMind

  1 replies

  15 years ago

  By: Orlando Colamatteo

• Normalization Question

  I have a system here that is refreshing data and storing multiple values in an odd way (and I have …

  Mike Scalise

  22 replies

  15 years ago

  By: GSquared

• sql server 2008 sql

  I would like to know the following: 1. What t-sql can I use to see if a stored procedure has change…

  diane_r_stein 91368

  4 replies

  15 years ago

  By: Orlando Colamatteo

• Applying TRANSACTION for DDL statements

  Hi Guys, I had this understanding that the DDL statements are autocommit statements and i…

  AJ07

  2 replies

  15 years ago

  By: AJ07

• Dúvidas sobre CTE

  Olá, Tenho uma tabela com vários registros e gostaria de colocar na mesma linha exemplo: data…

  plansoft

  1 replies

  15 years ago

  By: mazzz

• table not using index

  Hi, we have a table named "Employees". It has fields company, empno, active and some additional fie…

  Sridhar-137443

  8 replies

  15 years ago

  By: Jeff Moden

• How to filter out the string via CHARINDEX?

  Hi, Is there anybody help me take a look at the CHARINDEX operation below, I want to filter out the…

  lindsaywang

  4 replies

  15 years ago

  By: lindsaywang

• deadlocks on sql server

  Hi, Iam facing a this probelm first time ever. Having deadlocks every 15 mins or so. The problem he…

  ekmatra

  6 replies

  15 years ago

  By: Grant Fritchey