Development

• Topics

  Started by

  Posts

  Last post

• Forcing multiple statements to execute as a single group

  Is there a way to force one or more SQL statements to execute together, even if other connections a…

  kcook-1066767

  2 replies

  16 years ago

  By: Paul White

• Output to grid file

  Hi, I created a shell script (Windows XP) that runs a stored procedure (SQL-2005) using OSQL ... an…

  alark

  6 replies

  16 years ago

  By: alark

• Performance problem with SQL queries having a specific column mentioned in WHERE or GROUP BY clause.

  Performance problem with SQL queries having a specific column mentioned in WHERE or GROUP BY clause…

  daniell-1020276

  9 replies

  16 years ago

  By: John Rowan

• Auto-Increment with a two column primary key

  I have two columns in a table representing the primary key; I want the ability to auto-increment on…

  kcook-1066767

  2 replies

  16 years ago

  By: kcook-1066767

• Deadlock error in high cuncurrency env

  I am getting error "SQLError: [40001],[Microsoft][SQL Native Client][SQL Server]Transaction (Proces…

  loveleshg

  7 replies

  16 years ago

  By: Rookee DBA

• Table insertion

  Hi All, I Have 3 Tables where each table needs to get inserted with 100 Records.1st Table …

  relango2

  3 replies

  16 years ago

  By: Florian Reischl

• Query to synchronize two Databases

  Hi friends, Presently in order to synchronize two databases w.r.t tables, columns and constraints w…

  rwaqas

  3 replies

  16 years ago

  By: rwaqas

• Add row to the SQL result?

  Dear All, I need to add a row to the result of SQL statement. The Sql Statement is: select ID, name…

  obarahmeh

  3 replies

  16 years ago

  By: Rookee DBA

• Convert NVARCHAR columns to DATETIME

  Hi All, I have a table which contains a number of columns all set as NVARCHAR(50). One column in pa…

  A Little Help Please

  3 replies

  16 years ago

  By: Ron McCullough

• problem with the execution of dynamic sql

  hi i have created a stored procedure in sqlserver 2008 that executes dynamic sql. for ex: create …

  RockingAdmin

  8 replies

  16 years ago

  By: Lewis Dowson

• Select Top Records grouped by Field,

  i track diskspaces of my servers into the database Now, sometimes the script runs multiple days a d…

  Van Heghe Eddy

  3 replies

  16 years ago

  By: Nabha

• Creating the correct date(s)

  I know there is a bit of sql code here but I need some help with getting the correct dates created …

  scott-733974

  5 replies

  16 years ago

  By: AnzioBake

• Access SQL Server via .NET acpplication and not by SSMS

  Hi Friends, Do anyone know how to create a new "User" in SQL Server, and give him such privileges t…

  Bhavesh_Patel

  8 replies

  16 years ago

  By: Bhavesh_Patel

• 2nd Column values keep getting repeated

  Hello experts, I’m trying to write a code though which I need to add some data in one of my table. …

  mr_adeelalisyed

  4 replies

  16 years ago

  By: Bru Medishetty

• SQL 2005 consistency-based I/O error

  SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x5555555…

  venkuforever

  1 replies

  16 years ago

  By: Gail Shaw