TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
33951: can't select the right value in this statement
33952: Searching Table Question
33953: Execute Stored Procedure from User Defined Function
33954: Populating a table based on query... Help needed !
33955: Self relating tables
33956: SQL programming question - cross-tab or pivot data
33957: Consistant dates for use in querys
33958: what the heck is happening here
33959: SQL help
33960: function in a constraint
33961: script to drop all 'user' objects
33962: Bulk Insert of new records in sequence
33963: Convert to month year
33964: T-SQL Question
33965: Between vs. >= and <=
33966: Creating SQL database "Users" pulled from Active directory OU
33967: Help on selecting on 3 keys, and finding both beginning and ending
33968: GetPackageSQLServer Variable Substitution Issue
33969: I have a dream - Enum datatype in SQL 2005?
33970: Indexing ?
33971: Removing "time" from datetime.
33972: Real Exams
33973: Refreshing Links in Access doesn't allow me to Add Records!
33974: Splitting database into multiple databases - opinions?
33975: SQL 2K: Return more than 8000 character string from User Def Function
33976: Error inserting into Table Datatype with Identity Column
33977: SQLTrigger
33978: How to make this expression SARGable
33979: SQLServer DB versioning question
33980: Order of cursor walk
33981: Joining table UDFs in queries
33982: How to check in an update modify the row
33983: how does it work ?
33984: EXporting data to xml file
33985: Compare Date Values!
33986: field definitions for all user tables
33987: Ignore table based on data_type
33988: stored proc definition - syscomments
33989: JOINS / Exclude rows
33990: Date Format?
33991: Help with Relational Division
33992: View containing relationship between different data types
33993: Super query?
33994: question about sp_generate_inserts (Vyas's SP)
33995: Index Tuning Wiz - recommendations page differs from script
33996: Help with trigger logic
33997: Repost: just in case i can get an answer
33998: SQL query question
33999: Selecting rows that are the latest for each of their kind, etc
34000: Attaching Incremental data
34001: Performance issue on MSDE 2000
34002: String truncation
34003: Use results from a select statement in a follow-up select statement in a SP
34004: Efficiently Inserting 1 Million records
34005: Sending multiple .doc email attachements from SQL data?
34006: create a log file of a script
34007: Bizarre set of SQL results...
34008: What Jobs is my SQL server running
34009: table design
34010: Send mail Issues
34011: Remote procedure call failure
34012: new records are not updateable
34013: removing dash lines in query result
34014: xp_cmdshell
34015: Stored Procedure errors
34016: managing one to one relationships
34017: Restore ..Dont Make Me Fool!
34018: How to select using comparison of rows?
34019: query Exec time?
34020: How can I test for divide by zero without using CASE?
34021: Bulk insert bypasses trigger
34022: bulk insert
34023: SQL Availability
34024: Quoted-Identifyer
34025: All IN
34026: kill & rollback
34027: Ghost Views
34028: Best way to retrieve rows matching an array of Ids
34029: List of accessible databases on a server
34030: Distributed transaction failed.
34031: What is wrong with this exists
34032: sp_xml_preparedocument error handling
34033: SQL Server Logins
34034: How to declare an array/list variable?
34035: scheduled server side trace - not working!
34036: problem in the view
34037: Bug in evaluation order (or am I wrong?)
34038: How can I do this ?
34039: Possible to have 2 Identity columns in a field?
34040: Update Stored Proc: Know the Updated Column
34041: pls help
34042: Can we submit a asynchronous call through job
34043: Client Network Utility in x64 does not work?
34044: Duplicate records
34045: select duplicate records
34046: How to avoid blocking when doing insert and range delete
34047: Implementing derived table fields using views
34048: SmallDateTime!
34049: how to catch the failure
34050: Perfromance issue b/w varchar and char
34051: Parameters - Coalesce!
34052: How do I adjust the tab settings in SQL Server Enterprise Manager.
34053: Import from Linux MySql
34054: Trigger problem Server: Msg 512, Level 16, State 1
34055: Joins: strategy and how-to approach
34056: erwin and data modeling
34057: Update one table based on criteria being matched in another table.
34058: Duplicating column data in same table
34059: Stored Procedure Terminating Prematurely
34060: Format Dates in TSQL - My code below
34061: dynamic sql server statements
34062: terrible performance issue
34063: select from another database
34064: question
34065: Transactions in DB Projects (Visual Studio 2005)
34066: Filter by a concatenated column?
34067: sql2005 and sql2000
34068: Read Only Cursor
34069: For Insert/After Insert -- Default Trigger Question
34070: How do we handle an array of data in SQL Server 2000?
34071: Triggers for Audit Trail Deleted/Inserted joined
34072: Compatibility between SQL Server 2000 and 2005
34073: Design of Scheduled Task data schema
34074: question about consultant position
34075: Getting mor recursive value in a select
34076: Stored Procedure Query
34077: Transactional Replication
34078: Return Scope_Identity after Update (?)
34079: Compare two queries to see if their results are identical
34080: Returning only one row from joined table
34081: Performance setting for a job
34082: how to programatically determine what output of sp will be?
34083: MS Access Returning Decimal Portion of A Double
34084: Parameterized UDF in correlated subquery
34085: Management Studio 2005
34086: SQL Query
34087: Complex query
34088: Optimization tips for Cursor and Scope_Identity
34089: Surviving Sarbanes-Oxley Audits: Lessons Learned by Database DBAs - Louis Columbus
34090: clustered and notClustered index
34091: How do I concatenate several records from a table?
34092: Performance Optimization
34093: Can we read Online transaction log without using DBCC Log
34094: ADO puts EXEC in front of my SQL statements?
34095: XCALL "before" values is NULL for ntext
34096: Abnormal Timeout Issue on Production System
34097: yyMMdd problem
34098: xp_sendmail not saving in Sent Items folder
34099: Query Help!
34100: How I join in this case?
34101: SQL Puzzles (Beginner Level)
34102: prepared query
34103: quick switch question
34104: How can I import data from a remote server based on records in the local database
34105: CURSOR QUESTION ???...
34106: One entry per individual with multiple entries
34107: select stmt value as arg to stored procedure
34108: INSERT range question
34109: filter
34110: How to get the name of the database currently connected to?
34111: passing table name as paramenter in SP
34112: triggers executing programs?
34113: Binary to Varchar
34114: Get User-Input into a Stored Proc
34115: problem with OUTPUT + returned recordset
34116: hanlding null value in stored procedure
34117: Determine table constraints for database upgrade/migration project
34118: ADODB Command
34119: Help with sequel statement please. Thanks.
34120: Help with sequel statement please. Thanks.
34121: concatenate
34122: Testing for numeric
34123: Dynamic SQL
34124: How to select records from a non-pre-defined table?
34125: Help with a Query
34126: msg 296 - out of range smalldatetime value
34127: How to calculate category value - perhaps use subqueries?
34128: How to improve this query?
34129: Return Value from SP
34130: Performance difference between the IN and OR statements
34131: Selecting field from row just updated in trigger
34132: bypass a transaction
34133: Advice on working across databases?
34134: What do we mean by Length
34135: JOIN the only relationship method?
34136: SQL QUESTION????
34137: kick off multiple procs
34138: Insert into table with xml
34139: SELECT SubQueries and Stored procedure
34140: Generate Script
34141: Simple Problem?
34142: Validate sintaxis
34143: Best practice...
34144: Sorting a query
34145: Sorting a query
34146: Error Trapping
34147: varchar to decimal with a sign
34148: Maximum Table Size
34149: Why does this work?
34150: Group by month
34151: SQL Database Errors Question
34152: complicated select
34153: Dynamic SQL or CASE statement?
34154: SQL 2005 .NET Stored Procedure - Returning more than 8000 chars
34155: Is this a bad database design?
34156: Update in a if() begin end statement
34157: HAVING and GROUP BY
34158: Help with SQL query please
34159: An INSERT command with a subquery
34160: Reduction of Query Execution Time of Larger Database in SQL
34161: SQL Debugger Issue (SQL 2000 sp4)
34162: Improving Query Execution Time in SQL
34163: SQL Server Error
34164: Execution plan
34165: Query help
34166: Conditional Joins
34167: Hosted CLR and remoting
34168: ddl
34169: different results with the same query
34170: bulk insert into partition view (sql 2000)
34171: How Can I remove Table Scan?
34172: SQL Syntax: Views .... help.
34173: details about finetuning queries
34174: please fine tune these queries
34175: Convert Rows to Columns in Select
34176: how to programmatically detect if a view is updatable
34177: what mean the tables are truncated
34178: please help me out
34179: VCS or change management
34180: Full Outer Join question.
34181: SQL SCRIPT SYNTAX QUESTION!!!...
34182: Chasing my tail with this design
34183: Correlated subquery question
34184: data Type equivalent in SQL Server
34185: Fun (trouble) with outer join
34186: txt file with trailing sign
34187: QUESTION
34188: Not getting Identity back
34189: new sql version control solution!
34190: Modify Multiple Stored Procedures
34191: Cannot update
34192: Code to calculate lat/lon given a lat/lon and distance?
34193: TSQL and database recovery
34194: problem querying a TEXT field
34195: Trigger After Delete - Multirow
34196: calling a exe . reading from a text file from a stored procedure
34197: DATA COMPARE Question????
34198: Constraint question
34199: Convert Week into Start and End Date
34200: Clarification on the ROWCOUNT statement
34201: Setting ANSI_NULLS on all databases
34202: bad query plan when using parameterised queries on partitioned vie
34203: Datatype change INT to BIGINT on a large table
34204: Primary Key Corruption
34205: Transaction hangs
34206: sp_reset_connection crazy
34207: Dynamic Reference to Linked Server
34208: How to test a stored procedure ? how ?
34209: How to script adding a field to a table
34210: Updating records accross two databases
34211: user permissions
34212: SQL Server Logins
34213: Structure exportation
34214: Option for ignoring extra parameters sent by name to a procedure?
34215: sp_msforeachdb
34216: stupid question regarding joins
34217: Kick off procs
34218: DLL missing or ???
34219: Messages back from SqlServer while a Backup is being completed?
34220: IMEX=1 in OpenDataSource
34221: Database crashed its very urgent
34222: Are NULL Counts reliable?
34223: Foreign key and indexes
34224: OpenRowset - Data loss in Excel
34225: Filling out gaps in a date based select statement
34226: Changing User Permission
34227: Detect Record Conflict:
34228: import from Excel file
34229: Recordset to Array
34230: Erroneous behaviour of COALESCE versus ISNULL???
34231: Stopping Blocking on Stored Procedures
34232: large amounts of data
34233: help me out
34234: latest order date
34235: Double Quotes!
34236: Dynamic SQL!
34237: Display a zero with Count and Group By
34238: Trriger in september CTP
34239: DTS Packages
34240: Asking
34241: bcp
34242: Table names as a join parameter
34243: EXECUTE AS in SQL 2005 - does it always work?
34244: SQL code passed with a parameter
34245: Windows Server 2003
34246: Giive me examples
34247: design help
34248: Column size
34249: Adding Column to table
34250: Beta testers wanted
34251: Get value of parameters passed in stored procedure in a trigger
34252: Large TempDB
34253: dtproperties system table changed to user table in sysobjects?
34254: OpenRowset - Excel copies only 255 characters
34255: Totally OT: 'Celko' Pronounciation
34256: Question
34257: Database/Application Documentation
34258: Need advice on ETL architecture...
34259: Cursor question
34260: Need help with how to get a count of unique values in a table
34261: Subqueries in Case statement
34262: delete records
34263: Surrogate Keys
34264: Cursor question
34265: Help! Need assistance!
34266: Dynamic Execute in Function?
34267: Is this a bug, CURSOR_STATUS() always return -3 ?
34268: SQL Server and case sensitive instance
34269: Partitioning - Execution Plan
34270: Distributed Transactions fail
34271: select only first row
34272: QA Reserved/Keyword 'HELP'
34273: Trigger on Insert for existing data
34274: Inline Queries Definition
34275: scramble password
34276: UPDLOCK problem with Stack
34277: converting a column from varchar to int
34278: IsNumeric Function Question?
34279: Incorrect syntax near 'COLLATE'
34280: Percent Range for a list of numbers
34281: Can we specify timeout for a SQL server job?
34282: viewing index info in query analyzer
34283: SQL query help
34284: Group By OR ?
34285: Problem with SQL Server and odbc, please help me!
34286: Group By OR ?
34287: More not in issue
34288: Access 97 / VBA Users...
34289: SQL Select Last Receipt Statement
34290: User Roles and Permission
34291: Error in GroupBy
34292: Table Manipulation Issue
34293: Count with Group By
34294: datediff comparison to previous row in select statement
34295: problem with xp_sendmail
34296: file backup
34297: no recovery option
34298: Upgrading our system
34299: Count Attempts!
34300: TOP Operator - Variable?