View Full Version : answers
- Continuously querying a datastream using SQL Server 2005
- How do I create an Insert trigger to copy a table
- left outer join ( =*)
- How to Save MS Word/Excel Files in Database?
- Truncating or shrinking a 65GB Log File with available 2.8GB harddisk space
- are wombats good?
- where are wombats?
- Anyone know any DB2 ?
- using vbs
- Equivalent to SQL Anywhere GET_IDENTITY?
- richie robles
- Update Query using XQuery
- Some XQuery/SQL Server 2005 help please
- Default "Auto Close" to no for entire server?
- Select statement
- How to export SQL Database properties
- Performing mathematical operations on Table columns
- DTS Data Driven Query vs. Query Analyzer
- Error With EXEC sp_attach_db
- Need Help to form the MDX-Statement
- Transposing repetitive serial fields into Table structure
- Replication
- How to get the total time of the records in a table
- mssql_connect problems
- Cross Tab query in SqlServer
- Maximum number of Tables - is 4^15 big a number?
- Triigers FOR in Merge-Replication
- Linked server and text file...
- Full 2000 .NET and SQL Server Interview questions with answers PDF
- New to SQl Server
- NEW to SQL
- DTS - Need to Set Destination Filename dynamically
- got an error
- help needed to fix an error
- Waarde uit tabel incompleet
- SQL Server 2005 Database mail Command not supported (502) SMTP error
- Which Replication Method To Use
- HDD still full after shrinking transaction log
- How to build a procedure that returns different numbers of columns as a result based on a parameter
- Error 0x80040E31
- MS SQL server and (missing) ANSI DATE-datatype
- help
- CONVERSION FROM CHAR(4) TO DATETIME
- Exclusive connection MSSQL2000
- Pls Help With JOIN query...
- sql question
- One Record from many tables
- XML Data type storage
- restore sql 2000 bak to 2005
- Variable in while loop not getting incremented
- Permission to create views
- Xquery Help SqlServer2005
- ODBC database slows down over time
- Update Trigger
- Insert Data into a table
- SQL Active Directory Query
- Updating 20 some servers
- record locking in MS SQL
- User unable to update database
- Shrinking database log used for mirroring
- Severe performance hit with NCHAR queries
- Sql Server Distict
- float vs decimal
- float vs decimal
- Link two tables using union
- how to find the unique key and foreign key reference given the table name in MS SQL
- Have two identical SQL Servers
- Any suggestions??
- Database updates (using SqlDataAdapter) during runtime but Database Table Does Not Update
- Database Updates During Runtime But New Data Does Not Appear in Data Tables
- Manual back of database error
- Conflict With Network Communications
- Sum hours from the date on this row thruout the rest of the database.
- SQL select question
- Database Cloning
- case insensitive
- UNIONs and Running Totals
- Export SQL05 data to Access
- A new approach to storing ordered hierarchical data in RDBs.
- Create Database using C#
- How to deploye SQL 2005 Express with my application
- login and privileges effect on optimizer's choice of plan
- How to Add New Line Character in Database in Ms - Sql
- dynamic query
- math error
- Extending or Linking to ASPNET.MDF?
- How is better to get SUM OF COUNTs
- SQL Server Installation Error
- Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
- appending two datetimes which were converted from strings
- Clearing up cache selectively
- Maximum Date in a group of records
- How to Identify an Array
- PRINT 1/(1+26)=0?
- Microsoft Open Licence Program - What is it?
- Getting Data from SS via HTTP
- Count Query Question
- Help with FOR XML - How do I return the results like this?
- SQL Server Upgrade
- Insertion Time problem with SQLAIW32.DLL and SQLAKW32.DLL
- noise words in my full-text search condition?
- Connecting to more Database
- HELP... ihow to mport .txt files into sql 2005!!
- SQL Server 2000 + 2005 working on same windows 2003 server as seperate instances
- Multi-user Password Database Solutions?
- how to swap the value of two colum in the same table
- SQL express-solving 4GB size limit by multiple database files?
- How To Retrive Data If There Are Large No. Of Datas In Table(by Minimum Time Conusum
- Configuring SQL
- Configuring SQL
- Converting database to MS-SQLServer from PostGRESQL
- primary key
- different database
- top 5 rows without top keyword
- strings with sql
- In
- What am I doing wrong here?
- SINGLE SQL TRIGGER for INSERT, UPDATE & DELETE
- how to script binary data
- Yellowfin leads the new players in taking business intelligence mainstream.
- Querying 5 tables: SQL using MS query
- Best practice for database migration
- Help with a complex UPDATE query
- Backup Strategy for MSSQL
- Optimize query
- Databases
- How To Retrive Data If There Are Large No. Of Datas In Table(by Minimum Time Conusum]
- How to configure a PULL SUBSCRIPTION?
- Plz Help me out in this query
- import/export utility
- SQL Server 2000 Replication problem
- Very new to SQL
- OLE DB provider "MSDAORA" for linked server "infonet"
- How to pass parameters from Visual Basic to SQL Local Package
- connection strings problem solution
- round to nearest WHOLE number
- DTSRUN.exe install
- strange results when calling a sql stored proc from within an Access2000 project
- Sending a string from a mssql to another server, using the port number and the ip-adr
- How to join a table of a local database with a table of Remote database.
- Problema Server.-
- Problem with WHERE IN
- how to use cairage return chr(13)
- How to search % in a query
- 2005: SSPI library problem
- Problem Accepting Null values
- database connection with oledb provider for sql server
- foreign key to multiple primary keys
- SQL tables and relationships
- Simple Script to create DB, specify file location and set owner.
- Delineating Factors for Code Placement
- Grid vs Text output
- Select Query - can I use a Pivot table?
- Nested Inner Joins
- splitting SQL 2000 db into multiple file groups - how?
- snapshot agent failure on unknown table
- I want to revert back to original state of database before i performed restore database
- Reclaim Reseved Space(MSQL) to OS
- how to find unknown table name from databas
- Converting a file into multiple tables
- problem with trusted connection (asp.net)
- combine 2 database into one
- SQL to calculate surrounding suburbs
- Modifying sp_password
- Replication merge instance is not find in Performance Viewer
- ODBC Excel - SQL 2000 has but not 2005?
- Help needded in Sql2000-Triggers
- How do UPDATE
- Using temporary tables within the stored procedure
- Using a temporary tables within the stored procedure
- Conversion Of Sql Statement To Db2
- COUNT FUNCTION ON MULTIPLE COLUMNS
- General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
- SLOW performance on table with image fields (SQL 2000)
- Automatic Fields
- Len Trim
- default is NULL
- case sensitivity
- 200611 to string 'Nov 2006'
- T-SQL Question
- primary key
- UPDATE & INSERT speed improvement question
- MS SQL/ADP loses records
- Trigger on an Access database?
- Multiple col ina single col
- Help for Sql Query
- How do i find indexes of the columns in SQL server 2000???
- Rolling up spans without breaks between them
- Some Data from SS2000 to Oracle : Options ?
- xp_smtp_sendmail error disconnecting from mail server
- Subquery problem
- Non-patched version of MSDE
- Nested Tables
- How To Connect SQLServer Via a Remote Access Service (Dial Up)
- SQL Server: How to shirnk the Bakup file
- Instance Licencing
- FOR XML not working in a subquery
- Need help in retrieving distinct from duplicate column from related column list
- Using COUNT FUN and CAST
- Tuning Stored Procedures, sub-tree cost, cpu time, and reads
- SQL database Diagrams
- WHERE columnName = 'this' AND anotherColumnName IS NOT NULL
- How to loop through this sql table and display in ms access listbox
- First Posting
- select records between dates - query works in VS 2005 but it doesn't in asp 3
- Schema changes to SQL Server
- Transfer data from an excel sheet to table in sql data base
- Retrieve data using multiple select
- How to execute a DTS Via a stored procedure
- mysqladmin: connect to server at 'localhost' failed - MySQL
- Query Data using multiple select statement
- single quote
- Among Numeric and Float
- Adding a new Column after a particular column
- Survey...Please help and respond!!
- Actuarial sql statement Need Help.
- hii
- Please Help With Complex Update Statement Logic
- parameters
- sql server
- ISQL: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ' '
- how to store photos in sql server and...
- Trim function
- how to remove leading tab from string
- prevent one single row from being updated
- regular expression issue
- Help with joining/selecting values to show
- Select Unique Distinct records for Column
- Select Unique Distinct records for Column
- Error on updating/adding record
- SELECT Problem
- SQL with greatest date
- help me in sql server codes
- Use of Model database
- Changing column values on table insert trigger
- Stored procedure issue!
- t-sql turn off a cpu
- Getting Error code from SqlServer to FrontEnd Application
- DTS Package Import
- MsAccess/ADP - record source doesn't exist
- Return dataset in one column
- data recovery, after overwritten many times mistakenly
- Please any one try to solve this. its Interesting.
- Basic Replication trouble.
- decimal problem... help please
- Get Data From an open Excel Sheet
- Remote SQL Server Backups over Internet
- How can i solve this problem?
- SQL 2005 & MSDE 2000
- Copy databases from SQL 2005 server to SQL Express
- help needed
- BETWEEN returns invalid data
- SQL Query Analyzer
- Getting back set order from the IN param
- Hot to inser row in a table
- sql server 2000 cluster issue.
- Connecting to an SQL Server using a workgroup
- Databases in SQL Server
- what does this (+) do?
- MSSQL Replace() for first occurance?
- creating a database in SQL 2005 - using windows 2003
- Problem with IN statement in Stored Procedure
- HELP - need a function like MID in access
- Embedding sp in to one transaction
- using trusted connection from unix
- LEFT and string function
- SQL query filtering date field by today's date?
- get 5 latest invoices (based on InvoiceDate) for each customer.
- Lock Problem and application is slowed down
- Datetime output diffrent in C# and MSSQL
- Connecting to 'localhost' Problems?
- importing blobs and other monstrosities from oracle 10g to sql server 2000
- looking for beta testers: new SQL comparison tool
- Publisher is empty under Replication Monitor - Publisher.! But replication is still running fine..
- MAX(DATE) - help
- convert / group by date
- SQL 2005 -- export table to a "fixed width" flat file -- Posting again
- where DTS in SQL 2005; Oracle to SQL2k5??
- Sql 2000 Replication
- Percentage returning 0 values
- Low process speed Large scale storage question...
- Tricky group by date problem
- query to find a sum of char values present in different rows
- Can't connect to SQL Server from Novell workstation
- Point in Time Restore
- Execute Extended Stored Procedure in user defined function
- .
- Stored Procedures and Functions
- Problem with executing DTS package !
- Runnable master awaiting command
- Create and then USE a dynamically-named database?
- FoxPro vs. SQL
- Trouble with Informix datatypes
- SQL 2005 & Login Triggers?
- Too Many Columns Found in current row
- How do i update I record in a table via a Trigger?
- Merge 2 queries
- SQL views
- Direct Client - Long term project for C#,SQLServer, ADO.NET in NY/NJ/PA, US
- CASE Help
- Database Migration
- Comparing Database Data
- setting up witness on SQL SERVER Express
- SQL 2005 - Export table to a fixed width file.
- Encryption keys for Reports Server
- Linked Server
- Importing text files - DTS help needed
- Query related to SQL ERROR
- URGENT Connection Ctring help!
- Need to declare multiple values
- Weird errors when trying to insert with IDENTITY_INSERT on!
- Precision Problem
- CASE: cannot test for empty string
- How to convert binary data to string?
- 3 / 2=1? Strange result in expression...HELP!
- ACCESS ADP TransferSpreadsheet
- Running a DTS with parameters
- Selecting TOP X child records for a parent record
- Help: Stored Procedure performance issue.
- How to Update 1 field with the value out of another row
- Indexing on UniqueIdentifier type column
- Urgent, Time out Expired/ need something to do from SP itself...
- index tunning
- SQL Server Client
- SQL Scrip help
- SQL Web Service Stored Procedure
- SQL 2005 CLR run out of memory.
- Filters on the data
- Filters on the data
- Trigger issue on Mass Insert/Update
- Import Specs
- SQL2005 - don't see my database when I use VPN-connection
- Sequential Number in an Update
- 2005 connecting 2000 ?
- view works, but the sql from the view does not
- use variables in WHERE doesn't work?
- remote desktop and db performance
- SQL 2005 express and linked tables
- How to load jpeg file in SqL2000 and how to retrieve from SQL2000.
- DBCC Memory Status and Query Plan
- move/upgrade MSDE to SQL 2000
- MIGRATING
- database analysis
- Duplicate rows in the Dataset!
- How Can I Ignore Accsents and diacritical marks in WHERE statement
- how to get the time a table was analyzed in sap db ?
- Copy Database Wizard across domains?
- SQL 2005: Unable to edit linked table records
- use IF in WHERE clause?
- TOP N Value per category
- Encryption of SQL Express database with password
- Error after upgrading from MSDE to SQL 2005
- Help with a query
- How to find query plan for a stored procedure using temporary tables
- Return subquery rows as one delimited column
- Migrating from JET to SQL Express database - Using Deltek and MSAccess softwares
- How to exit from script when find one DB does not exist?
- Question on scripting
- Data Execution Prevention (DEP) - SQL Server 2000/2005
- simple way to convert '1900-01-01 17:12:00.000' to 5:12pm?
- Scrambling sensitive data
- reference an outer column from a sub query
- DBF file export issues onWindows 2000 SQL server w/ DTS/ SQL 2005 with DTS
- using PK as Field Name?
- .NET 2.0 and .NET 1.1 co-existence?
- What am I doing wrong here?
- The best methodology to test load script
- this is very urgent,please help me
- Passing a parameter to views
- ExecuteScalar returns null
- Posting Guidelines
- two versions of sql on one server?
- Query autocomplete in SQL Server Management studio?
- Help with an update query
- Grouped rows inserted into columns
- Defining Database with Local Variable
- use INSERT INTO with a VALUE which a variable
- Duplicate Column
- how to load old datafile
- SQL Server Sizing - Hardware requirements for SQL Server 2005
- ComboBox items from a column in a database table!
- Installing SQL server 2000 on windows 2003
- Generate SQL Script
- Enterprise Manager takes 10+ min to open
- Restoring multiple transaction logs
- Order of GROUP BY - does it matter?
- If Staement
- Use array in SQL 2005?
- I have a basic question about SQL server
- Simple beginners question about stored procedures
- Testing load scripts
- Monitoring Inserted data and comparing against selected data
- Import Excel file into SQL Server
- Query with Group By Causes TimeOut Error
- Group By Query Casues TimeOut Error
- Group By Query causes TimeOut Error
- Possible Bug in SQL2005 query?
- triggers to transfer to other db
- Need your help to remove spaces in the column entries using SQL
- ASP SQL installation error problem
- Variable in a string problem
- Simple update query is making me lose my mind...
- SQL Script to find User Names in User Databases
- How to run a SQL script from within a VC# code?
- making JOINS
- Accessing specific records
- reindex
- SQL Reporting Services
- need help on store and compare time?
- Store procedure doesn't work for web application.
- How do you conditionally fire a trigger (mimic replication)
- No Local instance with SQLServer2005 Dev. Ed.
- communicating msde with sql ce for pocket pc
- Progress DB to MS SQL Server 2000 Sync (Copy) Delay Problem
- Need help in writing a VB Script in DTS to establish relation with WMI resources
- unable to run mysql server 5 on windows
- Making Connection to SQL
- Query Problem in Access
- retrieve data from 4 tables
- MSSQL insert into data conversion problem
- Coalesce / Comma Delimitted List
- How to combine 3 SQL statements into 1?
- SQL 2000 Text Field Problem
- JOIN / subselect problem
- Sql server Enterprise manager
- deleting a backup device
- Modeling
- Ansi Padding
- Ansi Padding
- Running a SQL server 2005 job remotely thru an AS400 program
- Migration from SQL 2000 to 2005
- SQL Server 2005 - SELECT query
- Learning about Indexes the Hard Way
- SQL statement to compare and return one aggregated value
- sql statement to select customers contributing top 60% of sales
- What is the best way to store a shopping list or order?
- SQL Query return unused values
- Moving from SQL 2000 to 2005
- Delete Column
- Web Page And Sql
- help with query
- database problem
- Creating stored procedures in SQL Server 2005 Express
- least currency
- Convert month into its number equivalent...(Ex. JAN=1,FEB=2...)
- identity
- how to access sql server 2000 on ms server from unix platform
- Regarding Integration services in Sql 2005
- Execute an schedule job from MSDE with LINKED servers in SQL Server
- MSDTC?
- "the data provider or other service returned an E_FAIL status"!?!?! WT-???
- CDOSYS Mail Using SQL Server
- SQLServer 8.0 Sp3 to sp4 upgrade
- automated role creation
- Recursive Stored Procedure?
- SQL Batch - Slow Response - Remote DB query
- can anyone solve this sql query?
- can anyone solve this sql query?
- 2005: T-SQL to download?
- MS SQL rollback!
- Related Tables: Help Needed With JOIN Query
- Er-win connection problem
- SQL standards
- Creating tables in SQL 2000 using C#
- SQL Server
- SQL Codings
- DB2 Reason Codes ?
- a beginner question
- How can I create a cool data model table map?
- user defined funcyions in sql server 2000
- Unable to create index 'PK_Contact_Table
- how to get the difference between two dates ,excluding weekends in ms sql?
- viable question
- reading log files mdse (sql server 7)
- Chain Multiplication on a column
- Sql Database marked suspect
- Select Range
- weird database back up sizes
- (datediff(ss,,) / 60) rounding down the minute
- OPENING FOR MAIN FRAME DEVELOPER
- Return percentages in the query.
- Update & Select in one?!
- Calling C# Code within DTS SQL SERVER 2000
- Trigger Fireing
- Using trigger to notify an assembly of changes.
- Case Statement in Where Clause
- Using Substring to Update data in a column
- T-SQL (Stored Procedure) upgrade from 7 to 2005
- Processor licensing
- what is wrong with sysfiles tab
- Hard Code the start date and the end date from an existing SQL query!!
- Subquery in DTS No Longer Works After Years
- cubes in sql
- Stored Procedure - Urgent
- table copy
- .DAT files to MS SQL ServerV7
- Want to Compile C embedded sql code by MSSQL server 2000 on linux
- Stored Procedure to run query and insert
- how to fetch case sensitive distinct data from sql server database
- Transfer user password from old database to a new one
- user/schema problem in SQL Server 2005!
- Parameterized Query Performance Help!
- Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server?
- complex(?) query
- Tutorials on XML, XSL, Javascript, SQL & ISS
- How to Copy Users? Help
- SQL 2005 Processor VS Cal
- Updating part of an XML column in a sql server table
- Unique Identifiers & Select Queries to MSSQL in PHP
- Query Assistance Needed - Please
- Query Assistance Needed - Please
- Query Assistance Needed - Please
- run a Package from package
- [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax
- changing default value in alter statement
- C++ programmatically reconnection to SQL Server 2000 after stop/restart SQL service
- SQL WHERE CLAUSE HELP
- clever date to find most recent .bak file
- SQL 2000 - Initiate or Force Replication
- Replacement for ISAPI in SQL Server 2005
- Multiple table join
- Deleting duplicate rows in a table
- MS SQL 2000 Performance / Ram Usage
- T-SQL FROM SQL to DB2
- Dan <-- 香港IT界超级溅人
- Text too long to be edited
- Compare record count in table1 to qty in table2?
- Converting Access Query to SQL Server Query
- Synchronization of two SQL Server databases
- Double summation
- How to connect to MSSQL server from HP-UX environment
- how to retrieve random records from table
- provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specifie
- time out expired
- how to delete lines from text file
- Adding text to a text column
- sqlserver problem
- installing sql 2000 & 2005 side by side
- how i can import data from multiple servers
- Dynamic addition of columns to a View
- Database Connection
- Information No.of database deadlocks and No. of transactions per second/minute in MS Sql Server
- Sharepoint and MS Access
- Delay between CREATE DATABASE and ability to connect to that database
- Help with statement
- Drop all indexes in a table, how to drop all for user tables in database
- Value zero is being returned.
- Replacing the second carriage return
- diadvantage & advantage of identy column
- composite primary key...