There are two datatypes for storing binary data type in the SQL Server: 1. binary - for fixed length binary data 2. varbinary - for variable length data My question is: how is data inserted into them? Do they have any delimiters that go into the insert statement like strings and datetimes h...more >>

Hi, How to find first not null value in column whitout chacking whole table (if there is a not null value then show me it and stop searching, the table is quite big)? thx, Martin *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi How network administartor can find , who has AQL server client tools on his system? Thanks ...more >>

Right now the database I am working with is storing time in an Integer data type and is storing the time value in seconds. The application does not allow entering seconds. It accepts minutes and hours. I have a report where it is doing: SELECT SUM(TIMEENTERED) and the SUM is *blowing* up...more >>

I have an Excel add-in that connects to a SQL Server Express 2005 database. I've decided to create a configuration piece for this add-in in Visual Studio 2005 Express. I added a data connection using the data connection wizard and all appeared to go well. Anyways when I attempt to open SQL Serve...more >>

I have a website which runs off a Access database which I am currently converting to sql server database. I would like to still use my access front end for reporting and queries.. I created an odbc connection on my computer to the remote sql server and created a link in access to my sql server t...more >>

Is there a way to audit the login on SQL Server 2000? I'm looking for a way to get a report login/logout events with the name of the database. Thanks in advance. ...more >>

In MS SQL you can create a database that is run in a seperate instance. Why and when should a database run on a seperate instance ? Benefits ? What is prefered and why? Two applications have it's own tables. Appplication A have a set of tables. Appplication B have a set of tables but also ...more >>

The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test Environments. What is the purpose of a view if I can just copy the vode from a view a...more >>

Pls advice me of a small download compiler SQL that I can test my program and exmples in it (select,insert,drop,...) ...more >>

Hi, I have three tables in the following structure (simplified): Table 1: Containing the customers ------------------------------------------------- create table Customers ( [cusID] int identity(1, 1) not null, [cusName] varchar(25) not null ) Table 2: Containing the customer data f...more >>

'message' Field Data: <xml> .... <test>ABC</test> .... </xml> How do I query out 'ABC' from this xml field data in a SQL Server? Assume message field is in table 'Persons' ...more >>

I am currently moving a table from a msSQL DB to a MySQL DB. I am trying to build the bones of an insert statement by adding strings to a select statement. SELECT '(' + job_referenceno + ', ''' + job_title + ''', ''' + job_category + ''', ''' + job_type + ''', ''' + job_location + ''', ''' ...more >>

Hi, I am trying to create a script that deletes transaction tables and leaves master data like customer, vendors, inventory items, etc. How can I use TRUNCATE TABLE with an Exists? My problem is I have 200+ tables, if I simply use a list like: truncate table01 truncate table02 truncate t...more >>

Hi My problem is as follows: I need to transmit data between two databases on the same server, but I have to use dynamic database names (they must be configurable). For example I need to achive sth like that: insert into [database1].[dbo].[table1] (select columns from [table2]) when...more >>

What is the correct syntax for querying the first 20 characters of a memo field? I'm trying to SELECT CAST (varchar(20) fieldname) as newfieldname and i get a bunch of errors Can someone please help me? MS Access DB used with ColdFusion Thanks...more >>

Hi, First I would like to apologize for cross posting in three groups as I did not know which one would be the appropriate group. If some one points me to the correct one I will use that in the future. I am trying to findout the scalabilty of an user written extended store procedure. I have...more >>

When i debug a trigger is it possible to add a WATCH on the INSERTED or DELETED? I think not, at least I couldn't figure out a way to do so. Does someone have a suggestion on how I can see the values? I did try to do something like INSERT INTO TABLE1(NAME) SELECT NAME FROM INSERTED bu...more >>

I have a results set that is sorted on LineNum. Not all items have a LineNum (some are null). I want my result set to return all items in ASC LineNum order and then list all items with NULL LineNum at the end of the results. Any Suggestions? Thanks. ...more >>

I've searched everywhere for this but can't find the answer I want to run a DTS package that simply executes a SQL statement to get a count of rows in a table, if the resulting number is greater than zero I want to execute another step in the same package, else just quit. I don't to pass gl...more >>

Hello, I am attempting to build a MS SQL query that will return data from "today"; today being current day 8:00AM-10:00PM today. My goal is to return the data from a table that is written to throughout the day, the query will provide the current grade of service in our call center. I am ha...more >>

I'm getting occasional instances of the error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I get the error both in application code and from Enterprise Manager. The database is LOCAL. Microsoft SQL Server 2000 Developer Edition SP4 Windows XP Profess...more >>

I'm getting occasional instances of the error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I get the error both in application code and from Enterprise Manager. The database is LOCAL. Microsoft SQL Server 2000 Developer Edition SP4 Windows XP Profess...more >>

Hello ! I habe 2 Tables Table1: Orders Fields: Ordernr, Opieces Table2: Calloffs Ordernr, Cpieces In Table1 ordernr is primary key. In Table2 the same ordernr can exist often My problem If the sum(Cpieces) < Opieces: I have to create a new virtual calloff with Cpieces = opieces ...more >>

I am a DB2 DBA that has been asked to become familiar enough with SQL Server in order to become actively involved in its installation, implementation, and to review database backup/recovery procedures. SQL Server will be used by a vendor packaged application. The problem is that we are awaitin...more >>

Hi On our SQl Server (2000) we can have queries that take at least 10-20mins (require full table scan fo billion row table). When one of these queries is running it substantailly slows down very quick queries (sub second queries take several seconds). I believe there is no way to set priori...more >>

I know this is not an Access group, but there doesn't seem to be one, and I'm guessing MS SQLs are all quite similar - at least in relatively simple cases like this one. I'm using this SQL statement, "SELECT [Cape Town 25/04].IDNUMBER, [Cape Town 25/04].SURNAME, [Cap...more >>

Hi All, I have been working with SQL Server for some time - but until now haven't tried to implement a trigger and am not sure if this is an appropriate use. Any advice would be greatly appreciated. I have this table: almis.dbo.aadata_x when almis.dbo.aadata_x is updated, I want to au...more >>

I have the view below and if I use vwRouteReference as the rowsource for a combo box in an MS Access form or run "SELECT * FROM vwRouteReference" in SQL Query Analyzer, the rows don't come through sorted by Numb. Everything I've read on the web suggests that including the TOP directive shou...more >>

Hi I'm working on an ASP project where the clients want to be able to effectively perform SELECT queries joining tables from two different databases (located on the same SQL-Server). Does this involve creating virtual tables that link to another database, or am I completely on the wrong tra...more >>

I am trying to import 6M records in a table from an Oracle 10g database into a SQL Server 2000 database. After importing 1.5M+ records I get the following error: Ora-01555: snapshot too old: rollback segment number 129 with name "_SYSSMU129$" too small How can I speed up the import proces...more >>

In my stored procedure I'm calling a buggy and flaky stored procedure that comes from a third party. When I run my stored proceure from QA, I'm getting a whole buch of errors raised inside the third party one. Is there any way I could just ignore them, so that if I run my SP from QA, only errors...more >>

I've re-written a stored procedure and when I post the following code into the existing SP in EM, is saves OK. However, when I re-edit the SP, the last line 'Commit Transaction' has been removed. I cannot save the remainder of the SP as it throws error 208 (Invalid Object name #Max) about two ...more >>

I am working on setting up our new SQL Server 2005 servers. One of them will eventually be our Replication Distributor. However when I attempt to set this up within the wizard, I get the following error: ------------------------------ TITLE: New Publication Wizard ------------------------...more >>

Hi, I find much regrettable that Database Engine Tuning Advisor be not part of MS-Express Edition ... A server without such help is not a server. Besides, you've got the tutorials, but not the tool to play with :-((( Regards, JM Blaise ...more >>

Hi! I'm wondering whether it's possible to set up the MS SQL function ISNULL() as a default value to avoid NULL entries when importing data into a table?! For example, I want the column1, to have a 0 (zero) as default value, when entering/importing data: isnull("column1",0) I remember th...more >>

I've been trying to work with Linked Servers for the first time, with mixed success. My problem right now is in trying to write a View using a linked server. The linked server is another SQL-Server, and it was set up using the 'Enterprise Manager' interface. When the server was created, the name...more >>

Hi all, My client PC is very slow to connect to all SQL server databases. Other client machines are having no problem at all. I even tried connecting to my local MSDE database, and the same behavior results. If I try to connect via a .NET application it is also slow. The connection is always...more >>