TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
32201: eliminate the Return charactor in a column
32202: Pass XML between SPROCs possible in SQL 2000? 2005?
32203: Stored procedure refer to another Stored Procedure ?
32204: Increment variable by each row in set
32205: The char '
32206: Reporting Services 2000 does not deliver attach documents by e-mail.
32207: truncate table
32208: import a text file into the database
32209: BULK INSERT
32210: Avoiding Temporary Tables
32211: between dates and times
32212: alter view question
32213: Query Designer???
32214: Help on Sybase Power Designeer
32215: Using Indexes for DATETIME datatype
32216: Query on XML column: fn:lower-case not working?
32217: Can't get MAX DISTINCT to work the way I want it to
32218: CASE and INSERT statements
32219: ALTER DATABASE dynamic SQL
32220: Sql Parse errors
32221: Conditional Where clause
32222: BUILTIN/ADMINISTRATORS
32223: Select query using SQL Helper functions
32224: Multi-Select in Query --- Possible?
32225: Joings between two table variables
32226: sp_who - sp_who2
32227: Index on Views ...
32228: Splitting a table (to speed things up)
32229: UPDATE using JOIN?
32230: IN clause bug
32231: Index Ratification
32232: Saving and Retrieving Binary Files in MSSQL 2005
32233: Querying an attributes table
32234: sql syntax string to execute
32235: explicit transaction in sql server 2000
32236: Dynamic SQL Problem
32237: Anyone Using 2005?
32238: Generating update statements
32239: User Privilege problem to Execute SQL Job from query
32240: How can I make SQL Server automatic generate scheme script for backup everyday?
32241: Function to return substring letters only
32242: osgl syntax problem
32243: import data properly from csv file.
32244: Table normalization to remove redundant data - Performance problem
32245: Error creating object SQL 7.0 using sp_oaCreate
32246: Force a round() when it's below a 5?
32247: Syntax to Restore a database renaming the original files
32248: index question
32249: Access - SQL 2005
32250: sql server alerts and sql server jobs
32251: SQL Search Query needed
32252: Assigning query output to a variable
32253: Sql 2005 maintaining Hierarchy problem
32254: Database locking issue
32255: help on select query
32256: Year comparison
32257: How do I handle time-zones?
32258: Formatting number in sql
32259: CLR Integration with Complex Types
32260: SQL Server command simular to Oracle's 'DESC'
32261: client deduping
32262: Join based on MIN DATEDIFF?
32263: Read data Page without using DBCC Page
32264: returning counts of all values in joined tables
32265: Getting the value of xp_cmdshell
32266: service manager equivalent in YUkon
32267: Force a round() when it's below a 5?
32268: ForignKeys and index
32269: Simple Erntr - Invalid Object
32270: code information for unused indexes in sql server
32271: which is most efficient? variables vs. nested select
32272: SQL Server Agent JOB failed while Query anlayzer success
32273: Problem With Case Function
32274: deploying CLR objects best practice
32275: Auto Commit
32276: Create Duplicate of table ?
32277: distinct query
32278: Number of lines of code in a SP
32279: How to pull query data from two databases?
32280: Query Result in Cache?
32281: Advice on Simple Structured Sql Query (Search)
32282: help Simple question
32283: [OT] User-Defined string Functions Transact-SQL
32284: Transactional Modification
32285: Transactional Modification
32286: @@ERROR per connection?
32287: Understand N'___'
32288: sp_send_cdosysmail with priority
32289: case statement TSQL
32290: joining 2 tables onto one
32291: Restore - Change Logical Name
32292: what is the best way to update data
32293: dumb sql mistake or SQL Server error?
32294: SSIS Packages
32295: How to refer to calculated field ?
32296: duplicate column data
32297: returning counts of different fields when only one has criteria
32298: Configuring SQL Mail
32299: question about dealing with deadlocks
32300: Multiple Step Stored Procedure
32301: size of the resultset
32302: from clause
32303: Relationship map using CTEs
32304: BCP copies only Integer data
32305: SQL Query help.
32306: Accessing Second Record Within Query
32307: maximum column_name length
32308: Loading 150k AD user objects into SQL2005
32309: CC and SSN encryption
32310: Getting the physical directory that the log file is located
32311: selecting from DBCC SHOWCONTIG
32312: Variable not passing parameters
32313: Need replacement for sybase list aggregate
32314: Is this an efficient way to return a comma string
32315: Filling in date records
32316: error processing
32317: Excel file import problem
32318: xp_smtp_sendmail weird behavior
32319: Passing Cursor as SP output parameter
32320: SQL Monitoring Tool
32321: multilingual asp.net calendar control
32322: Help on the last updated date
32323: FOR XML return as a Scalar
32324: BCP
32325: Debugging CLR Objects
32326: Are these two statements equivalent?
32327: Querying information_schema for check constraints
32328: Insert maximum integer value if it is exceeded
32329: Order By ignored in query participating in Union All
32330: Restore Database
32331: Call Stored Procedure within a SELECT statement
32332: SQL 2K, logging procedures execution
32333: How do you force the server to store only the text entered
32334: Determine Table's PK Columns
32335: SP to write to a Formatted Flat File
32336: Function to seperate comma delimited db field into new table
32337: suser_name()
32338: xp_cmdshell
32339: searching large fields
32340: speed Up
32341: Speed Up
32342: On delete cascade
32343: Query behaviour - (subquery results)
32344: I bet this is simple, -But see if you can help. Hard to come up with Title -Have a look
32345: Enable/Disable Triggers?
32346: adding column vlaues with one another
32347: Insert into (leaving certain) fields out
32348: Joining multiple tables in a view.
32349: INSERT - dynamically specifying DEFAULT for a column
32350: Problem with order by clause
32351: Visual Basic + SQLServer + CommandTimeout
32352: Update null records
32353: Use of AVG function to update records
32354: Newbie sqlserver question...
32355: how to save a rtf file into a field
32356: Run Dll In Stored Procedure
32357: dynamic sql string too long
32358: Trigger needs to join multiple tables to validate entry in table.
32359: Table Owners
32360: views based on parameter view
32361: How to protect data in table?
32362: Query Analyzer..
32363: Select a specific range of results
32364: Can truncate but not delete
32365: convert a datetime
32366: SP and Triggers: object permissions
32367: Help with SQL Function
32368: Any performance issues if we use BigInt
32369: queries filling up logfile
32370: Administrative Tasks
32371: Help..........
32372: unaccountable result for select
32373: SP clause - where (field = @Param or @param is null) is this fast?
32374: order of columns in composite index
32375: Delete invalid Details
32376: Delete Duplicate Record
32377: Recover the data
32378: SQL Server and Time Zome
32379: Free MCAD/MCSD ebooks online
32380: Find SQL solutions with free eBooks. Search the ebooks NOW.
32381: how to store a record before deleting it using triggers
32382: explanation needed - DECLARE CURSOR
32383: Hello, is there any intelligent life at M$?
32384: Excel file import to Sql Server problem
32385: Formatting numbers
32386: weekday or Weekend
32387: SQL Server index low cardinality columns
32388: Differences between DISTINCT and GROUP BY?
32389: running stored procedures from SQL Agent
32390: The weirdest SQL problem you'll ever see.
32391: Ole object to illustrate the Enterprise manager VIEW designer in a WORD document
32392: need output where same column has more than one pirce of data
32393: Transfer Table Relationships
32394: CopyFile in DTS ActiveX Script Task
32395: query help - "Most Helpful Review" idea
32396: SQL Agent Mess
32397: Endian problems with converting to varbinary
32398: IDENTITY and Backup/Restore
32399: Help developing this project.
32400: Finding the 2005 migration quite challenging
32401: Merging tables
32402: CLR Question (BASIC)
32403: Connection Problem with Remote Server
32404: Inserting dummy lines and padding
32405: Newbie: Timeout On IN statement
32406: How to get rowid of uncommitted record
32407: Size of a row
32408: DEADLOCKS
32409: global temporary tables
32410: ReCompileReferences using System SP?
32411: Determining Roles from Windows Authenticated Login
32412: Help with value
32413: Connection string for 1 server and 2 databases
32414: compatible ntwdblib.lib FOR ntwlib.dll in SQL Server 2000 SP4
32415: WHERE clause 'SET'
32416: Design: bit on or off?
32417: SQL Query Help
32418: I was wondering if....
32419: attach db with a deleted log
32420: Database files (VS 2005) - usage?
32421: Getting an unused number from a set of numbers?
32422: Design: multiple columns for primary key
32423: EXISTS with EXEC
32424: one column causing duplicate rows - wrong join used?
32425: SQL Execution Error: Cannot call methods on int
32426: Looping Query
32427: Date from datetime ...
32428: Status control of SQL Server Agent jobs
32429: CREATE VIEW w/ UNION
32430: Login Failure with Linked Server
32431: Syntax error converting datetime from character string.
32432: char vs. varchar
32433: Same process ID, multiple times
32434: Whats Wrong with the Query?
32435: CHARINDEX is not working
32436: Automated Table Updates - Strategy Assistance Requested
32437: multiple databases for multiple days
32438: TSQL Debugger Oddity
32439: Combining archive tables into a single table
32440: random numbers of param
32441: DTS Connection Properties
32442: still problem with image
32443: Subscription error: The report is using user defined parameter va
32444: Sql Query
32445: SELECT question - need help
32446: MS SQL 2000 Query Help
32447: sysdtssteplog not updated
32448: Newbie:UNION with SELECT TOP
32449: SQL query help
32450: Scripting foreign key relationship on a table
32451: historical lookup query
32452: Calculation in sql
32453: Help With Stored Procedure!
32454: Setting the database to"'use" dynamically...
32455: Simple select
32456: Preparing db for update of 200K records...
32457: Date Logic for a DTS package
32458: return a Scalar value...
32459: Append / Insert Into Question
32460: Update query
32461: Update questions
32462: Update a SQL table from an Access table?
32463: truncate table thru a link server
32464: Merge Replication
32465: Script to delete all objects
32466: Is it not possible to use UPDATE within a function?
32467: Criteria = Most Recent Date?
32468: store image
32469: SQL Server 2005 Standard Edition question
32470: Small Storage Solution For SQL Server
32471: sqldmo and SQLExpress ??
32472: DB design question.
32473: DTS to Access mdb - updates only
32474: SQL Server 7 and SQL Server 2000 SQL QUERY
32475: How to detect sql servers on the net
32476: SQL Server 2005 & Sharepoint Poral Server 2003.
32477: Dynamic SQL - Temp Tables
32478: How to delete Duplicate records from table
32479: Problems with a SP with a Temporary Table in .NET
32480: Building View Dynamically .. Need Help!
32481: Update Query Returns -1 Represents ?
32482: Updating a view ... (SQL Sever 2000)
32483: Using Replication
32484: XP_CMDSHELL
32485: Configuring SQL Server Express 2005 for Remote Access
32486: Help with strings
32487: Stored Proc
32488: SELECT statement question (LEFT JOIN)
32489: Query on SQL Server 2005
32490: how to update identity values
32491: help needed in writing a recursive function
32492: Multi Record Insert
32493: normalizing data warehouse
32494: Script for inserting incremental unique values ?
32495: Accessing output parameter in Stored Proc. using OBDC API...
32496: Sub Query faster than inner Join?
32497: server side cursor created by jdbc
32498: Can not update remote table???
32499: cancel update if no column has changed
32500: Scheduling A Stored Procedure?
32501: Trap error on Full text catalog search
32502: Creating a User Defined Aggregate Function
32503: Using SQL Server 2005 - SQL Native Client as DSN throws up error while inserting values into temporary tables in the application
32504: SQL Native Client as DSN not able to access temporary tables...
32505: Whats the wrong with this Query?
32506: Fast insert
32507: Combining Columns of Same Name
32508: temp table cannot be found
32509: Remove Duplication
32510: Script that Return the number of Rows for each Table on a DB
32511: Programatically running the SQL Server Agent
32512: RDA push method and triggers
32513: RDA push method and triggers
32514: xml update syntax
32515: subquery returning more than 1 value
32516: Replacing Nulls
32517: Finding Consecutive Values
32518: Privilege issue on SQL Server 2005 Temporary Tables
32519: Types of parameters
32520: Adding a DTS package
32521: Sql server 2000 - copying a diagram - How
32522: CHAOS
32523: Datediff
32524: SQL 2005 + Row_Number() question
32525: BCP import - remove quotes from CSV File
32526: Stored procedure and UDF
32527: custom functions and query optimization
32528: Soundex of each element of a string - plase help!
32529: Whats the wrong in this SQL?
32530: Pivot Query Example - does one exist with Datasource available?
32531: Display records in a particular order
32532: Problem connecting to SQL Server 2000
32533: By the Programmers - For the Programmers - Of the Programmers
32534: Like operator on subquery
32535: Select Distinct - URGENT
32536: How to speed up a trigger
32537: running scripts
32538: Soundex of column fields - please help!
32539: ORDER BY in views - difference in 2005 vs 2000?
32540: Joining tables
32541: BCP Import file - how to ignore top line
32542: Getting DISTINCT values
32543: Update Query for Updating Salaries
32544: CREATE script that filters out empty columns
32545: Running 2 queries inside third query
32546: debug a stored procedure in SQL Server 2005
32547: xp_deletemail errors out, can't delete SQL Mail
32548: Return value from SP without declaring a variable
32549: Pulling out table and column descriptions
32550: BCP Help - Going Crazy!!!!