| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I'm just reading through the help sites for information about creating
a Trigger. I'm using it to debug a program. The trigger will record
the...
Dom
|
04-25-2011 02:42 PM
Erland Sommarskog  | 3 | 4 |
| | | Dear SQLers:
I decided to see if my simple, sample database code would work
elsewhere. I asked a co-worker at another location to run the...
Gene Wirchenko
|
04-20-2011 02:25 PM
Gene Wirchenko | 6 | 7 |
| | | Dear SQLers:
Take 2 on trying to resolve this:
WARNING: The script drops the database Banking.
Start SSMS. Load the following script. Execute...
Gene Wirchenko
|
04-17-2011 12:18 AM
Gene Wirchenko | 3 | 4 |
| | | Dear SQLers:
I continue slowly putting together a Banking database. I now
want to define the Transactions table. It makes sense to...
Gene Wirchenko
|
04-15-2011 05:55 PM
Erland Sommarskog | 1 | 2 |
| | | Dear SQLers:
I have a couple of problems with Edit Top 200 Rows.
1) I call it up on one table, change one column value (not a key
column) from...
Gene Wirchenko
|
04-13-2011 08:26 PM
Gene Wirchenko | 6 | 7 |
| | | Hi,
I have few views which returns lots of rows. i want to use a value
that i will change in one place and all the views will work according
to it....
omtechguy
|
04-13-2011 05:54 PM
Erland Sommarskog | 4 | 5 |
| | | Dear SQLers:
I have a basic trigger that does most of what I want. I am
wondering if it is good design.
I prefer to have the one trigger instead...
Gene Wirchenko
|
04-13-2011 04:27 AM
Erland Sommarskog | 3 | 4 |
| | | Dear SQLers:
I have finished writing my first involved stored procedure. It
makes strings nice. It works, but it might be better.
Have I, for...
Gene Wirchenko
|
04-12-2011 09:14 AM
Philipp Post | 7 | 8 |
| | | Dear SQLers:
How do I modify the data that is going to be written to a table?
I understand that this data is in a logical table called
inserted,...
Gene Wirchenko
|
04-11-2011 06:49 PM
Bob Barrows | 12 | 13 |
| | | At 8:00 am Wed, we started a Shrink Database command (though the SSMS
GUI) on a very large and very active database. The activity monitor
usually...
Dom
|
04-08-2011 10:26 AM
Dom | 4 | 5 |
| | | Dear SQLers:
1) The odd memory behavour is that SQLSERVR.EXE is taking about
600MB doing nothing! Does it ever release memory? Sure, I was...
Gene Wirchenko
|
04-07-2011 09:15 PM
Gene Wirchenko | 4 | 5 |
| | | Dear SQLers:
I understand that SQL Server 2011 Express is in the works and its
alpha/beta/whatever can be downloaded. I have, once again,...
Gene Wirchenko
|
04-06-2011 11:38 PM
Jeroen Mostert | 1 | 2 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has partnered with data management experts, Ingres Corporation,
certifying...
janpelletier@yahoo.ca
|
04-06-2011 07:28 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Dear SQLers:
Occasionally, I make an error and SSMS reports this.
Actually, I make a lot of them. There is a frustration that the
line number...
Gene Wirchenko
|
04-05-2011 04:44 PM
Erland Sommarskog | 6 | 7 |
 | | hello.
I need help with a query please...
I've a table like this
Id | Contr | Type
the content of this table is like
Id | Contract | Type
1 |...
Alfaking
|
04-05-2011 08:26 AM
Henk van den Berg | 16 | 17 |
| | | Dear SQLers:
I have written the following stored procedure:
create procedure NiceString
@strIn nvarchar(max),
@strOut nvarchar(max) output
with...
Gene Wirchenko
|
04-04-2011 05:44 PM
Gene Wirchenko | 1 | 2 |
| | | Hello all. Just wanted let you know about a new program I wrote to help
with creating stored procedures. I had a table with lots of columns that
I...
NumbLock
|
04-03-2011 06:47 AM
NumbLock | 0 | 1 |
| | | Business Intelligence (BI) expert and founder of Dresner Advisory
Services, Howard Dresner, is set to co-host an exclusive live Webinar
on Mobile BI...
janpelletier@yahoo.ca
|
04-03-2011 06:41 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Dear SQLers:
For a start, I decided to model how I do banking. I have several
bank accounts, and I split these up for setasides. When I list...
Gene Wirchenko
|
04-03-2011 12:01 AM
Gene Wirchenko | 2 | 3 |
| | | Wingenious has released a free utility for SQL Server developers,
administrators, and contractors. The tool, DBGizmo, provides some of
the features...
google@wingenious.com
|
04-02-2011 09:12 PM
google@wingenious.com | 0 | 1 |
| | | Hi,
Feel free to check out the database server hardware category on this
new internet directory...
Paka Small
|
04-02-2011 04:58 PM
Paka Small | 0 | 1 |
| | | Dear SQLers:
So now I know how to get the batch's id. I could code something
like:
insert into Batches ('Example Batch')
declare @BatchNr...
Gene Wirchenko
|
04-01-2011 05:37 PM
Erland Sommarskog | 3 | 4 |
| | | On Thu, 31 Mar 2011 23:46:18 +0200, Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:
Thank you for the magic word. I am now working...
Gene Wirchenko
|
03-31-2011 06:08 PM
Gene Wirchenko | 0 | 1 |
| | | Here's a question about getting the most out of the interface when
executing SQL in the interactive window of M
In TOAD (a popular front end for...
bill
|
03-31-2011 01:38 PM
Fredy Muñoz | 2 | 52 |
| | | ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of...
Martijn Tonies
|
03-30-2011 08:55 AM
Martijn Tonies | 0 | 1 |
| | | I have a question about disabling the ability for a user to change
their password by using alter login <login name> with password = <new
password>. ...
JoeyD
|
03-29-2011 11:35 AM
JoeyD | 2 | 3 |
| | | Hi friends,
A pleasant greetings for one and all.I have the table
which name is ALA.It has a column id.i set id as primary key.Can any
one help me...
mada suresh
|
03-28-2011 12:29 PM
Henk van den Berg | 2 | 3 |
| | | Dear SQLers:
The subject about says it all. How do I do this?
My SQL Server 2008 Express system is LOOP\SQLEXPRESS.
Apparently, I should create...
Gene Wirchenko
|
03-28-2011 12:10 AM
Paul Pedersen | 21 | 22 |
| | | Hello all,
This is a newbie design question. I have a table with the following fields
TABLE A
ID, Prop1, Prop2
I expect that I might have...
andrew
|
03-27-2011 09:34 PM
Bob Barrows | 3 | 4 |
| | | Hi all,
I have a 260GB database with a single read/write table taking up
200GB. I create a weekly FULL backups and nightly DIFF backups with
TRAN...
joshsackett
|
03-27-2011 07:30 PM
bender | 3 | 4 |
| | | Information management solutions provider and event partner, Zenith,
will present its groundbreaking data quality dashboard at the 2011
Data Quality...
janpelletier@yahoo.ca
|
03-27-2011 06:58 AM
janpelletier@yahoo.ca | 0 | 1 |
| | | Tom Gugger
Independent Recruiter
tgugger (AT) bex (DOT) net
MS SQL DBA/ Career Position/ Lansing, MI Area
This is a real position with a real...
TOM
|
03-17-2011 10:00 AM
TOM | 0 | 1 |
| | | Hi all,
i tryed to write a request in this ng but it was in italian.
So, sorry for my english, below my question:
Is there a possibility to obtain...
sim
|
03-15-2011 09:00 AM
sim | 0 | 1 |
| | | Hello! Convincing a Volvo driver (in my case, a girl) for having a
test-drive I was accepted into the present Volvo campaign (Romania).
Winner will...
marian
|
03-12-2011 07:36 AM
marian | 0 | 1 |
| | | (Is there a better NG for SSRS questions?)
I created three tables in SQL Server 2008, all with
Code char(1) not null,
Description varchar(50)
then...
Wes Groleau
|
03-09-2011 09:48 PM
Wes Groleau | 2 | 3 |
| | | Buongiorno,
ho appreso che in SQL2008 c'è una feature che riguarda la tipologia di
dati idonei al geomapping.
Chiedo (aldilà che m'informerò pure io...
sim
|
03-07-2011 03:36 AM
sim | 0 | 1 |
| | | VTD-XML 2.10 is now released in Java, C#, C and C++. It can be
downloaded...
dontcare
|
03-04-2011 11:42 PM
dontcare | 0 | 1 |
| | | I am cross posting this request for help in both the C#,NET and the
SQLServer newsgroups in he hope that some reader of one these
newsgroups can...
Joe Cool
|
03-04-2011 07:36 PM
Arne Vajhøj | 23 | 24 |
| | | Dear SQLers:
CREATE TRIGGER ... {FOR | AFTER | INSTEAD OF} ...
Do FOR and AFTER mean the same thing here? In particular, I am
wondering whether a...
Gene Wirchenko
|
03-04-2011 12:16 PM
Erland Sommarskog | 7 | 8 |
| | | Japanese technology manufacturer, Onkyo, has announced that it will
preload its Android-based TA117 Tablet computer with Yellowfin’s
Business...
mehrapeak@yahoo.com.au
|
03-02-2011 05:56 AM
mehrapeak@yahoo.com.au | 0 | 1 |
| | | Hi,
is there an option to increase the time of inserting 1M rows to a
table using stored procedure?
Already removed all the indexes and the...
OM
|
03-01-2011 06:34 PM
Erland Sommarskog | 3 | 4 |
| | | International Business Intelligence (BI) software vendor, Yellowfin,
has confirmed its place as a leader in Mobile BI, blitzing Howard
Dresner’s...
JTP PR
|
02-27-2011 06:29 AM
JTP PR | 0 | 1 |
| | | Dear SQLer:
I am just reading up about COLUMNS_UPDATED(), and it appears to
be dangerous.
It seems to me that a trigger using it would be...
Gene Wirchenko
|
02-24-2011 05:10 PM
Gene Wirchenko | 2 | 3 |
| | | The paper discuses the ability of an Agile BI rollout to respond to
changing data analysis and reporting needs, and provide vital insights
into an...
JTP PR
|
02-16-2011 09:47 PM
JTP PR | 0 | 1 |
| | | Hi,
Currently, i know that i can capture SP that executing from code or
from SQL Managmtnt studio. bit if a specific SP executing another SP i
don't...
omtechguy
|
02-15-2011 05:31 PM
Erland Sommarskog | 1 | 2 |
| | | Hello everyone,
Does anyone know of a tool that is easy to use for non-technical
people to run queries on a database?
For example they can view the...
Jay
|
02-15-2011 03:07 PM
Jay | 0 | 1 |
| | | I receive this data in a column in a table: $8982162:2$905122:2$905PPA:
25$9601217:2$962B19:2$CSRI96:2$WDCOLACK:2$IDRBLACK2:2$IDRRED:2$
I need to...
Johnnyb
|
02-15-2011 02:09 PM
Lennart Jonsson | 7 | 8 |
| | | Does someone know how to do it?
Thanks.
omtechguy
|
02-15-2011 01:13 PM
Gert-Jan Strik | 2 | 3 |
| | | Hi,
I've searched for an answer for hours so this newsgruoup is my last chance.
A Java Application uses a JDBC driver without port...
ES
|
02-15-2011 03:16 AM
ES | 4 | 5 |
| | | Hi,
I'm messing with this scenario:
- SQL Server 2005 (it should work on 2008 too)
- high concurrency jdbc client connections.
The code below is a...
Mau C
|
02-15-2011 02:55 AM
Mau C | 4 | 5 |
