Development

• Topics

  Started by

  Posts

  Last post

• Stored Proc Creator

  Hi ...we have a stored proc in our database....how Can I know who created that stored procedure?? …

  ssismaddy

  2 replies

  17 years ago

  By: ssismaddy

• List out SP's Columns into a Table

  Hi All I want to list out columns name of SP into a table. They can be dynamic. Thank in advance s…

  SQLIndia

  10 replies

  17 years ago

  By: winash

• Table Lock

  Hey guys, I have an SP where one part updates a Control Table and does the extract... The SP is cre…

  Ghanta

  2 replies

  17 years ago

  By: Ghanta

• create txt file

  i have a select statement and through this select statement i want to create txt file .if is a po…

  pratyush.singh.chandra

  6 replies

  17 years ago

  By: Adi Cohn-120898

• How to find common sounding words in database?

  hi, I want to find common sounding similarity words in database. ex. I want to find "Limited" word …

  @nks

  5 replies

  17 years ago

  By: Andrew..Peterson

• page loadingin SQL Server

  hi, is there page loading in SQL Server? ex. my select statement returns 10000 records, but i only…

  nplinares

  1 replies

  17 years ago

  By: Lowell

• How to add custom event id into eventlog from SQL Server

  Hi all, The situation is like that, I am running some deleting jobs and want to track errors while …

  HardCoder

  4 replies

  17 years ago

  By: HardCoder

• Creating SQL Script

  Hi All, I want to create a SQL Script in SQL 2000 for the existing table. my script will do the fo…

  anbaz1976

  1 replies

  17 years ago

  By: John H Marsh

• Problem with SQL SP Where - using IF or Case

  Hi All, After searching the web for a solution I just seem to be more confused - If someone could t…

  jdixon-940295

  10 replies

  17 years ago

  By: janet.dixon

• Row locking / Record locking in SQL 2005

  Hi all, Greetings!! If this issue is already resolved please provide me links. If this is cross po…

  sksankararaman

  2 replies

  17 years ago

  By: Adi Cohn-120898

• doubt on indexes

  Hi everybody, 🙂 Please tell me how to list out the indexes in a database, on which table and which …

  nageswara.dhaveji

  4 replies

  17 years ago

  By: nageswara.dhaveji

• Nice Challenge: Compare fields of 2 tables in the most efficient way

  Hi all, I need to have a query which compares the fields of 2 tables with each other. The naming of…

  inge wittendorp

  1 replies

  17 years ago

  By: patriwala

• XML Data Type

  Hey All, I will be storing some XML in my database strictly for storage and retrieval purposes. I …

  paul.corujo

  8 replies

  17 years ago

  By: winash

• DatagridView Control sample code

  Hi Everyone Can you please give me a sample code of copying one row from a datagridview to anoth…

  lyletan

  1 replies

  17 years ago

  By: psvgopal

• Arrays in Stroed Prcoedure

  I'm trying to get the data from the table between two dates and for the List of Doctors select * fr…

  doss.tychicus

  18 replies

  17 years ago

  By: Jeff Moden