TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
29051: Adv. T-SQL: Finding closest match across multiple columns
29052: Using multiple field index when each of the fields already has seperate index
29053: Improving the Sql environment at our Place ?
29054: transfer data from remote sql server 2000 to local sql server 2005
29055: Tuning Wizard Quits Spontaneously
29056: FIND OUT IT IS A NUMBER OR STRINg
29057: COUNT with conditions
29058: enforce update statement order
29059: SUM
29060: Send bulk data to SQL
29061: Script out whole SQL SERVER Database including INSERT
29062: How to perform multi-namespace?
29063: Query Help
29064: Help interpreting DBCC CHECKDB output
29065: Select statement without specifying Field or table name
29066: Notify Apps When DB is Updated
29067: How to group on half-hour increments on a datetime field?
29068: Hosting a Component in SQL Server 2005 & Security
29069: Reseed identity column in SQL 2000
29070: SQL Express
29071: Slecting from an ordered list Query. Pls help.
29072: where datefld =... vs datefld Between ... not getting same recor
29073: Stored Procedure to Make One Table Match Another
29074: Materialized Views
29075: Date problem
29076: Table Scan Cost: 0%
29077: ExecuteSQLTask Output
29078: ExecuteSQLTask Output
29079: Return value in SQL
29080: Conditional Where
29081: finding max date
29082: Adding Serial No in the Query Resultset
29083: move row data
29084: Running total using day before record.
29085: Find a certain table in multiple databases
29086: Help with a loop to collect database names and tables within those databases.
29087: calculate base 32 notation from int value?
29088: Joining to large tables to perfrom update
29089: varchar overflow into an int column
29090: Service Broker - Queue Priority
29091: SMO - Scripting Indexes (Clustered and Non-Clustered) w/o Primary
29092: Alter table and size changes
29093: Syntax Error in Update
29094: Linked Servers
29095: Monitoring Changes in SP, Table and Views - Server Objects
29096: Convert DateTime to String Preserving Format
29097: MSDE doubts
29098: Optimizing queries
29099: Inserting into joined tables
29100: Problem with Cursors
29101: Recompile Table Functions?
29102: Field Alias as Function
29103: Attaach 2000 data file from network drive
29104: schema
29105: =?Utf-8?Q?aTTACH=C4=B0NG_SQL2000_DB_Without_ind?=
29106: load postscript files into sql db
29107: UNION the results from two stored procedures
29108: Log file size
29109: Stored procedure output parameter does not return value
29110: use UPDATE STATISTICS @table in a cursor
29111: What's the function to convert Date to "mmyy" varchar
29112: cascading stored procedures
29113: Using TOP
29114: How to SELECT data among 4 tables?
29115: syntax of user-defined function
29116: Restoring SQL databases
29117: Fail part of a Stored Procedures but continue processing
29118: Better way to do a large delete?
29119: Group by Month
29120: Want to know all the datatypes, lengths and the tables of col in a
29121: SUM of CASE ELSE not matching WHERE clause... why!!!!
29122: Concatenating columns with datatype ntext
29123: Re-Index Script
29124: 3-way, 4-way, n-way full outer joins?
29125: dateserial eqivalent
29126: CS0117 error accessing SMO DatabaseCollection.Item property
29127: Find all read-only Databases using Stored Procedure
29128: Help with constraint
29129: Need to change a table name from all sp's
29130: Need to script out a sp from Query Analyzer into a varable
29131: Checking Settings?
29132: Table design (search with ranking)
29133: Paging of Large Results Using Server Cursors
29134: Execute Stored Procedure Using Select Statement As Parameters
29135: How does engine decide whether to scan or seek index
29136: Remove trailing zeros
29137: Difference in deleting method
29138: Need help with TSQL syntax and JOIN.
29139: Nightmare Query
29140: Calculating Row Size
29141: trouble using dates in dynamic SQL string
29142: DBCC SHRINKFILE causing massive disk queues
29143: SQL UPDATE Trigger causing "Connection Busy" in App
29144: Problem with DateAdd & GetDate()
29145: Inserting or Updating a View
29146: Multiple-step OLE DB operation generated errors.
29147: Select something that exists in a sub clause
29148: Update sql server from spreadsheet
29149: Copying SQL Stored Procedures (SQL Server 2000)
29150: SQLConnection via proxy?
29151: Symmetric Key password change
29152: Application - document locking
29153: A problem with the SQL Server 2000
29154: Ok, time to start a war
29155: Urgent: Can't (Re)Attach Database
29156: Recovery Model
29157: Replacement of C code with C# code
29158: Update Query Error
29159: connect to different SQL via SP
29160: Need help comparing tables Query
29161: Project type: sql database
29162: SQL: I need to return a result based upon a date range
29163: SQL Management Objects
29164: CheckSum in SQL2000
29165: Select Condition
29166: Scalability questions for extended stored procedure
29167: Case statement 'Operator' in Where clause
29168: Converting Select query to Update
29169: Linked server view performance worse than not using view
29170: Help with cross products and functions
29171: Select Top X Amount
29172: Fail to create asymmetric key
29173: Self Join Delete using IN
29174: cannot change owner
29175: Porting Oracle Packages to T-SQL
29176: Date question
29177: Is xp_smtp_sendmail compatible with sql server 2005?
29178: Management Studio will not allow me to create a view
29179: Selecting latest records not older than 2 months.
29180: Checking null in select list
29181: How to format a SELECT resultset as a comma separated list?
29182: %LIKE% GETDATE() query
29183: Stored Procedure Order By
29184: IDs of updated records
29185: find SP dependencies
29186: Database increase in size to 250%
29187: Unique Identifier inserting in sqlexpress
29188: Computer name
29189: Parent/child SQL query
29190: Transactions handled differently between SQL 2000 and SQL 2005?
29191: What's the recommended way for me to keep two databases in sync?
29192: Combining Row Data
29193: SQL server 2005 won't allow *= or =* syntax.
29194: insert 0 in select statement
29195: replacing [XFO=BM] in a column
29196: SSIS vs Scripting
29197: Find time interval between dates
29198: Calling a sp from a UDF
29199: How can I find records of a table which inserted today(for example)
29200: Finding records of a table which have been inserted from a time ago
29201: Index for primary keys
29202: SQL 2005 error
29203: Hide passwords from the trace using execute ('create login
29204: Trigger and OnDelete Cascade
29205: Data between two sql registrations
29206: Server does not exist Problem
29207: getting a date in the past
29208: INSERT QUERY!!
29209: Query returning inconsistent results - please help
29210: Using Cursor
29211: Bcp data with quotes
29212: Group data by time slot
29213: pass a value other than a recordset from a stored proc
29214: Inserting Records from Table type to Temp table
29215: using a result of one query to select the next query in a stored p
29216: Full Text Search
29217: Is VS2003 usable with SQL2005 or not?
29218: SELECT COL_NAME(@TableId, @ColumnId) FROM Departments DOES NOT WO
29219: Delete SQL Query - Brain Hurty
29220: SQL Server vs. Access
29221: Optional AND!!
29222: SQL count problem
29223: Cascade delete relationship slower?
29224: Generate row number in query
29225: Get column name and value
29226: JOINS and WHERE clause
29227: Ignore Some Errors
29228: Query help
29229: How to change server name in SQL2K ?
29230: possible to select top 5 * of 2 or more individual criteria?
29231: Returning values from a stored procedure - Help needed!
29232: Change how command runs
29233: insert into longvar
29234: Control jobs using SQL code?
29235: purge process from large table
29236: Complex Query to Create View
29237: How to change server name in SQL2K ?
29238: simple select
29239: optimistic locking
29240: Query In-between Dates
29241: Calling VB dll method: sp_OAMethod Error
29242: help me with Paging problem sql server 2000
29243: Computing a Grand Total
29244: Left Outer Join Question When One "ON" Value Empty
29245: Creating Summary Table - from multiple tables
29246: sa password rules
29247: Encryption by Password
29248: Developing for 2000 (SQL8) on 2005 (SQL9)
29249: How do I do this query
29250: Hierarchical data with any DataReader
29251: [SQL2005] Binding defaults without using sp_bindefault
29252: Complex SQL Query
29253: Dynamic Data
29254: Is Agent installed?
29255: Could not execute query against OLE DB provider 'MSIDXS' Error
29256: Failover and detecting cluster switch
29257: How to treat Database Snapshots as if they were one database?
29258: XML Data Type
29259: SQL server becomes case sensitive if I choose collation as : Chinese_PRC_BIN
29260: Restore MDF file
29261: deadlock
29262: need help to write query
29263: generate update statements for existing data
29264: Import MDF SQL 2000 file into SQL 2005 Express
29265: Update Query Help!
29266: Design Question
29267: Why the correct index is not selected
29268: Error 3716 - security settings
29269: Divide Integers
29270: Conditional Join
29271: Question on Settings in Connection
29272: visual basic transformation script
29273: slow accross subnets
29274: query with a column per row of a linked table
29275: Problem during MSDE to SQL Express migration
29276: Subreports to separate books in excel
29277: Substitute the Null fields in the results of a sql statement
29278: Multiple Contain Statements
29279: Tracking updated columns
29280: SQL Express and DTS
29281: Coalesce Question
29282: A trigger that backups data from several tables...??
29283: Transaction log file size?
29284: Data lost during converting int to smallint
29285: Calculating Quarters for a Forcasting Report
29286: Calculating Quarters for a Forcasting Report
29287: Table growth
29288: OBJECTPROPERTY question
29289: Creating a Stored Procedure to collect DB information and then run another Stored Procedure using that information
29290: Linking Excel and SQL
29291: Date range with only an 'EffectiveFrom' column
29292: Using aliases with COMPUTE
29293: Datetime convert problem
29294: Cursors within stored procedures
29295: BCP path problem
29296: xp_sendmail task
29297: Intra Query Error
29298: comparing dates
29299: using datetime in where clause
29300: Job Status Suspended
29301: Passing Parameters
29302: Database backup?
29303: Setting database options in a view
29304: Query/table tweaking Help
29305: Saving results from query in Web Data Adminstrator...
29306: Foreign key to multiple tables
29307: DTS completion time jump
29308: Store attachment into table
29309: Domain name from URL
29310: Group by datetime
29311: Changing between Identity type and Int type
29312: query - which came last?
29313: Datetime comparsion
29314: SQL SERVER PARSE ERRORS
29315: Use ACCESS driver on Win NT4.0
29316: Bulk Insert Problem
29317: Fast updates in SQL Server
29318: I want to set this error into a variable
29319: How to specify another Server
29320: Logic for picking values from columns
29321: Optimizing insert performance
29322: Execute stored proc dynamically (stored a variable)
29323: 2 highest marks of each group
29324: Delete Duplication
29325: Assign multiple variables from select in stored Procedure
29326: Suppressing SQL Errors
29327: Jet OLDB Error on 1/2 of A/A Cluster
29328: why sql server 2000 full text search doesn't work ?
29329: Need guidence on notifing when a new users is added
29330: Conditional column NAME on insert/update
29331: TimeSpan
29332: Which one is faster?
29333: Relational Design Question
29334: datediff2
29335: What is the best way to transfer databases from one server to anot
29336: datediff
29337: Derived Query
29338: HELP! Problem with data selection.
29339: Bulk repopulation of a table
29340: convert datetime
29341: XMLDOC
29342: OPENQUERY from ASP.NET Page Problem?
29343: help me
29344: Help with a complex Join
29345: Changing the database from MSAccess to MSSQLServer.
29346: continuous dates
29347: VIEW will not UPDATE with INSTEAD OF TRIGGER
29348: Maximum Size for UDT
29349: Null and UDTs
29350: Name property of SqlUserDefinedType
29351: Update Help
29352: Whare are temp table names padded with underscores?
29353: Can CONTAINSTABLE be made to match unconditionally?
29354: Confusing CONTAINS behavior
29355: append single character at specific position in string
29356: Making a term found in a string the subject
29357: Inserting Records from Table type to Temp table
29358: Problem with too many queries.
29359: String Manilpulation
29360: Time format hh:mm:ss pm
29361: Order By Primary Key
29362: [ot] VBA workgroup / domain name
29363: Use of TABLOCKX
29364: stored proc help
29365: Text file import
29366: Yukon and intellisense?
29367: Select where result are by the best match
29368: Verify if a Table Exists
29369: Need the Guru HELP. Ðåáÿòà, ïîìîãèòå!
29370: tnx
29371: getting today's data in '2006-01-20' format
29372: Table to comma delimited
29373: Data Compare
29374: Changing NULL to zero
29375: remotely start/stop sql server service in a workgroup
29376: union ?
29377: Can I write query like this
29378: is there a way to get listing of table relationships
29379: where current of cursorName
29380: Changing the Table Type
29381: ASP.NET * Cannot find file
29382: TRIGGER UPDATE QUESTION
29383: How to add sproc to multiple databases
29384: Clean out (Reinitialize) SQL Server Database?
29385: Identity Values
29386: instead of trigger on view
29387: sending results of query into a table
29388: Throwing Errors In VB Script From SQL Job
29389: How to remotely start SQL Server instance?
29390: Really really slow cursor
29391: Problem copying data from column in same table
29392: Not like operator seems to be being ignored in Trigger
29393: TreeView Populating problem
29394: Inline table function help
29395: Creating a table
29396: Have Svr name, need DBs
29397: variable for DateAdd datapart constant
29398: xp_readmail
29399: Hyperlink
29400: How can we CREATE a VIEW with variable which stores a select stat?