TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
28001: stored procedure for selective update
28002: How to insert more then one order into customers orders table
28003: how to retrieve a row by specifying row number
28004: sql programming
28005: GETDATE() Function Issue
28006: BCP Table Name Limit
28007: SQLExecute return code for stored procedure.
28008: Max characters over column?
28009: How to pad the output of a query with spaces
28010: Group By
28011: sql audit trigger
28012: Lexical Date returned from xml web service
28013: User-Defined Aggregate Function CLR Sql 2005
28014: sp_send_dbmail limits mail attachment to 100000 bytes
28015: Joining Data between 2 SQL Server machines
28016: sql object query
28017: Get column names from sysprotects
28018: Help on data query
28019: Find out what columns a Proc/View need?
28020: Stored Procedure Input Parameter Problem
28021: Alter table
28022: sql server triggers
28023: can this be done with a check constraint?
28024: query help, please
28025: compression of database backups - as it is being created - options
28026: 3 global variables 3 sql server connections?
28027: Connection
28028: question about cache / disk reads
28029: Invalid column name
28030: CREATE_ENDPOINT / HTTPRequest
28031: Convert decimal to VarChar without trailing 0's?
28032: Missing Operator Error
28033: Error when field in ORDER BY does not match SELECT DISTINCT fields
28034: Building a record from my SQL 2000 Database
28035: Incremental Data Definitions
28036: How to do this? Thanks.
28037: inline table-valued UDF that sql treats as multi stmt UDF
28038: Rename Columns
28039: how to identify stored procedure dependencies?
28040: What version of SQL Server
28041: truncate and insert stored procedure performance vs. T-SQL
28042: Cannot sort a row of size 8095, which is greater than the allowable maximum of 8094
28043: Join columns - Key Field
28044: Outer table inside stored procedure
28045: returning a table from a function error
28046: Soundex function - please help
28047: Date formats in SQL
28048: difference
28049: How to refer from a stored procedure to a table in another databas
28050: Changing file grouth automaticly
28051: CASE WHEN PROBLEM
28052: Extracting Integer
28053: Queuing Files
28054: Question
28055: Setting file growth of file
28056: Find UNICODE Data
28057: Max Date for multiple columns
28058: Why are Parallel INSERTs slower than non-parallel when you have a
28059: How to generate procedure with all table data
28060: Does anyone have any explanation for that?
28061: jobs and @freq_subday_interval = 9
28062: Database diagram 2005
28063: Date Manipulation
28064: 2005 Database Diagram
28065: 2005 Database diagrams
28066: Updating a column with a total
28067: Controlling the cursor position
28068: Database diagram 2005
28069: Silly substring question
28070: Updating all Records in a Table
28071: Most efficient wasy to execute a Stored Procedure with one to many relationship
28072: distributed Queries .......problem on linked server
28073: Like on join
28074: TRANSACTION ISOLATION LEVEL
28075: Use Multiple Databases from Parameters.
28076: Ink
28077: recursive query help !
28078: sql 2005 - access denied all of a suden
28079: implementing notification service of SQL Server 2000
28080: Limitayion of indexes
28081: Executing Stored Procedure with result set
28082: Exporting a table to a file -reg
28083: function problem, referring to another function
28084: how to remove cursor ?`
28085: resotre the user in the database
28086: Query Analyzer
28087: Inverse -- Reverse
28088: faily to update record
28089: error with trigger
28090: Ink
28091: select from two tables
28092: Any query to return the execution time for another query?
28093: Stored Procedure to return multiple rows in one field
28094: rename file using cmdexec in SQL Server Agent job.
28095: Update rows as they are inserted.
28096: Stored procedure not executing in the order of the TSQL
28097: transactions and error handling
28098: SQL Server Stored Procedure & Nested Query Syntax
28099: Cannot delete rows that contain same data
28100: =?Utf-8?Q?It=E2=80=99s_the_little_things!?=
28101: udpate field by using matching
28102: Design problem
28103: char to integer ?
28104: Analysys Services 2005
28105: error handling
28106: Display estimated execution plan bug
28107: **changing the logical name**
28108: clustered index
28109: can this be done?
28110: conditional update within value
28111: Backup and Restore with STOPAT
28112: Log Shipping Question
28113: optimized indexing 1
28114: Re: import txt file wizard
28115: optimized indexing
28116: Hebrew Sql 2000 to 2005 Collation Problem ?
28117: UNABLE TO SEE SYSTEM TABLE IM NY ENTERPRIsE MANAGER
28118: Delete and insert data in same transaction!
28119: Change Field Name
28120: MOVING FROM ACCESS TO SQL
28121: About images and audio waves
28122: **fetch the related tables of a particular table**
28123: Query question
28124: Question AGAIN!!
28125: Multiple Joins Showing Wrong # Records
28126: Creating a view with multiple join criteria
28127: SQL Jobs Fail but give no error
28128: getdate()
28129: Please Help: SSIS Package execution issue
28130: design question
28131: import txt file wizard
28132: An Insert Trigger with CDOSYS generated email
28133: Change Column Names
28134: Vb.NET
28135: Huge amounts of unused space...why?
28136: Update Trigger Question
28137: Articles or Blogs
28138: For XML Explicit in a stored proc
28139: Solution needed Urgent...
28140: An alternative for Dynamic SQL required
28141: How to get varchar parameter in Extended stored procedure
28142: Get return value of stored procedure in Query Analyzer
28143: simulate infinite loop
28144: obtaining the names of triggers within T-SQL
28145: text to varchar conversion woes
28146: How to save an HTML doc in SQL 2005
28147: Compare subsets
28148: Search for newline chr
28149: Indexed view
28150: how to debug the stored procedure in sql server
28151: moving from Access to SQL 7.0
28152: executing a trigger
28153: transpose
28154: updateable and non updatable rows
28155: Maximum Rowsize screw up by MSSQL 2000
28156: Alternative to OpenXML
28157: Dates Help Needed
28158: Optimal storage of a lot of text records
28159: Need help with the SELECT statement please.
28160: DB Collation
28161: predicate [ ] using xml in sql server 2005
28162: Problem with Date logic
28163: PID in VHDL code
28164: T Sql Help
28165: TSQL Complicated query
28166: Solution Required Immediately
28167: Double Quotes and Print
28168: Culture in MSSQL 2005 express edition
28169: Using Temp DB vs a standard db for work area
28170: Application for "Replaying" a Table
28171: aggregate query reporting different results
28172: Return a Field from a User Function ??
28173: The best way to connect to SQL Server from C++
28174: database diagrams
28175: bcp right truncation: how to ignore
28176: Top N worst groups SQL problem
28177: How to insert resultset from SP into a table? or use Select * From
28178: table name as variable
28179: Audit Table - Design Question
28180: SQl Profiler
28181: SQL Server 2000 Automatic Setup Script.
28182: SSIS and ragged rows (variable number of columns)
28183: Replacing specific text characters in a TEXT field with CRLF characters
28184: SQql 2000 Nested Loop
28185: Which primary key
28186: list of tables and views in a database
28187: Aggregating bit data types
28188: Table variable and statitics on it
28189: Estimating time for creation of clustered index
28190: Question about LIKE and wildcard operator (%)
28191: Running the same SQL on several servers
28192: Linked Servers
28193: SSIS Package not executing as SQL Agent Job
28194: Convert date to year
28195: Primary Key fields require index?
28196: How to Copy the User
28197: Where are Default Values stored
28198: Validate the text field in the sql server
28199: NEED HELP W. QUERY USING DISTINCT AND SUM AND CASE
28200: Update trigger during large updates
28201: migrate a 600GB of DB from State to State.
28202: Best way to create next sequence number
28203: To Query or not to Query
28204: Query question: Getting the employees wich are working on the same projects...
28205: Trigger Or Constraint
28206: Update Trigger
28207: Timeout
28208: Is there any methods or tools to generate impact analysis if I will change a field type and length?
28209: Splitting field contents into several columns (newbie)
28210: SqlCacheDependency issues with the SqlCommand
28211: Create my own profiler
28212: change of value at the time of insertion
28213: Need help on aspnet_Users table in 'aspnetdb' database.
28214: How do I mimic autoNumber for non-identity columns?
28215: "query notification" problem
28216: Strange Performance Issue
28217: ORDER BY Aggregate and Grouping
28218: Not returning @@Identity
28219: Contraints
28220: Missing data from restore
28221: select and update statements in a while loop is not working proper
28222: Between date problem
28223: requesting query optimization help
28224: Types of SPROCs
28225: script error checking
28226: Is there a way to escape a single quote?
28227: Need help with a Stored Proc. - using BEGIN TRANSACTION and END
28228: Physical File Access
28229: bulk insert which check if record exists
28230: Invalid connection string to MSDE 2000 database
28231: Determining Cascading Delete
28232: About transaction involving table variable
28233: Nested Transactions
28234: Debugger question
28235: Web services question
28236: Transfering MS SQL database to MySQL
28237: Best way to generate next sequence number of a table.
28238: arithmetic operations with money and real
28239: Reverse engineering a database in visio
28240: Wisdom behind using fully qualified table name in field name
28241: Transaction model
28242: 24 Hour
28243: SQLOLEDB with Server=(local) on SQL Server 2005
28244: UPDATE not working
28245: Table information
28246: Results of stored procedure into a table variable.
28247: Very basic question
28248: Browser time out: when executing a DTS package
28249: Query with union no longer updatable in SQL 2005
28250: Do we still have SQLXML in SQL 2005?
28251: SELECT with COMPUTE?
28252: SQL Server 2000 bug ? INDEXKEY_PROPERTY
28253: c# 2005 express edition install difficulty
28254: Creating Dynamic Data Flow Task
28255: group by and sum
28256: select question
28257: SQLXMLBULKLOAD don't fire trigger
28258: Urgent - Calculating Percentage Input fields per record !
28259: Check if record has dependencies
28260: Trying to understand transaction model
28261: Creating table with Identity property
28262: Problem in between clause
28263: Efficiency problems using PRINT in CURSORs
28264: Match timed events
28265: SQL2005 joins and wrong execution plan
28266: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
28267: how to check whether the sql server is up
28268: Composite index design question
28269: database design:dnamically build where clause
28270: How to simplify my storeprocedure
28271: Group by weekends
28272: Help with trigger
28273: Join table with a UDF?
28274: can't update table owned by dbo with impersonation account
28275: Interface
28276: Question about error handler
28277: SQL Server 2000 xml solution
28278: Call a Dll from Stored Procedure
28279: How to make argument/parameter optional in UDF/Trigger?
28280: how to create function which eval expression
28281: sp_OAMethod Returns Empty String
28282: Pick TOP 1 row per GROUP BY group
28283: How can I consume webservices from MS SQL 2005
28284: Can I build WHERE clause dynamically in a Stored Procedure in SQL Server 2005?
28285: combine data in one row?
28286: How to copy a table including all constraints,... to same database
28287: Newbie Select Problem
28288: Dynamic Where clause
28289: Stored prodedure OUTPUT parameter
28290: How can I use stored procedure's recordset output into simple SELECT statement?
28291: Static variable in SQL procedure ?
28292: SQL-DMO broken!
28293: Rowcount reporting incorrectly...
28294: Synchronizing data between sql 2000 and sql 2005
28295: looping with SQL
28296: Bulk Insert
28297: creating xml and passing it on.
28298: problem with datepart ....
28299: What is the cost Sql Server incurs by using the SqlDependency class?
28300: Isolation Levels
28301: ex stored proc and COM objects
28302: Creating a table from a view
28303: Having problems getting stored procedure to work.
28304: Select this and last years data to show side by side
28305: Challanging task, for fun - answer two questions from given data!
28306: Looking for a generic list
28307: Turkish characters are not displayed correctly on production server
28308: Any way to avoid using a cursor for this?
28309: Error (8626) while inserting record into table with text field and which is the base for indexed view
28310: How to set sql server setting let to set null value when a empty string (zero length) set to column?
28311: ALTER TABLE ... IDENTITY question....
28312: Migrating to SQL Server!
28313: Truncating vs. Rounding
28314: snapshots on sql25k
28315: HELP ME!
28316: HELP ME!
28317: A question of design
28318: PID in VHDL code
28319: Maintanance job fails
28320: Maintanence job fails
28321: SQL Server Agent
28322: values of Columns in two different table ---presentation
28323: values of Columns in two different table ---presentation
28324: Values of two columns in two different tables--presentation using select
28325: Values of two columns in two different tables--presentation using select
28326: Need help with stored procedure
28327: Creating a Backup Server software
28328: SQL 2005 Books Online and synchronize feature
28329: Can SQL Server 2005 using C# make a SOAP call do set operations?
28330: DTS Parsing Delimited Record
28331: Database Backup And Transaction Log - SQL Server 2000
28332: about MSSQLSERVER run as LocalSystem
28333: To find the number of occurrences
28334: query
28335: Calling a Stored Procedure inside mysql.
28336: New One Here - Dont Laugh
28337: User Defined Functions and 4-part names
28338: DTS and "SQL Server does not exist or access denied"
28339: -2147217887 Error when sending to SQL 2005
28340: Extract data from 350 seperate Excel Files
28341: Is this a permissions issue?
28342: Import & Delete Rows
28343: WHERE NOT EXISTS STATEMENT
28344: SQL Query Help
28345: Help with a loop.
28346: Strange Maths
28347: Advice
28348: Connecting to DB2 / AS 400 from SQL Server
28349: Suggestion Sought
28350: How to determine when the last successful full backup occurred?