Using MS SQL Server

User Defined Data Types Problem
Hi all, I defined unsigned_int in my database, which uses unsigned_int_range rule. The unsigned_int_range rule is defined as follows: @unsigned_int >=0 and @unsigned_int <=4294967295 (4294967295 = 0xFFFFFFFF) The storage size is 4 bytes. One of the tables in the database contains a field that is o... 8 Jul 2006 16:22

BEGINNER: simple Delete trigger
Hello, I am trying to learn SQL Server. I need to write a trigger which deletes positions of the document depending on the movement type. Here's my code: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go CREATE TRIGGER [DeleteDocument] ON [dbo].[Documents] AFTER DELETE AS BEGIN -- SET NOCOUNT ON ad... 6 Jul 2006 20:13

Insert trigger
Hi I have a table - DebtorTurnover - consisting of 5 fields (ID, Date, Turnover, VAT, Netturnover). I get a file which I have to import every know and then, with new data. In this file I only get values for (ID, Date, Turnover and VAT). The import is working fine with the import wizard. The problem is, that I... 29 Jun 2006 04:10

SuperSocket Info: Bind failed on TCP port 1433
I recently began getting this error when SQL Server 2000 starts up. I tried all the suggestions I could find (e.g., Q293107) but none worked. I did finally figure this out and wanted to share the solution. It turns out my winsock2 had been corrupted (by Juniper VPN software, I believe), resulting in SQL Server ... 22 Jun 2006 22:10

group by
Hi. I have read lots, but obviously not the right stuff. A reference pointer would be fine, or an answer. I in fact got an oracle solution that I am still researching, but was wondering about either a generic or an ms sql server solution? I'd like to use sql to find out: given a metadata table where obj... 22 Jun 2006 09:37

Importing data into MS SQL 2000 from XML file
Re: Importing data into MS SQL 2000 from XML file By: Sam Alexander to All on Fri Jun 09 2006 09:20 am Okay I'm getting alittle further... setting my prior question to the side, now I'm simply trying to get data to import into the database. HEre's what I've done. First thing was I installed SQLXML 3.0... 9 Jun 2006 13:46

Trigger to populate table or database
Im a newbie with a sql table in a MSDE database that contains fields of CustName, BrokerName, Type, Status. I am trying to write a trigger that does this: 1. When a new record in a table is added, I would like the selected fields to be copied to another table (call it Master). 2. If that Master table already c... 4 Jun 2006 18:52

money data type
I choose a price field as a money data type, but I cannot change the scale of this. the default scale is 4 (it dimmed). how can I change to 2? I only need 2 scale such as $23.33 instead of $23.3344 ... 2 Jun 2006 15:38

deploy Report
Hi, I use SQL Server 2005 and VS 2005. After I create a report, I try to deploy it to Report Server, I get this error: "A connection could not made to the report server http://localhost/reportserver Additional Information: The attempt to connect to the report server failed. Check your connection informat... 15 May 2006 23:22

SQL2005 collation vs Oracle
Hi there, Is it posible to set the collation of SQL server 2005 like Oracle, which is that objects names and column names are case-insensitive, but data is sensitive;e.g: In Oracle: --create lower-case table and column name create table t1(c1 char(10)); --Mike with upper-case J insert into t1 values('Mike... 15 May 2006 18:09