View Full Version : answers
- using freetds tsql
- VBA Project password protected
- working with a local db copy
- Altering a function while it is being referenced
- Function to see if Table exists in sql server
- Conversion problem with SQL Server 2005???
- Create View ?
- Deploy windows based sql database application
- Sql
- Prblem in getting the rows affected values in sqlserver to C# class.
- Calculating Variable Date in TSQL
- Dropping an active connection on an attached database
- Error and output variables in stored procedures
- Inserting a file into sqlserver
- Stored Procedure fails to carry out delete.
- trigger to control table size in database
- A transport-level error has occurred
- Founding differences between the old and new database to update the old database
- Selecting SUM and COUNT, but not straightforward..
- Answer to avoiding Duplicates with an INSERT
- how to update DATE column (month only)in a table
- Add new Column problem
- DB2 Tutorial
- reading of .ldf files from sql server
- Opening .ldf Files
- Invoice
- Select Max values from queries for multiple Schedule_Number
- Migrating database from development server to hosted server
- Complicated question re: Saving a file from SQL server
- SQL 2k - xp_cmdshell
- Stored Procedure With Bulk Insert Not Working
- SQL Server Performance
- copy of a table
- SQL MSDE installation problem
- Token Replacement in SQL Server - any down side to turning it on?
- Reporting Services: Collapse / Expand for Table
- ? about users
- Sql query
- Form Post
- FOR XML EXPLICIT can't get element 4 going
- How to write output of a query to a file
- MSSQL Equivalent for SHOW CREATE TABLE
- Division Precision
- not all code paths return a value
- SQL Query - Help
- Listing available SQL Servers in a network/pc
- Crystal Reports
- Datediff help needed
- Search with multiple strings in single parameter
- information_schema.key_column_usage system table
- Nested SELECT FROM WHERE AS IN
- SET TRANSACTION ISOLATION LEVEL What is it all about?
- Response.redirect
- Invoice System
- SSIS Mapping Columns from Flat Files
- Multiple joins in SQL Server
- Run a Query that will bring back a report on "bad data"
- Complex query (compare records in same table / join a 2nd table)
- Error handling in stored procedure AND checking
- Active/Active cluster on 2005 - can I oversubscribe RAM now?
- help!!
- Change _ to a +
- Replacing repeating blanks with a single blank
- Prompt for User Input
- Date problem
- Calculations in a query
- run SQL stored procedure from Excel
- Converting Informix OUTER statement to SQL Server
- "Merging" results from two queries
- Pass through query from MS Access
- Delete
- Bulk Insert
- reading as array
- Position of Table Columns
- Help With INNER JOINS
- Difference between sql server 200 and 2005
- M I.5'Perse cution ' Capita l Radio - Chris Tar rant
- Data Manipulation
- Alter Table AND Update Table with Variable MS SQL
- sql server alert
- database optimization
- Globar Variable in DTS:: Urgent
- backup advise
- Copy DataBase
- Find Columns
- sorry
- Instance name vs servername
- list of users and authorizations sql statement
- Sql Endpoint creation and consumption on inter domain network
- how to get data from SQL server 2005?
- Query Update - subquery?
- sqlserver query
- Using SUM in Query to total hours based on Months.
- Extracting Duplicates from SQL Server 2000
- Convert SSIS Package into C#
- learner a ms sql
- Query - Select two tables where a.id=b.id
- web access of sql tables
- Problem with select criteria with conditions
- SQL Datatype
- To Pass Parameter
- extended procedure
- counting distinct posts by a users within the past 10 days - SQL2005
- DTS from SQL2000 to MS Access
- Multiple table data retrieval into separate table
- Format Number on Select
- Clearing temp tables
- Database manpulation without connecting to a server...
- just to do a select
- to introduce exist in sql script
- SQL 2005 INSERT statement inserts two rows
- sql server 7
- Primary key violation
- select numeric value from varchar data type + sql server
- Trigger on Insert made a strage information,
- Database Tripled In Size!!
- Indexes
- SQL 2005 XMLBulkLoad field length
- Advice for grouping stored procedures?
- Connect to remote MYSQL From the local mssql
- MSSQL2000 DTS error "Too Many Fields Defined"
- Convert MS Access Pivot Query to SQL Server 2005
- Question on MSSQL 2005 database import
- Problem with using an a subquery in an update
- SQL2005: Running TSQL commands in single-user mode
- Loose ODBC conection
- sql stored procedure parameter problem
- probleum in changing the data type of column
- abt Stored Procedure ...
- Row into Columns
- Added users to a logged shipped database
- Need help with a query
- How do I calculate minutes worked by 15 intervals?
- RECOMPILE / REFRESH UDFs?
- Time Dimension Design Question
- Restoring database hangs SQL Server 2005
- Help needed in this DATEDIFF SQL Query
- URGENT! Never ending loop
- Insatalle the Sql 2000 Sever to Win xp 2000 machine
- Sql Server Agent Service Account
- How to delete a table with about 2000 rows
- How to connect to a server (sql server 2005
- fractional truncation message
- Select Just Primary Keys from db?
- Please HELP
- find records which are in between 2 dates....
- Which is better(in terms of both memory & time): join or subquery
- doubt in using serveral datasets?
- Sqlserver2005: How to get the error message thrown from Storedproc to C#
- What is the sequence of execution of an SQL select query in SQL Server
- Key column information is insufficient or incorrect. Too many rows were affected by u
- Is there a tool for verifying data after merged access to mssqlserver
- Index problem...
- Problem with Sum.... Noobish.
- Setting Up A Remote SQL 2000 Connection
- Data Mart
- Wrong Greek characters on Windows 2000
- i want to use remote mssql server database
- Difference between MS SQL 2000 and MS SQL 2005
- Differences between MS SQL 2000 and MS SQL 2005
- Update Column with Type datetime
- sys.objects WHERE type
- Table Rows Into Columns
- Table Creation Date
- merging a date only column and time column into SQL from CSV
- Moving data from one table to another
- SQL query help
- Foreign Keys Either/Or Design
- Stored procedure date question
- Compex SQL Query containing UNION, Needs Filtering
- how we change one data type into another in sql
- DateTime format
- Relational Algebra & SQL newbie needs help!
- Step SQL Server Integration Services Package Error in SQL ServerAgent
- Problem with MSSQL? .NET application? or Win Server?
- export db tables for use locally on another pc
- The product level is insufficient for component "Data Conversion 1" (117)
- truncating data older than 30 days
- Update multiple columns
- Stored Procedures: Returning values
- SQL Express connection via VPN
- SQL login and user creation
- Complex SQL Query
- SQL Server
- SQL Server does not allow remote connections.
- Column size in emails generated using XP sendmail
- How to use value of a variable in defining data type
- Using select results for a new select
- New to SQL and need a query creating help cant figure out how to complete this
- how to throw out a 'group' of values based on different rows
- Help with SQL Sever Mobile foreign keys
- Problem In This Code
- DTS Package Transfer Help
- SQL Server 2005: How to turn multiple rows into a single column
- Replace Query
- bad bind variable trigger
- Ident authentication over local sockets
- Transfer/move data from one server to another
- Yellowfin Business Intelligence Version 3.3 release
- Entreprise Manager error message: "[Microsoft][ODBC SQL ServerDriver][SQL Server]Login failed for user '#####'. The user is not associatedwith a trusted SQL Server connection.(28000,18452)"
- Need help generating a Query
- deadlock and high cpu - chicken or the egg
- Query Help
- Remove a $ from data field
- Find all chars in table that are ASCII code 128 and Greater
- Update Query--help
- Help with SQL 2005 performance problems.
- Help With Script: CSV Import, SQL 2005
- sqlserver book
- Query Performance
- Service Name
- what is library path
- difference between pause & stop sql server
- data transfer from sql server to oracle
- begin and end transaction and transaction log
- left outer join/inner join statement
- Warning - Cannot retrieve...
- SQL Constraints Problem
- Do I need a Totals Column, if related table holds the individual amounts
- SQL Server writers, we need you!
- Best disk config for SQL 2005
- Database/Table Design Question - Object/Event Model
- Generating BCP input file from Perl/Unix
- how to send sms through notification services
- database new line problem
- Importing from Excel problems
- running a vbs file as a step of an SqlServer job
- How to write loop in Sql server 2005
- Substring after character /
- DTS-Package sends mail and files before the job finishes
- Import a notpad file into Sql server 2000
- Duplicate records - SQL Below
- Help with this query, please
- help with setting up a reminder
- Number grouped rows....please help!!
- SQL Server Agent has no Access to Path
- What is the use of Resource and Distribution System Database
- Lookup Function in SQL
- How to Attach Database to an Instance
- stored procedure to avoid data redundancy
- SQL Server BI - metadata
- SSIS Package Log File Configuration
- join with table on another database not working
- SQLDMO.Bulkcopy diagnostics on failed load
- performance test issue
- sql server 2005 180 day trial version installation failed
- Database design
- cnnecting an sqlserver instance to a site
- Stored Procedure compilation question: Doing disparate things in aproc
- insert column in union select statement
- Create Trigger within T-SQL statement
- Need SQL Script
- SQL Server compatibility with SharePoint workflows
- question regarding slow performance an PAGEIOLATCH_SH locks on sql2005
- MSDN Search made easy
- Managed Code in SQL advantage confusion (C#)
- How can I list the students in the CIS department? (SQL Server Query)
- varbinary to varchar
- Several Counts and grouping the results...
- Once a week or once a month
- Check constraints on clustered columns
- EMAIL from SQL express
- Newb: Managing multiple queries
- what is the diff b/w sqlserver 2000 enterprize editon and sqlserver2000 personal edit
- Row numbers
- To see spcific records
- Joining Tables
- Regarding Type4 driver Connection..........
- help me plz.
- Can i use Top keyword in SQL Server 2003?
- Comma delimited
- Query using schema to determine if Trigger exists
- SQL Statement: Needing some code
- Storing image to table
- SQL command to show only databases that contain a particular table
- Launch DTSRun with a stored proc
- Connection problem to Informix from SQL Server 2005 with Unicode data
- Copying data
- Global variables in SQL - ORACLE DTS Package
- Script works in DTS, but has problems as a Stored Procedure
- Please help with this SQL statement
- how to pass Average value of a parameter to another parameter in SQL
- Insert Trigger?
- Add a datestamp to an existing table
- What is the purpose of the ROWGUIDCOL property?
- Can anyone help with waittype 0x0044?
- Learning sql server 2003
- Trigger which updates the other Rows
- How to fetch data from other data base
- Insert query firing Insert & Update trigger at the same time
- multi column sub select equivalent for sql server 2005
- Detecting the conflict time and date 2
- how to protect db while working in ms sql
- Capturing data inside double quotes text
- Uploading Tiff Files into SQL Serevr 2005 Database
- Using updatable views when moving tables from one DB to another?
- Scheme login can't access tables owned by scheme
- Count problems
- Find out owner of database for SQL 2000 and 2005 databases
- give me the sql statement
- give me the sql statement
- problem in comparing date
- Passing multiple values to stored procedures
- QUOTED_IDENTIFIER & ANSI_NULLS
- sp_MSforeachtable Usage in xp_cmdshell, Know this!
- math notation in db?
- strip numeric portion of a string
- Problem with Script task in SSIS along with WSDL file to call a web service
- Sq server 2005 : Table Update when date field value cross current date
- bcp utility
- Query rows of an entry into columns
- SQL server certification
- SSIS is pathetic with ODBC connections ...
- Problem counting records
- load balancing cluster
- Windows 2003 SP1 won't let me set the lock pages in memoryoption...it says I need Sp2.
- stored procedure that retrieves next unused value
- Populating List/combo and text boxes from a MySQL databases
- I need samples of how to simplify Access's graphically nested Joins!
- Translate from OPEN FOR USING and FOR LOOP from Oracle to SQL SERVER
- How to Audit SQL Queries not generated from a Specific Application
- Using case statement or if logic
- Trigger to update table.
- SELECT then DELETE versus extra clause in SELECT
- Import From excel
- Max limitation of image datatype in sybase
- sql server database backup
- Get table row size
- Getting System Time From SQL Server
- Function that replaces ntext and compares ntext with nvarchar
- Connecting to Double Byte Progress (MFG-PRO) databases from SSIS...
- Select distinct rows from duplicate rows....
- Spatial Data and MS SQL SERVER
- What the difference is between CREATE PROC and CREATE PROCEDURE?
- Stored procedure for DropdownList
- How do you find the Existing Per Seat License info
- Data insertion too too slow...
- Clustering, Security, Performance, Load Balance
- SQL Server moving to larger drive
- Help with pivot table
- Selective blocking of Inserts and Updates
- Off Topic - Databindings and XML - Binding Text between XML Tagsinstead of XML Tag Atrribute Information
- sql query way tiring for sync()
- Importing data into SQL Server 2005 via ODBC
- Direct access to SQL Server 2005 from Windows Mobile
- SQL Server and TCP Fragments
- Need help on my query(sql statement)...
- many "or" operation make system choose incorrect index
- export from sql to excel
- Trigger doesnt get fired everytime
- Local DB Affected By VPN
- relation schema SQL Server 2005
- Ms Sql Stored Procedure
- SQL Joins
- SQL server
- Update query from another table on datechanged field
- TRUNCATE TABLE @table_name
- How to work in SLQ Server 2005
- The multi-part identifier "ticket.ticketid" could not be bound.
- Select help
- Library Database
- "select statement cannot compare one data with multiple data"
- Making a table to store photos
- Appropriate Query Optimization Technique(s) Sought for the FollowingCase
- ASP Vs Query Analyzer Different Results
- SQL Server 2005 : Insufficient memory to continue the execution
- SQL Server 2005 article
- About join
- how to Calcullate Two Dates
- Sql Questions
- SELECT INTO Another Database Problem
- Running a DLL in the Query Analyzer
- SQL query for calculating the cost price of invoiced items
- How do UPdate a last row in the database
- Concat instead of SUM when grouping results
- IS NULL being ignored
- need help
- error enabling AWE to access >2GB of memory
- foreign keys - on which kind of keys do the base on?
- Microsoft SQL 2005 Server Express Edition Install Error
- Totalling 2 columns in a table by multiplying
- Upsize from mdb to SQL Express 2005
- using modify table command
- SQL Server Express 2005 @@SPID
- Sort by the values in an IN()?
- importing a CSV file
- append date to exporting file name in SQL reporting service
- sqlcmd and escape characters
- Find Current Date Time Span SQL
- Multi Value Parameters
- Launch storedquery for each record
- Diary Schedule Insert
- data type for 32-bit
- Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied
- UPDATE from Sub-select problem
- linking to client server
- Convert cursor to set-based sql statement - HELP
- Variable in UPDATE query
- Self join one table
- FOREACH LOOP container and looping through record set ...
- Saving changes
- Integration Services
- help needed with extracting XML data
- Storing Calculated Fields
- Any way to find user who did update in SQL SERVER?
- Finding the user who do update in Query Analyser?
- MS Sql Error converting data type varchar to numeric.
- MS SQL for returning no values
- Problem On Font....
- need urgent help
- Problem Changing Data Directory in Server 2005
- Problem with reporting and queries
- How to replicate database for Dev purposes...
- pass parameter to If Exist statemetn
- Backup Files
- How to pass user defined variable to Select statement
- Can I combine Log Shipping and Clustering?
- ISNULL for a date to char conversion
- SQL 8.x: Exporting Data into Excel
- how to import a data to table from file and export data from table to file
- ho to connect sql server2005 with c++
- Stored procedures and stored functions
- Unable to load search config settings
- Error converting data type DBTYPE_DBTIMESTAMP to datetime
- Database attach failed
- T-SQL : How to find cross-conditional queries?
- many to many relationship inserts
- bcp to xml
- how to copy files using xp_cmdshell
- Beginner question, stored procedure
- MATCHING colums
- Ms SQL Server 2005 HELP
- problem on blank space
- Can we update View
- Easy case statement that I cant do
- More than 1 "LEFT OUTER JOIN"
- Sql injecting
- how to implement product search in DB with millions item within eshop ?
- DB Master Key - Sql Server
- Security Checking
- Run Sql Stored Procedure From Excel
- REPLACE Statement
- Restore a database to another server
- How to open SQL Server Management Console from a workstation?
- Division by zero problem
- tuning stored procedure, variables and different optimisers
- gridview
- SQL Query
- scheduling from Excel to SQL Server
- Auto correcting missing data
- incomprshensible code
- DTS Local Package - Date Formatting
- SQL neewbie - looking for windows front-end app for SQL database backend
- get max values
- SSIS DB to DB or DB to File
- how to get max value of multiple rows ???
- Can you help me to avoid this deadlock?
- Problem connecting from PHP
- query on date field with AM/PM designation
- databanks as test-examples
- Unicode in SQL Server 2005
- IF statement question in stored procedure
- Get all active transactions
- Unable to connect to Sql server
- Finding and Correcting Missing Column data in a single table
- Help with a SQL Query
- Working with DTS
- Any Advice on transact repl error
- Setting Defaults in an Insert Into command for SQL
- Inserting record into table as the first record
- 2760 SQL State 42000 The specified schema name either does not exist or you do not
- Deleting foreign key record
- Why is SQL Server 2005 Express on my PC and why won't it update?
- Call store procedure from function
- passing a parameter to TOP when getting random data
- ANSI NULL DEFAULT database option
- Creating Test Database
- Violation of UNIQUE KEY constraint 'IX_User'. Cannot insert duplicate key in object '
- Table linking on sql server 2005
- MSSQL Slow Queries on One Database only all others fine.
- Unable to initialize OraOLEDB from SQL Server 2005 x64 to Oracle
- Commit Transaction Even on Trigger Failure
- Update a value on current record based on previous record
- Problem in some SQL server
- VB6 compatibility with SQL Server 2005
- Copying data from one table to another in SQL Server
- SP performance slow when calling directly on server
- SQL Server
- how to optimize the store procedure in SQL server
- How to obtain previous charge
- How to create XXX_UAT a database same as XXX.
- Converting a trigger in Oracle to SQLserver
- Upsizing from Access to Sql 2005, problems with now() funciton
- round a value to the nearest integer
- Difference between SET and SELECT
- how to get maximum in alphanumeric values
- SIMPLE SQL ? Large insert
- Deploying SQL Database
- Passing variables to MSSQL
- snapshots and reverts
- Defining Parameters
- Users last logon
- Index design
- Stored Proceedure
- Problem with importing a CSV into database
- how to pull out a specific category from a database
- Best Way to Synch 2 Tables?
- MS SQL 2000 formatting numeric value to money
- Updating Character String with sql
- security checking on input string
- 3 tables join
- Is it posible in sqlserver 2000
- sql server 2005
- SQL & .NET (C#, VB.NET, ASP.NET, XML) Latest Interview Questions
- Sorting Numeric + Alpha Sorting
- BULK INSERT - Inserting txt file with columns in different order than define in table
- Stored procedure generator
- Producing week ending dates for each week of the year
- Surprising - SQL Quey - order by !!
- SQL 2005 32bit upgrade to 64bit possible?
- Optimized query
- Entire Row not Updating
- Using variable in Stored procedure - help!
- Scripting from two servers - possible?
- How to calculate the midpoint
- Striping and splitting
- Tool for comparing result of 2 stored procs
- Tool for comparing result of 2 stored procs
- error when running the DTSRUN command
- Basic Anatomy of Sql Server
- Get only Max of each distinct?
- Assertion Problem in SQL server 2005
- constructing varchar computed column , using bit fields
- How do I pass a parameter to a DTS ?
- DTS package to update Database by reading text file
- Copy table column names from SSMS Object Browser to use in a query
- SQL Enterprise Manager on Windows Vista
- sp_create_trace throws Errorcode = 12
- how to concatenate in sql server
- Updating Primary Key
- Unicode characters as separators...
- How to add a PK column to a View?
- Web Interface Development
- Output in a Single Table
- max number of instances?
- Insert Multiple Rows
- Numeric to real type
- Server Problem:
- Stored Procedure Output, why only 1 row?
- Duplication