T-SQL

• Topics

  Started by

  Posts

  Last post

• Query from other database

  I have two databases Db1 and Db2 i want to select all * from a table from db1 on the same server. I…

  msaleem

  2 replies

  23 years ago

  By: jarick

• FOR UPDATE cursors

  Server: Msg 16957, Level 16, State 4, Line 4 FOR UPDATE cannot be specified on a READ ONLY cursor. …

  edbarengo

  1 replies

  23 years ago

  By: Gabor Nyul

• Read only query

  Are there any way in t-sql to make a recorset read only. The users should not be able to edit the r…

  Larsi1971

  4 replies

  23 years ago

  By: Gabor Nyul

• Performance Hits

  I'm building a form which takes way too long to load up over the WAN. The user needs to navigate t…

  scking

  6 replies

  23 years ago

  By: Gabor Nyul

• An intriguing SQL question

  I need assistance executing stored procedures that are in a table. For example, SELECT sp_name FROM…

  pop022

  8 replies

  23 years ago

  By: pop022

• Help with labels

  I am attempting to use the goto statement with a variable. I.E. CREATE PROCEDURE dbo.test @label VA…

  pop022

  2 replies

  23 years ago

  By: pop022

• How do I show row data as a single field?

  I'm sure I've seen posts similar to this before, but can't seem to find any now! What I'm trying to…

  GregLyon

  10 replies

  23 years ago

  By: sokolove

• Multiple variable concatenation

  We all know that we can't have variables of text, ntext etc in stored procedures. So the greatest n…

  dgodden

  3 replies

  23 years ago

  By: bdohmen

• Max Date Problem

  I have no idea how to get this result, I need HELP!! Here are the field names: evtid serveri…

  swiedner

  11 replies

  23 years ago

  By: rstone

• Lowest amount of the combination

  Hi, I have a table with following data in it Auto_Type,1Auto,2-4Auto,5-9Auto,10-24Auto Car, $1…

  Mkumari

  5 replies

  23 years ago

  By: Mkumari

• Execute a stored procedure inside a SELECT

  How would I run a stored procedure within a SELECT statement? Is it possible to do this without cre…

  demos

  2 replies

  23 years ago

  By: tymberwyld

• SQL aggregates including missing dates

  I have an invoice table which I would like to get the counts for the number of invoices per subsidi…

  jsqldba

  10 replies

  23 years ago

  By: David Burrows

• Unusual update

  Hi! I am using fn_get_sql() function to trace the code that causes blocking. Recently I replaced t…

  Roust_m

  1 replies

  23 years ago

  By: Roust_m

• Full text noise word woes and angst

  I hope someone can clarify this for me - I'm getting confused by noise words in a full-text search …

  Jonathan Tomkins

  1 replies

  23 years ago

  By: mccork

• Group By

  Hi All, I have this table - Dummy - with these values : Date MW1 Price1 -----------…

  ko_yusuf

  2 replies

  23 years ago

  By: ko_yusuf