View Full Version : answers
- Backup to a remote server
- how to use Regular Expressions
- Export
- User initializes variable through VB in a DTS package? Is it possible?
- Isolation levels??
- SUM of rows, when selection returns no rows
- Comparing the previous record
- Bcp
- Column Name
- Stored Procedure
- sql server stored procedure
- SQL Delete
- sql search query
- sql search query
- ERROR 1045 (28000): Access denied
- Storing a C# data of data type timestamp into sql server table and then perform SUM
- Calling A Crystal Report From Vb6 And Sql Server As Back End
- SqlCommand TimeOut
- downgrade dbase 7 to dbase 4 using command line
- Best match query and order by columns
- data type datetime ??
- Need Help in data Merging.
- Count child nodes in tree like data table, SQL Server 2005
- stored procedures question
- How to Eliminate NULL values from the SQL queries
- Limiting integers
- SQL SERVER Reports and multiple selects
- SQL Operation Performance Advice
- DATETIME - Time only needed
- Database Report Writer
- Regarding Date DataType
- Add A Constraint To An Existing Table
- Simple Query
- Regex in Stored Procedure Problem
- Dropdownlist
- Sql
- MSQL UPDATE table
- Nocheck Constraint
- SQL Server Stored Procedure
- Password format
- Cast an entire field from VARCHAR to FLOAT
- how to release table variables
- SSIS and HEX conversion.
- Constraint Triggers
- Creating multiple stored procedures at once
- SELECT and compare last two cost entries
- ssrs
- Database
- Sql
- SQL query calculation
- COMMIT & ROLLBACK
- select column names from table
- grid
- Performance based on design
- Create triggers
- if then else in stored procedure
- date/time in page layout - SSRS layout
- split color values into multiple records in sql server 2005
- mod operator
- xml datatype in sql serevr??
- @@rowcount
- Variable initialized by user each time DTS runs?
- What is @@SPID??
- Restoring MSSQL 2005 bak file to another instance
- Change Recovery Mode from Full to Simple
- Export Excel to SQL 2005 table
- SQL Server Express 2005 9.0.1399 Installer?
- % WildCard
- CASE stmt with isnull()
- problems with cursors
- SCOPE_IDENTITY issue
- I have a Problem With Stored proc_ help needed
- Cases in Select, Where, and OrderBy Dynamic Clause
- Problem with Query
- SQL Database design :- varchar datatype doubt
- Mismatch Records field need display Null
- Please Help In designing the Reports USing SSRS
- Trigger problem
- How do I add a folder to a ssmssln solution in MS SQL Server 2005?
- Add a list stored in a text file to a SQL Server 2005 database
- How to use WHERE IN syntax conditionally
- Insert into a table only if count is less than 'n'
- How can i have a copy of entire databse with out data??
- DateFormat
- Connect DTS with VB6
- SQL Server 2005 with SQL Server 2000 support
- How to retrieve the database which is deleted??
- how to use top 1
- Conversion failed when converting from a character string to uniqueidentifier
- max count
- Find the 3th,4th ,5th........... largest salary
- How can i change the column name?
- Beginning and Ending DATE of a Quarter
- Reinstall SQL Server 2005 Express Help
- Appending strings in query to create table name?
- Your upgrade is blocked because the existing component is a later version...
- Sub Query and join Difference
- Mapping values in one table column to another table column
- Can we use two orderBy in single Select statement ?
- Auto Generate Value
- My ASP application is not working when i moved from sql server 2000 to 2005
- how to query this?
- capturing object not found in SP
- Generating SSRS-2005 REPORTS with XML Data in C#..
- SQL Addition Problem
- Regular expression in SQL Server
- DTS Package SQL Server 2000
- Simple Query
- Joining two values together across multiple tables
- SSRS error
- multi-statement table valued UDF
- problem with union
- Apostrophe
- Concatenate two tables
- Retrieving Data Problem in sql
- Different types of joins
- Newbie select question (Just select first record)
- Diff B/w Stored Procedures & Functions
- SELECT @error_message vs SET @error_message
- split a string
- SQL Architecture
- Delete Duplicate Columns
- cannot insert duplicate key row in object 'Table' with unique index 'Index'
- Foreign Key on a table with no primary key
- MSSQL Time Diff?
- SSIS - convert dbf to sql server
- Counting rows part II
- how to rectify this error
- How to add a new field into already created Clustered Index?
- delete top (n) excluding the first row from table with no primary key
- Sql Error Message
- Connecting SQL 2000 to DB2
- I guess this is a relatively simple SELECT order by question
- Selecting From Multiple Time Periods
- Retrieve distinct records on the basis of other columns
- Stored Proc help
- Ssis Package For Moving/renaming File
- The multi-part identifier "..." could not be bound
- Information_schema.columns
- Add coloumns dynamically in a table
- How to GET DATA from Microsoft EXCEL Sheets for Generating REPORTS in SSRS 2005..
- Database Object/s disappeard after attaching the database to different machine
- Need help in get the result in the format
- To pull all emails from the domain-aol.com
- Matrix Table Layout Question
- resetting Identity column values
- Number of open connections
- To pull all emails that contains +,^,*,&,!
- How to Get Data From Log Files for Generating REPORTS in SSRS 2005..
- SQL Table
- Constipated publisher (SQL 2005)
- If Condition in SQL to search
- PHP/MS SQL - automatic formatting: varchar, datetime
- xSQL Profiler - monitor multiple SQL Servers from one centrallocation
- Retrieve Columns By joining Four Tables
- RDLC - Report Layout Issue
- SQL Query
- Pivot in SQL
- how to align concatinated column in sql
- Limit rows returned
- Cursor in Triggers ? ... What's best practice
- Query not getting all data
- Deleteing the duplicate Records
- Stored Proc not working in DTS
- How do I make a backup device file smaller ?
- Problems in CALCULATING PERCENTAGE in SSRS 2005 Reports..
- Database diagrams disappeared after attaching the database on different machine
- Where to write SQL query
- Trying to get data by distinct field values
- Scalar Function
- Replacing Columns within a Table
- Result Set In A Range Of Numbers
- Navigate a DataTable
- Delete Query
- SQL Query
- Stored Procedure Problem
- Database Creating
- SQL 2005: Renamed 'sa' account
- Deadlock issue... (not the average deadlock)
- PerformancePoint Server 2007
- SQL Server authentication
- Client side insert update
- Problem in implementing mirroring
- Counting rows
- help,a regular text file how to sql 2000 table code ?
- Sql Server database creation Problem
- Help finding 'pairs' of rows
- reference column name
- Code Listed: select max value in row that is less than my variable
- sql server (evaluation ver) expires daily
- SQL Server 2005 native client ODBC query
- Adding an autonumber that resets every month
- Report issue
- SQL Update with join
- 'Failed to enable constraints' Error on TableAdapter.Fill
- Returning one field multiple times with different values
- Problem Connecting .NET app to SQL Server
- Types of Functions
- sqlserver datetime
- Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn
- SQL Table
- CheckPoint
- how to send mail using sqlserver
- Convert String to DateTime
- Inserting data from one MSSQL DB to a different MSSQL DB
- An optimum query..?
- boot camp
- Getting a total of a number of group by results
- getting tables that link to a table
- Restore DB without log file
- [IAT ELEZIONI] Presentazione candidati
- Simple Concatenation Question
- Display a roll having MINUMUM MARKS IN TWO SUBJECTS?
- Dynamic SQL generation
- ROLLBACK ALTER column statement
- List Columns in a Table in SQL 2005
- Join
- Saving two different records having different number of columns in one table.
- SQL Assistance required
- need same order as the IN list of ids ...
- Improving Select Query
- Error History?
- Deleting multiple columns from multiple objects
- OSQL -D parameter
- SQLServer 2005 integration services project
- from 'image' to 'varbinary(max)'
- partial indexing in sql server
- Data manipulation problem
- Dataset
- Schedule the Jobs in Sql Server 2005
- Is it possible to define sql parameter as INOUT
- What does it mean to SET a value?
- where to find the database?
- database truncation
- About Deleted Table
- Automatic creation of DB fields.
- passing textbox value to gridview using C#.net at runtime not using database
- Copying XLS (local) directly to SQL (remote) Table without Link srver and BCP
- Complex Calculation
- Stopping job if running after 7 a.m.
- difference between explicit inner join and implicit
- Foreach in MSSQL 2005
- delete output into <xml column of audit table>
- testing if value is null
- Varbinary(max)
- Deadlock problem
- Read table's next row
- How to type&pass variable from Excel SQLCMD to Stored Procedure
- operation must use an updatable query
- Application.StartupPath
- Internal query processor error
- Need to insert the dates between the start date and end date
- Diff B/w Windows & SQL Server Authentication
- sql server 2005- reporting - pagesetup
- Retrieve data from Three table using JOIN
- String(Varchar) ID Generator
- Finding SQL Server Event IDs
- DTS to .exe! HOW?
- Server: Msg 9002
- SQL Query IDENTITY Row Reset Help
- To create store procedure
- views on table having field text
- SSRS Reporting - Printing page set up problem
- getdate function help
- Violation of primary key
- CASE WHEN Equivalent in WHERE Clause?
- Uninstall SQL 2000 Workstation Components
- Scalar Subquery in MS-SQL Server 2000
- Scalar Query in SQL Server 2000 like in oracle
- A single query between two tables without link on its fields
- Problem Using Sum with Join
- SQL 2005 Express - problem with no "SQL Serevr Agent"
- tempdb space issue
- SSIS security
- cant connect to phpMyAdmin....
- Cant get sql statement to work in mysql 5
- DTS Copy File Issue
- DYNAMICALLY Generating Reports in SSRS 2005
- converting SQLTable to Excel Sheet
- Help needed for Update Query
- Data conversion
- sql query
- dbrpcparam datalen problem
- ADO vs ADO.net
- SQLServer - VC++
- How toTranspose a row values in to column values
- combining the results of two selects...
- DLL -> Database
- Unable to disconnect?
- Non-clustered, Non-unique index performance
- Navision data extract
- Cross / Outer Apply
- update record with data from another record in same table
- price field
- date formatting
- Redirect the output to a variable
- Trigger -help
- SQL Server 2005 : Piecemeal restore with fulltext index
- Selecting rows representing highest value for columname1 for each columname2
- SQL Server
- identity table
- help with DDL trigger. Moved from other newsgroup.
- UTF-8 Coding of MSSQL 2005 DB
- mmc cannot open the selected file(SQL SERVER 2005)
- Subquery returned more than 1 value. This is not permitted when the subquery...
- how to calculate rank in selected records in sql server 2000
- missing values of a sequence
- Creating an alert for a deleted row
- SQL Server - synchronizing database changes across servers
- Rounding not working
- How to connect to mainframe through Integration Service
- Getting record position in sql server 2000
- Deleting Tables
- whats the dataytype we should use to store multimedia file
- Change order of column in SQL 2005
- call script from another script
- nub question :(
- join tables with max record
- Triggers and Flag bit
- Space Delimiter in a flat file
- IO Completion Listener
- Error Message
- Create Table Conditional
- Selecting alphanumeric combinations that do not exist already intable?????
- Between & Dates
- Doing Summation on multiple criterias on the same column in a singlequery
- Stored Datapaths in SQL using C#
- Salray for SQL DBA (4 years exp) in UAE
- Identifying Error Line in a Stored Proc
- Table Schema
- Truncating the data for TEXT fields in select query.
- Data Type
- Table Schema
- Restoring Bakup File in sql2005
- Connection To Sql2005
- Case statements in MS SQL
- Data Shifting Between Records
- about number of columns in a table
- covert data from one table to another
- saving stored procedures in sql server 2005
- datetime field in SQL Server 2005
- Indexing in sql server 2005
- XP_cmdshell not working
- MSSQL View SQL from GUI
- What are my TRIGGER options?
- db mail questtion: How can I clean up the format
- DB Maintenance Plan Append Vs Overwrite
- got the error:provider: Named Pipes Provider, error: 40 - Could not open a connection
- insert querry doubt
- Duplicate key ignored AND statement terminated
- SQL Server 2005 ODBC Logging Problems
- Moving SQL 2000 to a new machine by copy-paste !!
- Probs in DateTime query
- SQL 2005 Workgroup Edition - how to run a trace
- SQL2005 performance problem
- Maitenance Procedures
- Newbie to T-SQL (and can't get my if..else to work in WHERE clause)
- Selecting all from Super-Types and Sub-Types
- While Loop
- Inserting nothing takes a long time
- how to export sql server-2005 table data into excel sheet
- Minimum values
- auto run
- Problem getting information form system tables
- traverse and finding dates
- Problem with table creation & query
- Your resume is shortlisted - apply immediately | More than 85 TOPcompanies recruiting this week
- Does Sql Server Enterprise Edition work on XP Machine?
- smalldatetime convert problem
- Help with the WHILE Statement
- Can users be connected during a SQL backup?
- job died but why?
- Lost SA password
- SQL Server OleDB Provider alternative
- What privilege is needed to run DTSRUN ?
- using fn_trace_gettable on trace files where the path contains aspace.
- mssql syntax error in stored proc
- Two timestamp datatypes in single table of SQL server2005
- Assertion
- Deleting a similar record
- JDBC Properties setting for ANSI
- Question
- To Create New User
- Probs In Query
- Informix SQL to SQL 2005
- Data Replication
- Osql error trapping
- Trigger to modify a table
- PatIndex function
- Dts
- JOIN from 2 Tables and combine several records into 1 record
- Stored Procedure Problem
- To connect to SQLServer 2005 database of a pc which is in domain from a pc in workgrp
- Retrieving data that matches a list
- Allow Guest account in Windows XP professional to use sql server
- Do not want to display record with same ID
- Selecting distinct values from joined table
- SQL Server 2000 Mail
- Updating selected options Logic
- 'nt Authority\anonymous Logon'
- URGENTT: Login failed for user '(null)'
- Functions
- Data from one table to populate a VB TreeView
- database connection for struts using sql server2005
- Porting Legacy Data to a PK
- Identifying which WINWORD process to proc.kill()
- Car-Sharing Offered - ICC Birmingham MS UK Product Launch, 19th March
- Bigint from a SQL Server table and viewing with Access
- query to text file
- Help with joining 2 tables
- Year to Month Sum
- calling stored procedure
- Dropdownlist NULL
- probleum in registering sql server7.0
- Where is SQL Server Enterprise Manager?
- DISTINCT is for a WHOLE rowset. How can I take out only ONE distinct column?
- About row size or length in mb or kb of a table
- Interview question
- Interview question
- Cascade Constraint
- Table Relationship Query
- MS SQL SERVER DBA/ CONTRACT/ IN
- Select from Stored Procedure
- Sum and Count in a Query
- Sql Server 2000: How To Handle Null In Select Statement
- How do you apply PK filters to FK tables?
- How to decrypt
- probleum in triggers
- Need Help, RaiseError, Check Constraint or Rules
- Sum up total hours for mutiple day entries
- Need help with creating a query to run in enterprise manager
- Info about system tables?
- Searching for Timestamp Datatype: New to MSSQL
- Triggers
- Creating an ODBC linked server in SQL2005
- How to implement Unicode SMS, multipart SMS and high capacity sending
- Hi every one
- SQL Query Help
- mssql statment in visual basi c2005 experess edition
- Total row count from two different tables.
- Select every Nth row from a table
- help - extracting metadata
- Date Calculation Previous Years
- query to get number of columns in table
- SQL Query Problem
- Accessing Free-Text Noise Words File from SQL Server Clients
- IF condition in Stored Procedures
- What is encrytion and decryption
- count the no of emp under GPM list that emp with mgrid
- Finding SQL Licensing information?
- users connections
- SQL Servers equivilient for Oracles Lead and Lag
- Question about Update Statement - WHERE EXISTS
- osql
- Function - missing parentheses
- DateTime Automatic Formatting
- Table records will not appear...if
- help with sql server select statement
- Result Row
- Connecting to an SQLServer
- Urgent how to find set nocount is on or off in stored procedures
- Name value pair
- MS SQL question
- I want help with error message I get when I access remote DB
- SQL Select Statement Syntax
- How to Open Or read SQL Server log file .ldf
- MS SQL Trigger to update changes in a record
- How the data can be from .LDF file rather than .MDF file ?
- Moving Records from one table to another that meet a date between critiria
- function to extract delimited data
- ssis Bulk insert failed "Received an invalid column length from thebcp client...".
- help in sql query plaese. . .
- Ssrs + Iis
- MSSQL Full text search question
- Generating Reports from Two Different Databases in SSRS-2005
- MSSQL DISTINCT multiple fields throws up odd results
- Creating custom Primary Key in SQL Server 2005
- sql server installation problem
- Query only returns one value
- Problem Inserting Unique Rows into a Table
- converting nvarchar to int
- pictures in a database
- Email
- Select all the distinct rows with a condition.
- like function on a column
- At most one record can be returned by this subquery
- copying data WITHOUT DTS
- Comparing "Sets" of int`s in SQL Server 2005
- Formatting a Number
- Converting Rows into Columns
- xquery - dynamic field name
- Sub Query retrun many records
- Sequences in MS Server
- create trigger for insert (SQL Server)
- How to remove all data from a relational database
- Urgent : How to register an SPN for MS SQL EXPRESS 2005
- Basic Question About Sql
- Migration from PostgreSQL
- Top companies recruiting this weekend - Apply with updated resume
- Doing a bulk insert into SQL
- Combining two row values of a same column into one
- null data
- Question about foreign key replication
- Table design question.
- Joins Question
- Single Quote In Variable
- Exam 70-229 :Designing and Implementing Databases with Microsoft SQLServer 2000 Enterprise Edition
- SQL Server Tutorial
- Regarding DTS Package Execute SQL Task
- adding constraint
- How to decode in SQL Server 2005
- comparing two tables to look for mismatches and a way to edit the table value
- INSERT, UPDATE clause inside UDF
- is case sensitive & normalization
- SQL compact edition 3.5 insert multiple rows
- intersect & except
- How can I format a datetime as 'yyyymmddhhnnss'?
- Dynamic Union of Tables
- How to group by date irrespective of time
- Copying a table with different column names
- Need CASE Statement(s) to populate 5 fields based on values of 2
- SQL Server 2005 Licensing concern.
- Problems with select statement
- Lost Full Text catalog that won't delete!
- how to use SQL in place of Adodc
- How to join two tables where one table keeps rows on a separate row
- SQL UNION with Replace in the ORDER BY clause
- Drop Primary keys
- Set Variable From Query Results
- History Tables: Always Subtables?
- [basic]union-join questions
- Removing 1 hour from text field
- Get long date info
- how to drop a temporary table
- Count Subquery
- Auto Primary Keys in View
- How to check execution logs
- Working with Reports in SSRS-2005
- About Sys.sql_dependencies in sql2000
- Linking error
- Can someone help me get started on administering MSSQL?
- Trying to create a Update query to update data from one table to another
- multiple inserts
- Distinct values
- Accessing temporary table from stored procedure
- sql-group by week
- Field Expressions in SSRS-2005 Reports
- How do I Converting DBF database files to SQL Server 2005 in one step
- How can I use variables in this TSQL Statement
- Calculations between two different rows same Table