Topics
Started by
Posts
Last post
I have data provided by an external source in which they have a 'from postcode' and 'to postcode' f…
4 replies
I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tab…
3 replies
Hi, I want to change the Identity increment value of a column, I Tried with the following command,i…
4 replies
I'm trying to get a count of rows for each column that has info in it. I have DECLARE @cmd varchar(…
4 replies
Okay, so I am guilty of having a quick Access adp application for my internal users with bound form…
11 replies
Hi all, I have this sql script: -- Crear tabla create table TABLA_MAESTRA ( CD_NOMBRE_TABLA VARCHAR…
1 replies
Environment: SQL Server 2000 running under Windows 2000. and developper's machine running under Win…
6 replies
The trigger I'm working on is a "FOR UPDATE,INSERT" This trigger checks for any changes to a specif…
6 replies
The query below was run in QA to delete old rows from a table with 1.5 billion rows, batching it up…
9 replies
Hi all, mister I want create a function but I get this error: Error Invalid use of side-effecting o…
3 replies
Hi: I have a confusion using the IF EXISTS statement and here's how it goes: case#1 if exists(selec…
4 replies
Hello All After an INSERT stmt how do I engage error handleling and capture errors to a table …
2 replies
Hi: I have problems in concatenating a sql statement using EXECUTE and Update. Here's my code: exe…
3 replies
Performance wise, which is better solution to insert multiple records in a table - Union all or Mul…
5 replies
Hi, I need to count all the stores in a table and provide a list broken down into upper/lower case …
3 replies
Viewing 15 topics - 2,941 through 2,955 (of 17,082 total)
You must be logged in to create new topics.