View Full Version : answers
- Running ACT! 2008 Database on two Laptops
- Transaction Isolation Level
- Transaction Isolation Level
- database structure design help pls
- Tracking Record Lineage, Family, etc.
- Convert HH:MM:SS into seconds
- update hierarchy
- SQL - how to - I need a query solution, no coding....
- Odd issue with LIKE operator and variable
- Changing Where Clause Based on Parameter
- Left out join
- Running SP versus SQL Statements
- ORDER BY error, need help!!
- Deleting Records From Sql Table
- Error 7874 Can't find the object tableName
- Executing SQL Package
- Does there have any undo or rollback function in SQL server?
- SQL query question.
- Ms Sql Server
- I am trying to install and config MySQL ... if there is a FAQ I will read ...
- System Center Data Protection Manager
- How to run a query file
- Help with SQL query?
- Little function question
- problem regarding update after in a trigger for automatic update of date
- SQL Server 2005 'Insufficient Memory to run the query'
- Drop Default Constraints
- How to select different databases
- CLR Assembly redeploy problem.
- Create Index
- Large Data Extract - Improvements?
- DB Backup - Single User Mode
- Uusing MAX() function
- get some rows into one column
- SqlClient connection to SQL 2005 creates 5000 tcp connections!
- Error - subquery returning more than one value
- Problem In SQL Server 2005 Replication On Port 2433
- store resume to database
- Open SQL 2005 database question
- problem using stored procedure to insert records into table
- CONTAINS and wildcard
- Can't figure out Sqlconnection in C#
- Error message in DTS
- MSSQL to Oracle Migration Performance issues
- indexes
- Backup time increasing
- Two Tables with Left Outer Join & Where Clause
- Sql Server-Duplicate records
- complex SQL query
- How to update A Single Column data from one table into another..
- Custom columns names for custom reports?
- Sql server-Help me with a query
- Shortcut For QA
- Sql Command For Dates In Delphi-5 Sql Builder
- Get value from query to update another another table
- Using RS.EXE to export a report from Command Line (URGENT)
- Need to retrieve Top N records AND Bottom N records
- using sp_helpdb to get size of DB's. (Or another way???)
- SQL Express hiding
- Sql 2005 Reporting Services
- How Do you Authenticate People in Reporting Services 2005 Over the Web?
- SQL remote user bandwith requirements
- Linking FrontPage to MS SQL
- Dynamic date setting in loops
- To know how many clients connected to SQL server
- Microsoft SQL Server Certifications
- sending html and plain/text email using msdb.dbo.sp_send_dbmail
- SQL Server 8.0 column error
- SQL Server 2005 SP2 update 2 rollup Performance tank
- MS SQL (Grouping then Summing)
- Transfer Image data to MS Access
- how to exit from a cursor loop on a specified condition
- Can some explain this to me?
- insert data type smalldatetime
- SQL Server Speed Problems
- wrong data type?
- retrieving a string into mathematical expression
- Count Problem Urgent
- Weird speed problem
- Count Problem Urgent
- Regarding DTS Services
- SQL Server Express under Visa linking to a pocket pc
- error_message()
- Access 97/SQL 2000 Problem
- Subquery with invalid column name runs
- SSIS Packages Not getting executed from Client.
- find rows within seconds of top of hour
- Sql Rounding Up And Down
- unable to open user default database
- How to import/export data in SQL Express?
- xml data processing in procedure sql server 2005
- how to pass the dynamic value in sql server2005
- How to simulate Replace() function on datatype TEXT column?
- Create new table with fields from 4 other tables
- Schema of Stored Procedure/View and UDFs
- SQL 6.5 to 2000 conversion
- Select first row only
- Deleting the primarykey and foreign key columns in a table
- Convert Varchar into Int
- Adding an existing database to Visual Studio
- repeated words retrival
- SQL job with winzip hung
- Schema in server
- how to retrieve values from four tables at a time
- Calculation on same table with same column
- Selecting Fixed No of rows from table and that rows should be dynamically selected
- Cannot update some records on Sql server 2005
- Insert data + XML
- MS SQL Management Studio Error: An error occurred while executing batch
- MSSQL Data View Problem
- SQL Where Clause Date Parameter
- sql
- SQL 2000 Reporting Services - Need To Get Files Out
- Bit of help before my head pops.......
- Reusing a generated column to avoid over processing
- Return result of dynamic query from function
- How to copy distinct records from one table to another using SQL 2005
- emptying database
- view
- More than 8000 characters
- Print between each gropu of the select clause
- pick out characters
- Indexes on Large Data Extract
- Autogenerating values in a column while entering data.
- ms sql server 2000 personal edition
- design Index problem
- auto increment
- Wrong result Set when using NoLock
- Error:SQL SERVER DOES NOT EXIT OR ACCESS DENIED CONNECTION OPENED , INVALID CONNECTIO
- how to form one column values to two column in sql server 2005
- Prblem With Inserting Data With Identity
- Update Record With Min Values
- Using REPLACE to replace multiple values in query result
- filter data - SQL
- Update a table using data in another table
- fastest way to deduplicate a list
- Books in Spanish for Database Design and Normalisation?
- SQL Server 200 XML Parsing Cursor Problem
- How can i store data ?(encoding and data type)
- problem with count query
- Getting data out of table
- Multiple rows combined into onerow and onecolumn separated by a special character
- MS SQL: syntax error in create table sql
- Column or Field variable for an Excel query.
- configure sql server details
- Adjacency model problem
- cast to integer?
- Picking out a part of a string...
- Wrapping T-SQL in Function and it gets very slow.
- pass Column Name using Parameter in SQL Statement...
- Corba , Msp
- if else statement inside a where clause
- Help In Scripting A Search Procedure
- Dear Experts
- Query to produce column names at top of results?
- sp_recompile script/stored procedure
- Create a table using data dictionary table as input
- indexes
- Transposing Data of Table as Columns in SQL
- stored procedures: illegal characters and sql injection?
- Run SQL script on Instance Startup
- SQL Case
- Student needs help with editions
- Concatenating string to subquery result?
- Using the wildcard character
- Yellowfin Release 3.3
- How to return unknown number of items back in onw row
- varchar function sql server
- Xml Cdata
- Xml Cdata
- Set a variable to result of executed dynamic query
- Automatic database backup
- How to find SQL Servers & Databases in Each server using BATCH File?
- data types
- how to find out a locak level set for a table. Strange problem
- Application Server on top of SQL Server
- Search related tables
- Search related tables
- SQL 2000 DTS Error: Invalid Column Length
- Solution: Invalid STDGMEDIUM structure error in DTS package
- define unique keys
- To update in a stored procedure
- delete database file on server -> sharing violation
- I want to update several tables using one stored procedure How can I my SQL code att.
- Need Help Writting A Simple Stored Procedure
- What are these queries used for?
- Connect MSSQL remotely by Query Analyzer
- Getting second or third largest value
- Laws against copying the whole database structure and scripts.
- Current Date
- SQL Server-delete query
- transactions
- Update 'YEAR' in DateTime datatype Record
- a ouple of questions about ms sql server
- is there a system table with the rowcount of each table?
- If Else + ...
- Writing a query with parameters
- Sqlserver
- RSS to SQL?
- SQL 2000 Adding a column identifier
- SQL 2000 - stored proc
- updating part of the field.
- mmsql - transact
- large data management
- read text file
- hiiiii
- SQL Log & data file timestamps not changing
- sql server doesn't work well with 250ms+ network latency
- table columns
- .bak file format?
- Service stop/start/restart questions 2005 SP2
- i need help
- Current month?
- SQL 2000 - LIKE Statement
- Help with column constraints
- User Mapping
- Conversion of updates in Access to SQL Server
- Sql Mail
- Create DTS with two databases
- retrieve first record of each customer
- Sql Server
- SQL Server - High CPU Usage
- SQL execution slow over the network
- string or binary data truncated.
- Database Protection and Auditing Tool
- A probably over and over again asked question of Syntax - Help please
- select query
- Sql Server-How to get the sequentiality of rows?
- How do I link a database in SQL
- Query Variables
- Link to good on-line documentation
- retrieve Identical records between two sub query
- Retrieving the AutoNumber field value of a recent INSERT
- How can i protect sqlserver 2000 by password
- Creating schemas
- Speed Issues After SQL Upgrade
- Indexed View Crashes ASP.NET App
- variables and temp table data
- Using a cursor in a trigger - Is it the best method?
- Syntax error in FROM Clause
- how to query for a column value that contains dashes
- How do I export sql data to an excel spreadsheet?
- Select where date question
- Would special character cause insertion problem?
- How to create a table from existed table.
- How to insert a xml file in sql server database using asp.net?
- How to display only user tables in sql server 2000
- sql server 2005 issues
- transfer of data from databases
- Order By date and time of insert
- Connect to SQL Server from Vista Client Issues
- applying defa values for tables from 1 db to another
- Cursor required for update?
- Using Shared Data Source in Web Form?
- MSSQL- Connection pooling - SPID - KILL
- Get Column Name
- How to get Regional Setting with T-SQL
- max() throwing up group by errors, please help :D
- MSSQL2000: PIPE Delimited Issue
- how to place a varchar type variable in Dynamic Query?
- Enterprise Data Architecture
- Count function
- Pass Parameter to Stored Procedure in Reporting Services
- Implications of not using sp_helplogins?
- replication in MSSQL2005
- Changing datatype from int to decimal
- any one help me for the case of "case statement"
- quary not giving desired results
- A challenge in Operators-Alarm
- Sql Server-How to insert values to database?
- How to use recursive CTE
- customize sql header result
- Using sum to multiply one column by the other
- Variable as field name in Update
- How can I change the column width?
- Collation Questions SQL Server 2005 SP2
- datatype
- Delete all data in the database
- How to Execute SQL Scripts using Batch file?
- Delimited Fields
- To Generate serial number automatically
- SQL Server 2005 database - Problem
- Remove Fields From results from Innerjoin In Sql
- Linked Server to DB2
- MSDB of SQL marked Suspect
- Can a View be protected to support "JOINS" only?
- bulk inserting uniqueidentifier column
- working with Date and Time
- Writting to same Database(SQL Server) via Front-end(VB 2005) and Web(ASP)
- group by week
- Delete Guest Owned Tables
- Losing Null records with Left Outer Join (SQL Server 2005)
- 01/01/ and whatever year is coming as current year -1
- what is use of smo
- two lines SQL update statement but got a error
- An exception occurred while executing a Transact-SQL statement or batch
- How can change retrieved data in storedProcedure
- Date Function
- How to select a word substring in a coumn header from right to left
- implementing checks on table content
- how to store and retrieve image files in sql server
- Relationship Problem
- how to get the date 2years before
- Opinions on SQL Server hardware
- Sql Server 6.5 Client Tool and ASP.net
- MS Sql query
- Some body write a query for me.....
- Writing Query to change the way that the data is presented
- MSSQL with evc++ application
- Is this possible in SQL Server 2000 and MySQL?
- hi
- Linked Server Query Problem
- How can I add picture in microsoft sql server express 2005?
- Full Text Index
- problems with restore (.bak)
- What is a 'master table' and how is it created?
- retrieve duplicates
- Date comparation
- How to populate an empty table using INSERT commands
- the best way to: SP B exec SP A where A returns value
- Problem with object owner not dbo
- Dynamic Tables Names and Temporary Tables Options
- How to populate the word template data fields using SQL server
- Count-problem
- How to write A Test Script
- how to update DATE column in a table
- Linked Server to DB2
- Create Batch file to run sql scripts
- Unable to Upload files to MSSQL database Using ASP
- Finding table size (physical disk space)
- SQL Error Causes and what might fix it
- Finding table size (physical disk space)
- Retrieve next lowest number in mixed set
- How To Change Just Year from a column(DueDate)
- SQL2005 database backup files
- SQL DATE to determine years
- UTC to datetime
- Question when subtracting two queries
- can you please correct this syntax.........
- 2005 Trigger Error
- How can I put this XML file into SQL Server...
- Error when connecting remote SQL SERVER
- SSIS and VB
- union in trigger
- SQL 2005 license downgrade to 2000
- Notification Services Updates
- negate RESULT SET, all inactive client
- SQL Server 2005 Query Error
- SQL Timeout Errors - Can Anyone Help?
- SQL Server Refuses to Process Inserts
- Creating a BCO format file
- Query Help: Select Max of Grouped Sum Data
- join tables
- multiple sql queries in a join?
- ms sql 2005 developer edition
- JOIN Error...Need a little help
- SQL Count
- MS SQL script help needed
- Please help me out
- How to transfered the data?
- Force Parallelism
- Getting Started with SQL
- View contents of LDF file
- varbinary vs image
- SQL Server 9 - Vista 64 - Error message in Event Viewer - interactive service
- replication or mirroring
- DSN ODBC pwd not saved when SSIS package imported
- Search Criteria
- using date
- Exporting a MS-SQL database
- Copy data in table in different SQL Server
- UPDATE - Help!!
- Response time for a View.
- Query to switch recovery mode
- SQL Configuration
- Do you know what the Sql CTE really is?
- The Two Standards of the Sql CTE
- Import/Export Tables - Enable Identity Insert Does Not Work
- Order By in a View
- Sql Report: Formatting PDF File Problem
- Case Statements
- Finding common joins
- Select distinc records from a table column but display all columns
- Need to add a new column to an existing table with 37M rows
- Reports of users
- Database Security
- space allocation
- Alternate to cursors
- web database question
- updating fields from related tables
- Problem accessing remote sql server
- replication
- SQL Sub Queries?
- complex tables - want to join to get one row of results from multiple rows
- Extract datas
- dumb question
- Can't get this darn thing to work!
- Select all records from one table, and count records in another table
- I want to parse @ArrayOfDays into @d1 through @d5
- Table design - PK - unique constraint?
- Uppercase all rows in SQL
- Sql Exception (0X80131904)
- How to group by this SQL statement
- Users Logged In
- Oracle Database Migration to MS-SQL 2005
- Database design problem
- how to write an if statement in stored procedure
- Comparison or LOGIC issue *Newbie
- nt authority\system?
- Query results from a DTS package in SQL Server 2000
- my sql
- join two tables
- strategies for paging
- OLE DB provider for DB2
- Dates stored procedure
- MySQL script to SQL Server
- HELP: Building SQL Query
- sql query
- change default value of column
- Query multiple tables from diffrent database in reporting server
- SSIS Help with problem
- SQL Query Pause
- SQL Server - Building dynamic query
- I want to return a string to a wrapper from a subordinate stored procedure
- Update Data To A Different Database
- The best way to use the Database Engine Tuning Advisor
- Select Into across Linked Servers
- Converting datatypes, not sure if this is the right direction?
- please give any example for using UpdateQueryColumns Property
- Set default schema in code - possible?
- isqlw won't start
- Timeout expired while retrieving data from table
- Stored Procedure retrieve Parameter values from variable
- Analyst seeks help with one table query
- Change Administrator
- how to create mail merge with word 2003 and sql server 2000 as database
- Join query not displaying all records in one column
- Sql Server Query - won't display zero returns
- a small SQL Puzzle
- SQL Insert
- Comparing like column strings in two tables
- Comparing more than one column & update
- Join select statements
- Advantages of storing datas in hexadecimal or octal formate
- resultset in a single row
- what is the use of nvl clause in sql server
- "Violation of PRIMARY KEY constraint" when no duplicate exists?
- multiple queries and single query
- SQl Insert multiple requests into one column
- Users limited access by IP
- autoincrement question sql 2005 server
- BIRT + Yellowfin + ANN mashup make Advanced Business Intelligence
- SQL Query from Access to SQL Server
- ALTER columns to remove the IDENTITY property
- query to display name and average salary who are having age>50
- Alter column datatype and default value in a table
- XML data in SQL Server
- outer joins in MSSQL
- Survey results combined
- Exporting MSSQL database
- Syntax for Writing Stored Procedure with Parameters
- ODBC-- call failed.
- how do I inner join two table to a dataset
- subtraction of different precision values
- Computed Column with bit data type
- Case Statement Problem
- Find Best Match
- query to copy the records from existing table to new table
- Converting Rrom Access Syntax To Sql Syntax
- No field delimiters using bcp command
- Removing duplicate records and to store in new table with single query
- Incorrect syntax near the keyword 'AS'.
- NAS for Clustered SQL Server
- script for comparing tables
- How to merge multi rows to single row?
- comparing dates in two tables
- Generate Scripts
- Sql server 6.5 Restore
- Attendance information retreival
- Merge Replication nested view replication problem
- SQL Mail setup
- T-SQL update dynamic tabels
- Read information from excel file into ms sql table ?
- select statement help
- cant connect to my databse in lan
- Dynamic column names
- INSERT statement problem
- Conn. Prob. contd: 'logon restricted' [Mngm. Studio]
- Stored procedure required
- PHP code to Stored Procedure
- Minus query
- Strange Connect Problem
- Trouble creating triggers in SQL Server 2005
- connect string problem
- Do foreign keys generate implicit indexes?
- SQL Statement Help Please
- Trouble with Query using MAX
- Sql query datediff syntax error
- Audit table, finding first change for each item
- query by time
- DateDiff Function
- Altova Software v2008 (with MS SQL Server support) is now available
- ODBC problem
- Nested IF Statements
- Importing database
- xsd schema into SQL Server Enterprise Manager 8
- SQL Server 2000 Remote Access
- Microsoft Dynamics GP
- Sql server 6.5 device files
- Arithmetic overflow error converting expression to data type int.
- string functions in sql server 2000
- How to export whole database schema to another database but not include the data?
- Deleting duplicate data after comparing it with other table.
- Create Function permission...
- Data import question - SQL
- how to debug stored procedures using SQL 2000
- SQL Case Statement Problem
- number of databases in sql server 2005
- SQL Server 2000 to DB2 DTS Package - Permission Denied Error
- Delete or detach a Suspect database
- CREATE Table permission
- Select statement help
- line 1: incorrect syntax near '='
- How can I delete a row from a table having primary key relation.
- CASE Statement - I'm in a bit of a quandry
- How Do I give EXECUTE Permissions on Stored Procedures?
- how do you use XML to store your data and then call it to update database in SQL
- hoe do you use XML to store your data and the call it to update database in SQL
- error in stored procedure
- Error 40 : Unable to open connection and Security Issue
- What should we do in the case SQL was installed without the proper case order?
- Pagination in SQL Server
- SQL 2005 linked server problem
- SQL overlapping date
- How to check for the value before you select it
- How to select count records that "contain" data?
- Summarizing multiple items at once
- INSERT works in SQL server 2003 but NOT in SQL server 2000
- Changing user schema
- Creating a View from a Stored procedure
- Nightly Refresh
- Market News. QSC partners with Yellowfin Business Intelligence
- SQL single file database
- gul sql number format
- single-user mode in SQL 6.5
- ms access table call from sql server2000
- ms access to sqlserver data transfer
- i want to test database trigers
- select query problem
- How do I view table information such as constraints?