TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
32551: replication problems
32552: How could do I such thing?
32553: Problems In Connecting Using New Driver
32554: XMLHttp to Excel ...
32555: Design question (CELKO?)
32556: SELECT INTO
32557: I was asked for this in interview...??? how to solve this..
32558: GROUP BY alias...possible?
32559: SIMPLE but HOW? - Stored Procedure within Query
32560: Linked Server performance varies depending on user
32561: getting exclamation sign in message when sent using sql email
32562: GROUP BY and ORDER BY
32563: Stored Procedure will only update one row
32564: mapping two references from one table ??
32565: SQL....two phase commit protocol
32566: SQL...checkpoint frequency
32567: SQL...backward error recovery technique
32568: SQL...forward error recovery
32569: SQL...nested transactions
32570: SQL...update-in-place scheme
32571: SQL....backup recovery
32572: TARFU: Data Controls
32573: Where Claause for Unique Constraint?
32574: output param in stored proc is NULL
32575: SQL Agent Jobs
32576: Rows not being excluded by join
32577: Bizarre SQL statement
32578: Changing ownership on all objects in a DB
32579: SQL Server Developer Position
32580: Conversion from Access to SQL Server
32581: Referencing a composite foreign key
32582: question about system tables
32583: Query Notification question
32584: T-SQL to denormalize data
32585: Merge Replication SQL2005
32586: Shared procedure with variable field name + data pairs
32587: Blocking Threshold Exceeded
32588: SELECT DISTINCT help
32589: Reality check...
32590: Article on when to use Stored Procs?
32591: "Max row" in each group
32592: It worked before - accessing table twice in SqlExpress2005
32593: Duration, not time...?
32594: isql file wrapping
32595: Count(*) divide returning 0?
32596: joining a varchar with a int column
32597: hi
32598: table partitioning
32599: Query help
32600: Enable Logging For Severity Errors Lower Than 19
32601: xml store data on sql
32602: How to run multiple jobs in parallel
32603: Client Side Connectivity to SQL Server 2005
32604: INSERT many records with one statement
32605: Syntax error
32606: export data to .xls from stored procedure
32607: Just "effing" wonderful.
32608: identity in the resultset
32609: ERROR: Must declare the scalar variable (@Date_ID)
32610: Change condition if the first doesn't exists
32611: SPLIT to INSERT
32612: Improving performance of GROUP BY query
32613: JOIN Query Problem
32614: simple query
32615: BULK INSERT with leading/trailing quotes
32616: help with query
32617: Timestamp Alter Table
32618: Get files from FTP using DTS
32619: using login name as variable in grant statement
32620: now() and datetime: out-of-range
32621: Need help with a query
32622: Re: Update requires a valid UpdateCommand when passed DataRow collecti
32623: How can I get the files under a special directory on a remote sql server?
32624: Grouping by daterange
32625: Maintaining a Date/Time Last Updated Value
32626: Best practice for remote queries
32627: ANN: AGS SQL Server 2005 Utilities Update
32628: An INSERT EXEC statement cannot be nested.
32629: BatchOptimistic
32630: BatchOptimistic
32631: Top 'n' within a group
32632: Inserting into a time based table
32633: insert a random password
32634: How Can I Do This
32635: > Date
32636: Count Varchar
32637: Qry with "OR" keyword assistance...
32638: sql - comparing dates when there is a NULL
32639: multiple parent categories
32640: Column Alias Behavior
32641: CLR Return Types
32642: DELETING ROW DATA
32643: Fastest way to convert scripts to use Linked Server?
32644: Urgent: SQL Help
32645: Changing Column Name
32646: Creating Schema
32647: Stored Procedure Automation Problem
32648: xml and sql
32649: Select Query-Urgent
32650: Group by issue for a cross tab report
32651: DTS Error checking
32652: How to Job on Remote Server
32653: Simple Trigger Question..
32654: Writing code to do a dynamic insert
32655: How to write script Update defaults
32656: datediff
32657: Dynamic calculation
32658: CASE Syntax
32659: Stored Procedures and Return Codes...
32660: query a sorted view by rows
32661: Searching Field Name and Value in Database
32662: Help with a Stored Procedure..
32663: Naming checkboxes
32664: split variable
32665: How to use/create triggers in sql server 2000
32666: Combine 2 tables
32667: Script Out T-SQL Code Programmatically
32668: SQL 2005 DTS?
32669: Ranking of search results
32670: Returning row value before deletion
32671: Inner / Outer Cursors
32672: Calculate New 'Unique' Records Each Day
32673: Creating Identity Field
32674: Find Match Count
32675: money for nothing that works
32676: CLR problems
32677: Announce: Win32::SqlServer - access SQL Server from Perl
32678: Query help
32679: Increase nvarchar field value like a num
32680: SELECT '1' FROM mytable?
32681: A cursor performance related question
32682: Need help setting default value of a field
32683: Cursors always reads from physical disk (SQL Server 2000)?
32684: Stored Procedures and the GetTime() function
32685: Saving New Diagrams
32686: Execute Stored Procedure option missing from Object Explorer
32687: Triggers - need suggestion
32688: Stored procedure Or View
32689: Time Series processing pattern (not data mining)?
32690: How to return a set of Data ?
32691: index and query optimization plzzz
32692: Can I use the 'IF' clause in a 'WHERE' clause ?
32693: query help
32694: Table Name
32695: COUNT - a little help please..
32696: How to get the most new value registered...
32697: howto sp_adduser
32698: Getting value from SP
32699: using variable with INSERT INTO statement
32700: Failing inner join
32701: SQL dateadd
32702: Execute SQL based on number rows in two tables
32703: Dynamic Sql Intermittenetly Slow - Losing Hair Fast
32704: OLE DB provider name
32705: What backup files do I need to keep?
32706: Re-raising error
32707: Update only x records but also depending on a given order.
32708: need help with crosstab query
32709: T-SQL Debugger Proglem.
32710: copy DTS from a user to another
32711: SQL Express 2005
32712: DTS: Transform Data Task with ActiveX
32713: Searching records with 'like'
32714: Select statement Help
32715: Import large xml document into sql server 2005
32716: More Efficient way to Concat Rows
32717: Trasform columns to rows
32718: How to determine default values of a field during runtime
32719: get fields for Process Info
32720: JAVA Total
32721: SELECT statement help needed
32722: transfer data from sql on WINNT to SQL on 2000
32723: SQL statement help please
32724: What is the impact of implementing expected Rollbacks
32725: transfer data from sql on WINNT to SQL on 2000
32726: Still struggling w/ LAST transaction date!!!
32727: MSDN SQL 2005 versions
32728: using like keyword with variable
32729: MS SQL Query statement.
32730: Database design problem
32731: Modify data structure
32732: Return value
32733: SMO SqlExpress Create Database Datafile
32734: DISTINCT MonthName for a lot of dates....
32735: Cancel Trigger
32736: Roll back database
32737: Product Price Range Query
32738: selecting from a 6 month date range
32739: Can I use varible here in Stored Procedure?
32740: delete BLOB objects
32741: select statement question
32742: Books for Yokun
32743: Difficult question
32744: Use trigger to check data in another tablw
32745: Debug Stored Procedure
32746: Sum() And Nulls
32747: ActiveX DTS with Recordsets
32748: Retrieving grouped data
32749: What is Table Spool
32750: Remote server delete
32751: schedule
32752: Dynamic Stored Procedure
32753: XML Schema
32754: REPLACE SUBSTRING BETWEEN TWO CHARACTERS
32755: REPLACE SUBSTRING BETWEEN TWO CHARACTERS
32756: parse ???
32757: What is wrong ???
32758: What is bookmark lookup
32759: How to work with extra columns when using bcp?
32760: Q: complex SELECT statement
32761: TOP and UNION
32762: Delete Excel data using OpenRowSet
32763: Using Clustered Index
32764: Is it best way put all the validation rules on insert/update/delete stored procedure?
32765: How can I force some data maintenance statements whether the transactions success or failure?
32766: sql query trivia
32767: how do I check if constraints exists?
32768: Dynamic WHERE & Dates
32769: Full-Text search indexing HTML content
32770: Chinese character in the field (Sql 7)
32771: Need some with query
32772: A question about execution plans
32773: error Multi-part identifier
32774: Call Stack Level
32775: Profiler and SQL Express
32776: Weird problem: Cannot run Left Outer Join properly - SQLserver 2000
32777: Adam rocks..
32778: len of string
32779: updating column
32780: DECLARE CURSOR problem
32781: 2005 Pivot Question - Not returning data..not sure what i did.
32782: is this a lot
32783: Query Help
32784: which is better...
32785: help with joining on an index
32786: Run 2nd SQL in stored proc
32787: Table Hints
32788: SQL Execution order
32789: Using set theory in SQL Server 2005
32790: with(updlock) - How many times on same table in single update?
32791: Is there alternative to T-SQL USE <dbname> where <dbname> is varia
32792: query multiple files
32793: Does RAISERROR store values for @@ERROR?
32794: Query to extract number of duplicates
32795: howto update from another table
32796: Complex delete query
32797: Accessing WMI using sp_OACreate
32798: COUNT of datediff
32799: passing \ as a parameter to a function
32800: error in calcualting week nr over DATEPART
32801: DateName always return DatePart!
32802: Range Scan vs. Table Scan
32803: 9KB of update statements FILLED with NOLOCK hints
32804: query metadata within trigger scope
32805: Anyway to quick ntext Search
32806: Composing a date from date parts
32807: Delete Query ?
32808: Using a cursor
32809: Connection Error
32810: Case Statement
32811: Viewing the Statement
32812: nested XML output with several JOIN statements
32813: Regarding Labels
32814: Hard times with SQL server. sa can not be found.
32815: transactions
32816: Simple Trigger using VB.Net 2005
32817: Slow 'union all' in view, OK in sql batch
32818: reusing calculated columns in query ?
32819: Arithmetic Overflow Error
32820: Complex T-SQL
32821: Read value of a batch variable inside sql?
32822: ADSI OPENQUERY and MultiValued Attributes
32823: Dynamic Query View?
32824: Fumo?
32825: 2 Characters missing from some information
32826: Space at the end of Column name Persists
32827: ADO Connection.OpenSchema works differently with SQL Server 2005
32828: Saving an attachment from mail using XP_READMAIL extended stored p
32829: Difficulty outputting in right format. -Tricky one
32830: SUM VALUES BY DATE
32831: UK postcoe and tel no constraints
32832: Update Error - Using Convert Function
32833: Returning Null Values
32834: SET DATEFIRST 1 in a View
32835: XML Export using BCP
32836: varchar size
32837: CASE statement
32838: SP_OACreate and WMI
32839: Printing to the message window
32840: osql and line spacing
32841: Multiple count(*) on same column Same query?
32842: Undocumented Error
32843: String Sniffing...
32844: Return multiple values from udf
32845: column reference error
32846: Users created 6 hours into the future...
32847: Dynamic insert into table with datetime and int columns
32848: Dynamic insert into table with datetime and int columns
32849: OpenDataSource with Excel
32850: Restore of Database Terminates
32851: SQL Server 2005?
32852: Division in Query - Simple, but Lost...
32853: Random question
32854: Return data from a temp table
32855: Sql Agent cmdExec Paths
32856: SQL for FIFO calculation
32857: Security issues when using Service Broker
32858: sp_addlogin in trigger
32859: Error 4422
32860: SQL 2005 Pivot
32861: Hoe to Find Duplicate values??
32862: Need help creating XML
32863: Debugging SPs and triggers in VS2005
32864: Error handling in Stored procedure
32865: help on Date handling ?
32866: Problem to fetch a row from table
32867: Executing trigger
32868: REcovery model for a backup/restore operation
32869: Problem with Bulk insert
32870: Identifying the logical files before restoring database
32871: Transaction to be used or not
32872: Debug sp from Business Intelligence Dev Studio?
32873: @@FETCH_STATUS loops?
32874: dts import wizard
32875: Creating UDF In SQL Server 2005?
32876: Creating UDF?
32877: Source Safe and Stored Procedures
32878: Remove records from result based on record in another table
32879: CREATE TRIGGER gives error 21001
32880: Need SQL statement help!
32881: INDEX
32882: return the last 65 distinct MAX date records
32883: SQL Equivalent of Access's MAX & IIf
32884: SQL Profiler Access without being sa
32885: SQL 2005: Table variable problem
32886: Easiest way to determine if only client tools are installed?
32887: date ranges question
32888: Size of Record if fields are NULL?
32889: Trigger? Function? Bestway
32890: Restoring a database on Linked server
32891: Getting the ID from an insert
32892: How to convert one column dataset to multiple columns?
32893: Best Practices for Period table Month and Quarters
32894: How to install Visual Stuidio Template for SQL 2005 Database proje
32895: SQL statement help needed!
32896: How to this with SQL
32897: MSDE to SQL Server 2005 Express
32898: 2005 and Triggers?
32899: Boolean data type
32900: Current Year