SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Get number of rows updated/Inserted/deleted by boclk of t-sql code

  Hi, In Oracle, we use SET SERVEROUTPUT ON to display the row count and SQL%ROWCOUNT to get actual n…

  madhu-686862

  7 replies

  14 years ago

  By: Lynn Pettis

• Help get a best perfomance

  Hi all, i have this query: DECLARE @pid_partida_cliente INT DECLARE get_idPartida_cliente CURSOR F…

  xRafo

  2 replies

  14 years ago

  By: sturner

• Just a Quick Question

  Hi All, Is this correct, when creating tables within SQL Server is this the number 1 thing you must…

  .Netter

  20 replies

  14 years ago

  By: MVDBA (Mike Vessey)

• Query Performance issue.

  Hi , I am experiencing performance problems with queries which use wildcards at each end of a searc…

  brk5tr

  15 replies

  14 years ago

  By: brk5tr

• uniqueidentifier incompatible with int

  i wrote this request but I got an error and i can not solve it thankks for your help -- Insert…

  marclas

  19 replies

  14 years ago

  By: Lynn Pettis

• Finding last date compiled for a stored procedure

  Hi all I have been searching forums all over the show and cannot find out how to find the date that…

  TDP

  5 replies

  14 years ago

  By: Thomas Stringer

• Read permission while doing Transaction Insert Update on the same table

  I have a process which inserts a view's data into local table, and this local table would be treate…

  princa

  2 replies

  14 years ago

  By: princa

• Creating NON clustered during peak load

  Hi Yesterday I had a tough time creating a nonclustered index on a table of size 4 gb. It was durin…

  S_Kumar_S

  5 replies

  14 years ago

  By: MysteryJimbo

• How to use WHEN EXISTS inside a CASE Statement

  How is it possible to use WHEN EXISTS inside a CASE Statement? Currently I am using SELECT TOP 1 as…

  J39L4753

  3 replies

  14 years ago

  By: J39L4753

• database developement - enforce buisness rule with trigger

  I am developing a database that will be used to track secondments within an organistaion. One of th…

  eseosaoregie

  2 replies

  14 years ago

  By: eseosaoregie

• delaring a null parameter

  HI how can i set a null value when declaring a parameter example CREATE PROCEDURE dbo.GestionStatu…

  marclas

  3 replies

  14 years ago

  By: vinu512

• Arithmetic overflow error converting expression to data type int.

  Hi, Okay so the sum of these values is greater than Max INT I tried to cast(sum(length) as bigint)…

  Edward-445599

  2 replies

  14 years ago

  By: Edward-445599

• New Features in 2008

  Can any one say what are new features available in 2008 please....

  bandarimohan 57273

  2 replies

  14 years ago

  By: Koen Verbeeck

• syntax error : Msg 102, Level 15, State 1, Procedure CreerComplement, Line 43

  hi, I have this procedure CREATE PROCEDURE dbo.CreerComplement -- Add the parameters for the stor…

  marclas

  3 replies

  14 years ago

  By: vinu512

• Select records from huge nos. of data

  Hello, I have a table which has huge no. of records (10lac records). I need to select data page wis…

  alto

  5 replies

  14 years ago

  By: alto