View Full Version : answers
- Problems with URL's
- Retreiving Database Structure in VB
- Backup and zip the Transaction log file
- Using Scalar functions in views
- How to work with time in format 'hhh:mm:ss' (more than 24 hours)
- win2k3 sp2 and sql server 2k
- Comparing databases
- How To Create a PDF from a stored procedure
- SQL Server 2005 - Merge Replication
- Need Help BAD... SQL table drop problem
- Design Table; Columns/Description get with SP???
- Design Table; Columns/Description get with SP???
- SQL Pass Through to monitor backup and restore
- Truncating duplicate entries in a table
- Truncating duplicate entries in a table
- a webpage that directly inputs data to a specific table in an sql database ?
- Date Operation
- SQL 2005 Backup Jobs
- hi
- what is the difference between sqlserver and oracle,sqlserver 2000 and sql server 200
- charindex with error handling?
- Backup and zip the Transaction log file
- DUMP transaction LOG
- Reading from SQL Server
- Sql Server Double Messages
- Change from Full Recovery to Simple Recovery Mode?
- trying to update a table with web developer studio 2005
- ODBC & Remote SQL Server
- time conversion hiccup
- Dynamic Where Clauses
- How to match Partial Values
- SQL Server 5 basic question
- creating tbl permissions
- BCP derived fields
- SQL Query to sum accross the row
- Basic Question on Joins
- how to call database stored in a file to update the other database on SQL Server
- MS Sql replication - Primary keys problem
- MS SQL compare columns to generate display name
- validation of only dd in DD/MM/YYYY date format
- SQL 6.5 server connection problem
- BCP Problem
- Create procedure to insert records for a project
- Any alternative for stored procedures in MySQL 4.0 ?
- Retrieving the rows...
- SQL to Text file
- Get unlimited visitors to your website
- Error while using DTS package
- Monitoring MSSQL server 2005 from Linux
- Require Solution for this SQL problem
- Require Solution for this SQL problem
- making datareport in SQL Server Provider
- Select Records and Insert into Text File?
- Unable to get Query Results to display in a single row
- sql 2000 personel addition
- Reducing many-to-many to one-to-one
- Search for specific length string in column
- SQL Enterprise not updating table
- To get all of the columns except for certain ones
- Alter Table
- HTTP POST in SQL Server 2005
- Opzn Forum 4 ALL
- Open Forum 4 ALL
- Call a Stored Procedure within an SQL statement
- Alternative for stored procedure in MySQL
- Trigger & XP_Cmdshell
- Having trouble with GROUP BY ...
- Stored Procedure Vs UDF
- How to ensure the right number of records gets updated
- indexes
- mssql8 AND mssql 2005
- HELP ME! Error occurred during creation or modify of a DTS Package
- SQL Procedures
- Replication issues after a Database Restore - Unable to drop or create Transactional Replication
- Violation of PRIMARY KEY constraint 'PK_Insured_Person'. Cannot insert duplicate key
- Storing pictures in database
- Merge two records
- SQL 7 & Server 2003
- index tunning
- selecting top 10 entries from multiple groups
- Getting the last inserted row by smalldatetime
- Do you understand this Error msg (ERROR Msg 512, Level 16, State 1, Line 33)
- Deleting multiple records from a datagrid using cursors
- output data of the table
- selecting value from a drop-down menu
- T-SQL to find commas in database
- RE: CASE Statement, works but.....
- How to insert another WHERE
- Select a field twice with different (special) conditions
- CASE Statement
- Online SQL Files?
- Database Diagrams export
- import database to another server - howto
- Help with UPDATE trigger
- How to delete 1 record from defferent tables?
- sql-How to convert a table data into XML
- store result of query into a variable
- Flat file to DB using DTS
- Joins for more than two tables
- Set password as 'password'
- Trying to create a linked server from an SQL Server to another SQL Server on another machine.
- Syntax Error on a DTS Package script
- Deleting Records From A Table
- How would you... (binary info in a table)
- integratedSecurity login from Linux -> SQL Server 2005?
- Query Help using SQL Server
- One to Many with a "Not In" component
- Drop and recreate constraints
- simple OUTER JOIN (I thought)
- sending a mail alert to job seekers
- Database Restore Checklist and sql2005 running on virtual machines
- Can't log in as sa
- Locks the tables while running Report..VeryUrgent
- Database Backup using Query analyzer
- about restore
- updating tables in two servers
- Kill user connection from database
- views from different database
- Avoid Inserting Duplicate Entries
- SSIS package configuration
- SSIS Extract fails without much error.
- one column text with multiple records to multiple data coulumns
- Kick off Stored Procedure to run Nightly?
- AnsiNulls property broken
- Error 26 message
- CREATE TABLE syntax error...
- Phone number conversion to XXXXXXXXX
- Deny user roles from a Stored Procedure.
- SQL query
- Please Help!!! Sql 2005 How Can I Convert Columns Into Rows
- expire a user account/login in sql server2000
- sql mail
- Understanding tables as variables
- Retrieving the contents of Cell based on values
- Compare based on table values.
- If you really want lauf, cklick down on the link:
- Multiple records in one row
- password storage
- Live updates?
- Streaming database updates?
- Add records in a table
- Updating a row in a recordset
- JOINING 3 Tables Using LEFT OUTER JOIN
- Help with the IN() function
- How to get the position of a character in a column/String
- Opening existing project
- merge two database with all objects
- Mapping tables
- unable to load dynamic library....
- char vs varchar and indexes
- How to Delete a Chile Records from a Parent table ?
- How to write a query that selects all except...
- Adv. SQL Query Help
- Crystal Reports Date/Time Issue
- SSIS - how to fail the package when the for each loop container finds no files
- Complicated query
- Complicated query
- Get Sql Date Format
- CASE and DATE statement - Need Help :)
- SQL WHERE EXISTS vs. SELECT *
- JDBC connections w/ AD login?
- Log File (LDF) ???? (HELP)
- Rename a MS-Access table using SQL Query
- sql instalation
- sql rules and udt
- Is possible to create dynamic reports based on cubes?
- use fetch to retrieve and then update or insert into another DB table
- cursor and fetch statement
- how to use multiple delimiters for the same flat file
- creating a back up [create and insert statement] for a table in mssql server 2005
- update or insert data from one table to another
- Sending Mail
- Ms Sql
- Help needed: Granting Create table permisions on specific Schema Options
- Download
- sql server does not exist or access denied
- Broken Lift Chart and Empty Classification Matrix in Data Mining
- Importing images to SQL Server 2005 Express Edition database
- Data fetch from database
- Need Help to do a GROUP SUM
- Need 2 reduce Physical Log Size on Disk
- Export data from DTS
- Return comma seperated value
- SQLServerAgent
- Database replication
- ms sql server
- Changing data-types
- How to count the number of records in one table and update the count to another table
- String/Date Concatenation causes conversion error - streamline fix suggestions
- Wrtting to the text field
- Getting a Stored Procedure to wait 20 seconds
- views and stored procedures
- Format for six character date
- Beginning question about coping/moving a sql database
- SQL 2005 - linked server between 2 databases on one server
- Advanta releases ATLAS BI using Yellowfin Business Intelligence
- Getting the Auto Generated Column values after Insertion
- Difference between SQL Queries
- what's the syntax in getting the Age with birthdate given
- Field Generating
- Snapshot query
- Help with Like Query
- regarding data types
- setting a null value to zero in a stored procedure
- SQL Logshipping 2005 - Load Delay Period Problem
- How to slipt the values in SQL server
- SQL query
- I need help creating an SQL Script for MS SQL 2000 Server
- SQL help urgent
- How can you assign system objects to a variable?#$@!
- Ms Sql 2000 Stored Procedure Help
- Use Bulk Insert Statement with JOIN !!
- fetch url from database
- group by
- How to View Results from a Stored Procedure in a Listbox
- Apparent DB engine bug in SQL Server 2005
- MS SQL Server 2000 -
- Round number off and change to currency
- Trigger
- problem with subselect
- Change "Group By" data in one column into multiple columns based on Group
- Joins
- Query across two tables
- Migrating Database changes to Production
- Comparing columns in SQL server 2005
- Organizing MSSQL database???
- SSL SECURITY ERROR : CONNECTIONOPEN 9SECDoCLIENTHANDSHAKE
- SQL 2000 Trigger Question
- forming a string with dateparts
- SQL Server 2000 Date Format
- TDS and character encoding
- Help Needed For Date field (Age) Calculation In SQl query
- Sql Files
- Collation Question
- Counting how many RI levels deep for a table
- Converting GetDate() to current date with a specific time
- Locking
- Incorrect Counting Total -SSAS
- passing parameters using select * Like
- SET NO_BROWSETABLE ON ?
- retrievng text or ntext data from column whose data type is ntext/text
- Backup on Network
- Schema Change of the table which is under replication
- No Notifications appears when converting text column to varchar column
- Getting error while inserting the rows using linkedserver
- T-SQL or stored procedure to find employees with salary in top 5%
- SQL Error Logs - changes to DB states and detachements
- Reporting Service: Drillthrough parameters didn't appear in the report.
- fatal error
- SQL Turbo (Quest Software)
- Using variables for the parameters in DATEADD
- Who's online?
- update date in one tabe with year from table1 and md table 2
- Using MS SQL 2000 .bak file with SQL2005
- To display Selected data from One web user Interface page to next on Button Click
- How to convert data into xml
- sql server 2008
- DTS copying incorrect objects
- Sql Error When Trying To Install Sage Act
- CPU Time usage shown in EM-CurrentActivity/Process Info
- Using SELECT INTO within a Scalar Function
- Joins or Temporary tables
- Connect by in SQL Server
- Finding out triggers in my database
- Volumn Shadow Copy Errors
- Sum Case Function
- Query to copy rows in a table with a change in two columns
- copy users on server to another - SQL 2005 SP2
- Problem Connect to Reporting Services via Mgmt Studio
- Replace
- uniqueidentifier Type
- how to setup sql server on home pc???
- Invalid column name error in sotred procedure
- Problem in DTS
- MS Access Macro Scheduling
- restoring msdb from a network tape backup
- SQL2005 login failure
- Join criteria and the Where Clause...
- Restore sql server express bak file as different db?
- how to change an existing table column to autoincrement with out affecting the data
- retrive the last saved date in table to select method in another page
- Communication link failure
- how can i send mail by using sql server
- SQL Query to sum values across 4 tables
- Query to reduce a 1-to-n relationship to 1-to-1
- SQL Server Conversion
- SQL Server Conversion
- Convert INT YYYYMMDD to date mm/dd/yyyy
- Convert CHAR YYYYMMDD to mm/dd/yyyy
- SQL Server 2005 Reporting Services Problem
- help with while loops
- Convert MS IIF STMT to SQL Server 2005
- Ntext column value to a file
- getting erorr Procedure 'up_reason' expects parameter '@EmployeeNominationID', which
- Deleting repeated data
- File upload into sql server
- Dynamic Columns
- Getting string part based on some character in MSSQL
- to query all days of a month
- getting the data from more than one table
- sql select max note for a row and join
- replacing string problem, please help
- SQL 2005 - Full Text Index question
- Some explaination needed on problem exporting a database
- Linking MS SQL tables into MS Access 2003 - too many indexes
- How transfer user accounts from SQL7 to SQL2005
- Run all .sql files (scripts) in project (SQL Server 2005 SP2)
- Amazing - Case Sensitive SQL Server 2005
- Unbelivable - SQL Server 2005 is Sace Sensitive
- Problem with Subscription
- Need Help with SUM Query
- Return DISTINCT Values
- column name and value in rows
- SQL sever 2005 express move windowns authentication choice to mixed authentication
- Restore LDF file after restoring backups in SQL Server 2005?
- How to find day from date
- Help me
- set a time out on a value
- Mapping tables to stored procedures
- Creating a sustaining counter as in work orders - unique
- Error converting data type varchar to numeric.
- Need to find instances of duplicates within a column; joining 2 tables.
- Runtime error
- Stored procedure to update multiple table same time
- REPLICATED SERVERS Index FT Data differently.... WHY?
- Can't sort duplicates SQL Server 2000
- Need help w/ a script
- distributed transaction problem ?
- ssis EXEC command
- HELP: Multiple GROUP BY !!!
- Problem with DB_OWNER role..
- Questions on inserting jpeg image into SQL table
- Help Please
- My question is in SQL
- Using an Aggregate in the GROUP BY
- Trigger: Update
- Rewrite from TransactSQL to CLR on c#
- Transact SQL Help
- Problem while 'clr enabled' in SQL Server 2005
- MS SQL dealing with duplicate columns in rows?
- alter colum
- losing ms sql server2000 data
- converting rows into columns when the count is not known
- Urgent Query
- Update Statement in Table - Please urgent help required...
- An expression of non-boolean type specified in a context where a condition is expected, near ')'.
- A floating point exception occurred in the user process
- SQL Server error
- ACT7 instance of Microsoft SQL server 2000
- Trigger SQL Server event from MS Access
- Error Msg 8120
- Log Shipping
- MS SQL Replication
- SQL Server 2005 Express Edition
- Help On Trigger
- Query to get the names of items with different levels
- Delete duplicate rows from two tables with same structure
- how to design social network database
- MY SQL trigger(PK generation problem)
- Dbms/rdbms
- Searching and matching string field
- Searching and matching string field
- Delete rows in relational database
- SQL SERVER - Access more than 0ne instant
- setting value to sql varialble thru access
- Excellent Resource
- inserting into db not working
- Update Specifc Record in Non-Referenced Tables
- How to check if a Table is <empty> ie doesnt contain any rows
- MSDE Database
- Subquery returned more than 1 value. This is not permitted when the subquery follows
- Connection problem with SQL Server 2005
- how to retrieve random values from a database table
- Changing Owner
- SQL Server
- Combine record
- Summary script
- Search and replace on all columns
- Join problem
- TABLESAMPLE question
- Sqlstate 22007 Sqlcode -181
- Algorithm for large set comparison
- Invoke Oracle procedure from SQL SERVER
- Trigger Help
- How to create an admin with some limitations?
- Pass Parameters to select Query
- Data base growth control
- Best way to capture/export about 45 fields - 3000 records
- Need to insert a header in a tsql select to run in an SSIS package
- WHERE question
- Geographic Locations in a database
- Passing table name to Stored Procedure
- import xml using ssis
- Inserting date issue
- SQL View of MS Access
- Change SQL from DAP
- Displaying Updated Columns
- Need help rewriting a subselect as a join
- IF Statement Error
- Blindare utente SQL amministratore
- Knowledgeable yet simple book for database modelling or database design
- ODBC Timeout problems but very hard to pin down
- Problem with logshipping, but no errors
- MS SQL copy new and modified rows from TABLE1 to TABLE2
- Problem performing remote queries
- Getting error while creating a trigger with INSTEAD OF UPDATE
- wants sql query
- Calculate leave days from Startdate to enddate of contract
- Newbie Question - Service Manager / Win 2003
- Arithmetic overflow error converting nvarchar to data type numeric.
- how to run dtexec from command prompt
- month name from the sql query
- Sql Server 2005
- Problem in Cursur
- How to update table that data came to another table using update trigger
- data transfer from .csv file to sql server 2000
- SQL Query - grouping?
- Reading Results From a Stored Procedure
- Increasing Database Size
- Need To Create "Back Up" Function
- Create script to insert 200 rows into table
- Limit query execution time
- How to create and delete tables in SQL Server.
- date change in sqo
- Remote connection Problem With SQL 2005 Thru VB Application
- standard and easy way to do schema design
- Standard Schemas?
- Job Schdule in MS SQL
- Replace function
- import data from .rpt file to SQL Server 2005 UsingSSIS
- Number Of Connection In Sql
- Backup plan reccomendations for user with ZERO experience.
- Executing SQL Stored Procedures in VB
- Stored Procedure from Application_start
- MS Query - how to filter by date range
- Left/Outer Joins
- how to merge two rows with only one unique column
- Store Procedure - Dynamic Insert
- Replication SQL Server 2005 - PostgreSQL
- I have a large database that needs editing
- Convert Character Type Date to use DateDiff function
- SQL Server database crash/hang issues HELP
- Using bcp_collen and bcp_moretext
- how to store byte array in SQL database
- Restore database with no log
- query Oracle -> sqlserver
- Nested Tables
- how to open two cursor
- SqlServer2005 installation
- SQL 2000 BackUp files not supporting to restoring SQL 2005
- Restoring SQL 8 .bak file to SQL 9 won't work
- Error in Insert from excel sheet
- Restoring from Backup without logs
- Temp Table vs. Union: Which Has Better Performance?
- Insert/Update SP
- Add ruuning count to SQL Query
- Daisy Chain data sqls extraction
- generating sql server reports
- Update trigger doesn't fire when inserting multiple rows
- Change Nofitication
- Index Performance
- Same Procedure for different database
- Linked Server Headache (Access)
- INNER JOIN - INSERT
- Using SUM and GROUP problems
- writing an sql query
- Trigger modification
- Log shipping in sql server 2000
- index
- Can we use multiple update Stmt in Single Stored Procedure ?
- FA - MS SQL Server Certification Trainers
- SQL Server 2005 sysadmin, error 15151 problem
- Rounding Down in a query
- Stored procedure question
- how can i know execution stutus of a stored procedure
- xp_cmdshell access denied output
- Saving data to SQL Data Base
- Using a range on Postcode in sql
- Excellent oppurnities in 'Bootstrap Technologies"
- Excellent oppurnities in 'Bootstrap Technologies"
- how to implemented order by in time
- Collations?
- btrieve to mysql
- Index Monitoring
- Why does SQL calc float dates different than Excel
- Need Help Regarding Sql Server
- A puzzle "merging" XML attributes in an XML column with dynamic SQL,XQuery, and XPath
- Transaction Query - Not rolling back on step 1
- Using sql to execute a batch file
- DeadLockError On Indexes
- Impoting Multiple Flat Files to Multiple Tables
- Stepping through Results
- Importing RPT file to SQL Database
- Multipling Rows
- Newbie trying to write a server side variable
- SP to parse string adding synonimes from table
- Insert after running Select query in Stored Procedure
- sql server -- result wants into txt file or exel file
- Retrieving Search Results from an SQL Query according to a certain Logic
- Call a Stored Procedure in another server
- Bulk Insert Excel into Sql Server
- Need help linking userID fields
- Number of connection to a database
- DTS Issue - please help!
- Deadlock Issue when dropping/creating tables
- Thesaurus Search - How to update the XML?
- Retrieving Last 'N' records from a Table in the Database
- Full-text indexing failed after DB move
- Needed: SQL DBA/ 12 Months / WA
- Shopping Cart and Products relationships
- Export the Data from Sql to Excel sheet used DTS
- MS-SQL store procedure to standard diagrams
- Need Query help
- Running Store Procedure as Integration Service
- importing database from access to sql2005
- required help
- SQLException No ResultSet set was produced
- SQL Server 2000, Requesting database properties lock up enterprise manager
- Multi-column Index vs Single Column Indexes
- Error on Returning More than 1 Value
- PolyServe DB Utility for SQL Server
- Authentication in SQL Server
- Export data to CSV or Text file
- Overwrite SQL exported Excel sheet with new data
- Data tranfer from Excel to SQL enterprise manager
- How to search a dates earlier than January 1, 1753
- SELECT SCOPE_IDENTITY() problems
- Query to return certain result if meet requirement
- Insert Excel Work Sheet to Existing SQL Table
- query
- Join two tables of different database
- Inserting New Field to SQLServer Back-end via MS Access Front-end
- Remote Exec of DTS MS Access Data Pump Task Returns Dreaded 80004005
- search within string
- SQL newbie needs help automating query to send via email
- SSRS Help
- Comparing Two Values in the same Table
- Issue selecting two rows from two columns
- How to do a like ... or statement
- How to write a sqlquery using joins which has 4 tables.
- Need to transfer many DBF files, while editing them at the same time
- Italic
- How Do I Block Port 1434 - Need Simple And Clear Answer
- dts/ sql server 7.0
- Need help fast
- microsoft SQL Server, Error: 500
- Need help with Query
- Most common connection method to SQL 2005
- Sql Server Error 80004005
- How can i access a column and put it in select tag of html ?