T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• get max

  CREATE TABLE [dbo].[Table_A]( [id] [smallint] NULL, [name] [varchar](50) NULL ) ON [PRIMARY] GO C…

  sstacy7

  2 replies

  13 years ago

  By: Kingston Dhasian

• Does a "Begin... End" in a While loop act as a transaction?

  Reading Lynns comments in this topic: http://www.sqlservercentral.com/Forums/Topic1447456-391-1.asp…

  jasona.work

  2 replies

  13 years ago

  By: jasona.work

• output understanding for most memory reads?

  Hi.. Top procedures memory consumption per execution as below capture script SELECT TOP 100 * FROM …

  SQL Galaxy

  1 replies

  13 years ago

  By: Mansfield

• Search data.

  Hi, I want to search student information depending upon the passing either values of firstname,last…

  abhas

  3 replies

  13 years ago

  By: Sergiy

• Dynamic export to flat files by date

  Hello all, I am tasked with archiving some very large tables. There are about 30 tables that I need…

  SQL Wayne

  2 replies

  13 years ago

  By: SQL Wayne

• Error when Cascade Update on child tables

  Hi There is a DB with 4 tables (3 master tables and one is detail which has daily information) Tabl…

  armm1388

  1 replies

  13 years ago

  By: Lynn Pettis

• Insert statement error?

  Hi, what is wrong this code? pl. suggest create table databaseSize ( DatabaseName varchar (100), …

  SQL Galaxy

  1 replies

  13 years ago

  By: Steve JP

• Recursion 100 has been exhausted

  Hi I have a query below and I get The maximum recursion 100 has been exhausted, how do I fix or go …

  hoseam

  6 replies

  13 years ago

  By: Eric Nordlander

• Nested Stored Procedure does not work as expected

  I have 2 Stored Procedures Procedure A and Procedure B. Both Procedures have @year as parameter and…

  Nilesh-788004

  1 replies

  13 years ago

  By: Sean Lange

• Recursive CTE

  Hi, I have a query below I'm doing recursive CTE. The logic behind it is, Client(John) can be linke…

  hoseam

  6 replies

  13 years ago

  By: geoff5

• The maximum recursion 100 has been exhausted

  Hi I have this query below, CTE code. and I get this error: The statement terminated. The maximum r…

  hoseam

  2 replies

  13 years ago

  By: David McKinney

• Urgent Help: Validating Updation of a column

  if OBJECT_ID('..test')>0 drop table test create table test (id int , name varchar(2) ); Go inser…

  Mr. Kapsicum

  5 replies

  13 years ago

  By: Kingston Dhasian

• how pick value from database on sql server2000?

  Hai friends, I m creating one sample application its has two dropdown boxes ddl1 and dd2 if i…

  raghuldrag

  9 replies

  13 years ago

  By: FunkyDexter

• Which Systems are using MasterAccess User

  Hi All, I have a user by MasterAccess. As a DBA I want to see who are logged with this user. I wan …

  niladri.primalink

  3 replies

  13 years ago

  By: Vegard Hagen

• Delete other than top 2 rows for each foreign key element in table.

  I have a table like that MemberId(F.K) ! Event ! Event Date 1 'Tes…

  faheemahmad14

  7 replies

  13 years ago

  By: Cadavre