View Full Version : answers
- week of the month
- What version of SQL Server to buy?
- Sql Trigger Problem
- New to MS SQL
- Trouble with Script - Adding column to current table.
- Managing Remote SQL Server from Server Express
- Formatting reports in SQL PLUS
- Install MS SQL Server on WinXP
- Paging in Sqlserver 2000
- Sybase info.
- SP - Convert CSV to a Link table
- Convert month No into its number ..(Ex. 1= Jan,2= Feb...)
- Please Help
- rowdelimiter not accepted in bulk insert statement , used in an sproc - please help
- Problem with SQL on same server as web server
- Examination 070-229 Resource
- Problem with migrating huge tables from MySQL database.
- TIME DIFFERENCE in SQL
- query
- sp_executesql Error Trapping
- DTS Package (Dynamic Properties Task).
- DTS Package (Dynamic Properties Task).
- DTS Package (Dynamic Properties Task).
- Error in SQL SERVER LOG
- Use of large field definitions for small values
- Numeric value only for a character field
- restore the dts
- Sql low performance
- Subquery returned more than 1 value. This is not permitted when the subquery follows
- Help with aggregate functions
- help with sql select
- restore database
- Mssql
- SQL statement query help with Date
- Join Sql Table and Excel Sheet
- Converting multiple values in form of comma separated string
- hide/show report in report service sql 2005
- how to see the data of variables in SQL Profiler
- output parameters from row with max id
- table name as parameter
- Removing Nulls
- Still need more help
- BCP help needed
- Week Number In Loop
- SELECT DISTINCT will always result in a static cursor
- Need Advice on Really Big Databases
- Problem using aggregation in MS SQL
- navision vacancy
- SQL Server equavelent Boolean values
- sql server basics
- use count & group by with union
- Parsing Abstract Files.
- DTSRun error
- how to get last processed date of a stored procedure
- Problem with cursor using DISTINC
- Why XML Output is Truncated
- need help to create a connection with sql server
- Copy table to Remote SQL server using DTS
- Help on DB Design
- Joining two tables to modify a tree structure
- SQL Server 2000 while browsing another server in EM databases shows "No Items"
- Error in DTS
- transactions
- calculating total time using datediff()
- How to copy data from a table in one database to another database using sqlserver2005
- insert data to the database problem
- Shrinking my transaction logs
- ' marks and sql trouble
- Dynamically Modify the Datepart Argument of DATEADD function in T-SQL
- Announcing beta_lockinfo
- Instead of INSERT trigger!!
- SQL Primary Keys and SET
- MS SQL IF ELSE condition checking
- zero filling
- Passing variables to an SSIS package
- Manipulating Data
- Ntext limitations??
- Kerberos setup on windows 64-bit SQL Server 2005
- Exporting SQL column to excel
- Read Only Files
- Infopath loses query fields to SQL Server
- Count diferent variables
- read from a temporary table
- sql server connectivity with turbo c++
- Which general SQL NG is more active??
- CSV --> SQL and CSV <-- SQL
- (SSRS) Generate SQL by automation?
- Set variable to value in column
- Query for Last Date in a table
- Add last two values
- Deleting all data
- general question
- Querying Active Directory from SQL Server 2005
- "SQL Server does not exist or access denied" & "Timeout expired"
- Loop Statement to compare two tables
- Can I manage MSDE with SSMS??
- "LIKE %" AND "@PARAM"
- MS SQL return Min count homeMDB
- Help on trigger - work for update but not inserted
- Full Text Search
- I need basics of innerjoins
- Help with SQL Statement
- If exists update, if it doesn't exist create
- How to make DLookUP function works..
- insert value into 2 columns,1 col. should take data from another table & 2nd random
- Divide Between Select Values
- Compare timestamps then delete
- t-sql cursor with loop problem
- Database Design
- Pass Table as a parameter to a function
- textimage_on error prevents transfer I havIaccess 2003 adp database
- cannot access the userinfo table for one on my content databases
- Error: The number of failing rows exceeded the maximum specified,Help !
- Joining tables with different data types on the common field
- MS Access to SQL Server 2005 Conversion
- Age calucation
- Searching table
- reduce the File Size less then Original Size in SQL 2000
- Sql
- Date Format Conversion
- how to retrive excel template stored in a table on SQL 2005 DB
- Exception from HRESULT: 0x8007000B
- Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space.
- SQL SELECT issue
- Limiting log growth during DTS Package
- Time in status from audit trail
- Conditional select in a view
- Conditional select in view
- how to get column name
- SQL Server 2000
- Domain policy to disable XP firewall causes SQL client slowdown
- Hello everyone, I am new to SQL server
- DTC fails to work with SQL Server after changing to cluster
- SQL Server 2005 Technical Articles
- SQL Server Equivalent of 'APPEND'
- Access is denied when executing xp_cmdshell delete
- Find Maximum Length of String
- MS SQL Server 2005 On Microsoft XP No DataBase Server
- A simple query that returns the most current address
- print report
- Interbase to ms sql
- Sub queries MSSql
- Getting records and output parameter from ASP
- How to Test Database Connectivity From a Workstation?
- Getting latest record from trigger
- Recruitment programming question?
- Scripting schema and data together - SQL Server
- Sorting Data in Database
- SQL Server Help required
- MSDE is slow on Restricted User account
- Urgent! Protect MDF and LDF files?
- Saving images into database table
- rename of logical file name
- Delete Records Which had some duplciate columns
- ERROR in xp_cmdshell syntax
- MS SQL Express Advanced vs MS SQL full version vs MySQL
- SQL Server Memory Keeps Growing
- SQL syntax for querying AD group membership
- Sql Server Management Studio Express
- contents of image fields
- Substitute Of Last() Of Ms Acces 2000 in Sql Server 2000
- Get one row from each group of rows
- SQL 2005 Query
- Oportunidade Stefanini It Solutions
- Oportunidade Stefanini It Solutions
- Delete Duplicate Records
- Please help me
- Calculate Time difference
- Updating one table from another
- brackets in TSQL script
- SQL Server 2005
- Problem with nested function call (UDFs)
- Dts
- Error with Select Statement using the SQLDataAdapter Wizard
- DOS Batch File Running osql - opening/closing connections
- What is different between SQL Funtion & SQL Stored Procedure?
- Using procedure results as table
- Data into XML
- SQL Server job history
- How to secure "Data" folder after installing MSDE
- How to assign primary key or forign key to existing tables
- i had a problem in inserting data in a table with foriegn key
- error 0: cannot load the dll, xpstar.dll
- Simplifying Relational Division
- sql2005 eval upgrade to retail version fails...
- How to Compare result of Query & Stored procedure
- substring matching
- Howto: Delete every second record if duplicates
- Ongoing purging of active records causes deadlocks
- hi i'm getting error when i execute the query
- Help with combining data from multiple rows into one column in a view
- Use decimal or varbinary data type?
- Need help retrieving a byte array from SQL 2000 and converting it to a string
- Concatenation problem: two integers and a char
- Problem in stored procedure in the last line plz help
- Default value being a concatenation of other columns
- DSN-less connection
- Need advise on horizontal table partitioning
- MS SQL Server Return 1 if exists?
- Import from MSSQL2000 (8) to 7?
- how to retun results from Stored Proc
- default value being a concatenation of other columns
- Fetch rows afftected in a table
- how to read the query in store procedure
- Convert ACCESS code to SQL Server
- Convert ACCESS code to SQL Server
- Plot Interval in SQL
- multi rows SELECT
- Sql Trigger For Timeout
- Updating SQL SERVER Database
- Updating SQL SERVER Database
- Dangers of select * into
- Visual Basic 6 to SQL Server 2000
- Error while Quering Qracle table from SQL 2000
- SQL script to update one field in table via batch file
- MSSQL Concate variable
- Updating a column one row at a time
- db_owners unable to see login list
- Date Function
- select a field declared as "money" and have the output decimal free
- How can I decrypt DTSRUN parameters
- How write this sentence with T-SQL
- Calculate daily averages based on Working Shifts
- sessions being killed by sa updating stats?
- c#, Query user's access to a database
- Connecting to SQL Server 2000 via VB6 program on Vista
- SQL Server on network
- Trying to import delimited file
- How do I see the result of calling a stored procedure in VB6 ?
- How To Implement sql server database on the client's computer?
- distinct
- Ms-sql
- count occurances in sql
- username function in sqlserver
- Trigger After Delete - I need a Trigger Before Delete
- How can i Tables, fields Hidings...
- Update a column in a table using the values in another table
- instance not initializing
- page footer report service
- Select record where foreign record does not exist.
- Date from datetime
- problem with login list
- Combining many records into 1
- Logical Name
- Query Analyzer debugger
- Getting last value and increasing it by one
- Query every entry not in each hour
- dts question, data pump task hangs when i try to edit it!
- How to Limit the number of rows returned with MSSQL, like the MySQL Limit clause.
- Trigger After Delete - I would need a Trigger Before Delete
- database information report
- Triggers in SQL 2005
- Master Database Restoration
- Firehose mode
- Please solve this query, and help me. :-)
- tempdb Size
- HCL hiring IT professionals -- Noida/Gurgaon/ Chennai
- Copy Records from two tables to new Table
- How to create a Role in Microsoft Analysis Server with AMO objects
- Encryption Certificate Expiry Date
- invalid column in report service
- PIVOT / Cross Tab to Populate DataGridView
- Same query - different execution plans??
- Search Value In Tables
- make the database unavailable while loading it
- Return a 0 for a non-join result count?
- NorthWind Database Practice Questions
- Any approach to write query for finding data inconsistencies from multiple tables
- No message print!
- DBCC commands
- Hai ,plz help me
- Calling a Stored Procedure from VB6 and using RDO
- Error Reporting service
- Informatica download
- how to giv login security using sql
- Query for making a monthly report
- Help with a query: returning rows from a coma delimited list of integers...
- Help Required regarding Creation of SQL 2005 Jobs and Exec them by using Non-SysAdmin
- Help dividing two values from different tables.
- How to conncet two PC's to share SQL server database using VB
- Give a hand(return value)
- I would like to simplify my query
- Inventory update problem
- [help] scripted database creation
- strange characters in data import
- SQl Svr 2000 - DTS - Multilingual Data handling
- access commands into Reprorting Services
- Data Table Column Order
- Backup Structure Only
- Regarding to MS SQL Processing speed
- SQL Server problems
- Effect of "Do not recompute statistics" option
- view vs stored procedure [ when and where to use view ]
- spliting string values in stored procedure
- How to create a series of tables with a variable name?
- SP kills a query when put in a parameter... help?
- How to select two rows within same column and display result as separate column
- VERY Complex stored procedure... I'm lost. Help?
- Stored Proc Optimization Help Needed
- Does a Full Backup include transaction logs
- Connect to sql server 2005 Standard thru internet
- Which one is bigger (takes more disk space) - a view (sql query) or a table?
- [ms sql] How to add new table to merge replication ?
- except command not working
- SQL Views - embedded view work-a-rounds
- Giving Value for Identity column while inserting
- Multiple rows inserations
- Report Service calculation
- Manager Hierarchy (Recursive)
- Can I reference the "active" database's system tables from a utility UDF?
- Query for Data redundancy
- SQL server sample database required
- mssql 2000 update from select
- Help with a quiry - update is whiping my existing data when it shouldent?
- Best Practice when copy table from srv to srv
- log shipping
- use file position (restore headeronly)
- raj
- hey pls answer my query
- top X scores for each user
- SQL Server
- sql server access denied or does not exist problem
- SQL Query
- SQL Date Between Query
- retreive a dropped table
- Summary View Using CASE is only returning first row?
- I need help in SQL table
- Get days
- Changes in Table
- Finding and Deleting Table
- SQL Query
- sql query
- sql query
- Help!!!
- Single Max Child Row (Based on a Count) for All Parent Rows
- Microsoft Jet Database Engine (dts Error)
- Are exclusive advertising deals a fair business practice?
- URL Hyperlinking issue
- Access to SQL Help
- Need help updating SQL server table via C#
- Automatically script out a table & indexes - script needed (2005)
- Argument list in EXISTS/NOT EXISTS Selects
- diffrence between MYSQL , SQLSERVER and SQL7
- how much space to allow for log files??
- xp_sendmail: failed with mail error 0x80040403
- Storing return type from a function
- Multiple table value insertion with single Stored procedure
- Easier way of building pivot tables in MS SQL Server
- Anti-joins
- insert query
- Database BackUp
- Sql Query to retrive Nth record?
- Copying table
- renaming of subfolders
- Begin Tran ...... Commit Tran
- Background operations
- Enterprise Manager - Permissions Question
- Help on Uninstalling SQL 2005
- insert into SQL using asp
- Database Design Question.?
- Define a Key - "select * from "
- Query analyser
- how to distribute a value base on table
- SQL Server 2005 - How do I import data from an Oracle Data Pump file?
- SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table
- XML versus SQL
- Msg 170, Level 15, State 1
- Identity Column Values.
- Accesss ADP
- How to increment a field for a Line Number?
- Database creation error
- Insert Data from Access into sql serve
- Execute Sql Statement Stored in Table Type Variable
- getting error "“Invalid object name 'SizeMst'. “ " while exec sp
- Problem with locking in Selects
- Tables updated even though there is an error 80040e14
- Import/Export wizard DateTime problem
- Image colum type conversion retuns blank value on second server
- Help writing an If else statement
- T-SQL Challenging Product
- Selected DropDownList value to @ID Help! (C#, SQL)
- TOP N in Reporting Services
- SQL Server Error
- Need to find 'yesterday'
- Sql server stopped
- Learn Oracle Database Administration in 10 Minutes
- Primary Key finding
- How to reduce the table
- Numeric Format Using Sql Server 2000 Query
- Connect using different Windows user name...?!?!
- Return the last row only
- Backup Database
- Cannot connect to SQL instance without port information
- Converting continuous replication to hourly?
- SSMS - getting timeout terminated even with Execution time-out of 0?
- Store Procedure Insert in "X" rows
- large inserts
- Using Join or Using View
- Error converting data type varchar to numeric.
- Dynamic value on Tool tip
- SET STRING_RTRUNCATION ON in Sybase
- Sorted Views in SQL server 2005
- AddLink Server feature in SQL SERVER EXPRESS edition
- Users with permission to MSSQL 2005 objects
- How to store the data in the field is KBS or MBS as length
- Cannot connect to database using Enterprise Manager
- Transfer DTS Package
- Export table row to XML file using a stored procedure
- MS SQL getDate() Function remove Time
- Find website from email address
- Simple SQL help needed…
- sql
- restoration automation
- SQL Query
- Reports based on queries
- Powerbuilder Connection in MSSQL 2K Desktop Engine
- group by in sql report service
- How can I combine different rows?
- vb.net CSV import into sql express 2005
- MSSQL Returning Blank Results
- SQL Server BCP and identity rows
- SSIS automation
- List of users and user rights
- Finding Difference In Strings
- I Have this Complex Stored Procedural
- pwdcompare equivalent in Sql2005
- Identify Dulicates/Compare data in table to itself
- How to update 2 columns at the same time
- [SQL Server 2005] T-SQL for configuring replication
- Insertion automatically truncates the value
- OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005
- Need Query help please...
- Dynamic Query
- No mapping between account name and security ID
- Merge data in SQL Server 2000
- Copy one column to another
- Inserting values Using Stored Procedure
- table page allocation
- Connecting to SQL Server 2000 Via Internet
- Resource to learn code and share code and knowledge
- If Statement
- Birt201
- Quiz help required
- Best program for SQL database manipulation
- sql server
- different datatypes avaliable in SQL 2005
- Need Scheduling Support for Your Databases?
- how do I return a default record if result set is empty
- year month date format?
- mssql from linux
- Combining Values
- Update date field
- Mass Update on Table with Trigger
- Sending formated Email with database mail sql 2005
- Connecting to SQL 2005 using VB6
- Mismatch between Count(*) and Properties -> Rows
- How can i merge three table?
- SQL Hierarchy and Sum on Same Table
- SQL Query - Explain please
- how to find median in sybase /sql server (Using query)
- How to fetch primary key after an insert command? (MS SQL 2005 Express)
- How to write QA test Script
- Scope in derived tables
- Output Column names in each Row along with the row Value
- Problems getting return codes from xp_cmdshell
- my Log file size is 10GB....
- what is back end
- Count Parameter not right
- DTS Package user permission
- How do we know the change history of Stored Procedure
- How to make the DTS package fail, when the source table is empty
- Is Not Null and Query Optimization
- delete rows by checking conditions in more than one column
- Finding total and Concurrent number of users logged in
- how to stop the query
- Stored Procedure Help
- DELETE where syntax ... need help :)
- Incorrect syntax with Declare
- find the size of data base
- Performance between Standard Join and Inner Join
- SELECT QUESTION
- Can I install SQL SERVER 2005 on secondary drive?
- find a primary key
- How to make a SQL run longer?
- the best way to implement batch job
- This is a tough one. Help....
- mass alter table fields - script help
- Parse field into multiple rows
- Select rows containing users from same usergroups as current user
- sql Cannot resolve collation conflict equals - comparing rows and fileds between Table1 and View1
- SPROC: How To Change a Value From Positive to Negative??
- Using Pivot
- Copying large amount of data form MS Excel to MS Sql Server
- delete the databse
- Help with Dynamic SQL
- Stored Procedure definition not updating, causing DTS copy error
- How to find the maximum possible value of a given datatype
- Select Using field data length
- Concat tables into one row in view
- Help with Nested loops in SQL Server 2000-Transact SQL
- Permissions and Users in SQL Server 2005
- could this be done in SQL???
- stored procedure squery
- Strange performance issue with UPDATE FROM
- select alias -- invalid column name
- rman backup in sql server
- SQL order by only for non empty fields
- Sql Server Reporting service
- sql profiler trace file
- how to get the sum of the fields ...Very URGENT
- INSERT - EXEC never returns
- How do I convert Dates stored as int
- Finding a column in all tables within the DB
- Break in sequence
- Executing A File In Sql Query Analyzer
- compare 2 values in same solumn
- Subselect Query taking a long time in SQL Server 7.0
- Navicat ERROR: Cannot connect to MySQL server on localhost
- Trigger Deadlock
- sql server database tuning
- MS SQL Parelleism
- problem with highscore
- Parallel build and subsequent re-name of a cube
- Can any body help me for creating user datatype
- Security with SSAS 2005
- SQL 2000 date format problem after migration W2k to W2k3
- Tracing error
- Log Shipping does not Ship to Secondary database
- how to reconcile two tables using cursor.
- Dynamically input columns feilds in a select stmt
- Database design question - Isolated, unrelated tables
- MSSQL datadump
- date search in SQL
- triggers
- DB hostname, username, password etc
- Table alias in nested query
- Insert into two tables using transaction
- transpose columns
- Trouble with homework
- how To Create Auto Generated Unique Identity Code in a SQL Table
- error 126
- Foreign Key
- Sqlserver 2005 restore database
- BULK INSERT ignores UNIQUE index with IGNORE_DUP_KEY set?
- correct syntax for this select in SQL Server?
- count() and sum() on multiple tables
- Unable to connect to SQL Server Express Locally or Remotely
- Looking for code libraries for aggregate functions
- SQL Server Log
- BULK INSERT not loading all rows from a text file.