Development

• Topics

  Started by

  Posts

  Last post

• xml schema validation for the sp parameter

  Hi all, I wanted to validate the parameter string passed to the stored procedure is in proper…

  sseetha

  1 replies

  15 years ago

  By: LutzM

• getting duplicate records for a primary key column

  Hi When I am trying to run the below procedure, getting the below problem: 1. Getnextkey procedure …

  ekknaveen

  7 replies

  15 years ago

  By: ChrisM@Work

• SQL Transaction --- BLOCKING INSERTS

  Hi...Can anyone help me with my question.... Ok... I have a SQL tranaction say T1 with default Isol…

  Vinay Jamalpur-253105

  6 replies

  15 years ago

  By: caladba

• How to convert Exponentials value to Numerics

  Hi SSC Experts, From the front end application a numeric value of 10 digits with datatype varchar(m…

  Mr.SQL DBA

  2 replies

  15 years ago

  By: Mr.SQL DBA

• Error-Not enough storage is available to complete this operation.

  Hi All, I am using SQL Server 2005 . I am trying to import data from file(txt, xls) using multiple …

  GoGreen

  19 replies

  15 years ago

  By: jwinston

• Crosstab for Generic Data

  I have the following query: SELECT Investment, DateKey, Amount FROM InvTransaction WHERE Investment…

  Rofty

  2 replies

  15 years ago

  By: Rofty

• LIKE operator

  Hi, I am trying to remove all the unwanted tables ,sps,views in MYDB.The names we kept for our tab…

  parthi-1705

  1 replies

  15 years ago

  By: Lowell

• SQL 2008 log file backup

  I am unable to take Log file backup using Backup log Test with Truncate_only in SQL 2008. Please …

  marees.inspire

  6 replies

  15 years ago

  By: kavi_jaya

• xml and sql sp

  Hi all, can anybody tell me how to do crud operation using xml file as a parameter to a stored proc…

  sseetha

  2 replies

  15 years ago

  By: sseetha

• Pagination AND "order by" play

  Hi I have two question. First , IS there any concept like "pagination" in sql server 2005 ? Or sec…

  Bhuvnesh

  5 replies

  15 years ago

  By: Gail Shaw

• sp_Foreachdb and sp_foreachtable

  Hi, I currently have a script that gets the table sizes of all the tables in a db. When I run the s…

  Imke Cronje

  3 replies

  15 years ago

  By: hfreeman

• Help with query to remove null warning message

  This is a snippet of a bigger process. I basically want to get rid of this message "Warning: Null v…

  Josh Rotert

  2 replies

  15 years ago

  By: Josh Rotert

• Team Foundation Server - Are you using it?

  Hey everyone. My small data warehouse team (3 people) is considering the use of Team Foundation Ser…

  Ted Manasa

  1 replies

  15 years ago

  By: Mike01

• CTE with Order by and CASE

  Hi All In the below query, I want to sort on the Column BigOrSmall(which I calculate based on a cas…

  S_Kumar_S

  2 replies

  15 years ago

  By: Kingston Dhasian

• Passing an array of input parameters to stored procedure

  Hi, I am developing an application in .Net 2003 with Sql Server 2005 version. I have to pass some i…

  Raja Raman S

  1 replies

  15 years ago

  By: Bhuvnesh