TheMSsForum.com >> SQL Server Programming >> Archive Page 82 - The Microsoft Software Forum

view full version: back to formated view

28351: serial number in result of select statement
28352: ISQL & strange charcters
28353: Searching and replacing substrings
28354: Extended Stored Procedure <-> CLR
28355: Compare Permissions Between Databases
28356: Resubmit: "Trouble connecting to remote db using .net data provider for Sql Server"
28357: Inserting via a view
28358: DBCC CheckDB
28359: Insert into Problem
28360: Extended Store Procedure Query
28361: How to create a column names using results of query?
28362: Evaluating @@error
28363: Is it Possible to Concatenate a Text Column of a Table
28364: Using @ within column name of a table
28365: lop deleted row
28366: Best practice - triggers and SP
28367: How to order??
28368: Creating SQL triggers thru managed code
28369: how to enable auditing in SQL (or how to maintain session state variables)
28370: List out duplicate names only
28371: ; in T-SQL
28372: Query Notifications
28373: PIVOTing
28374: DTS Problem in stored proc
28375: Primary keys lost after DTS
28376: Calculation including previous record value
28377: Community Question: Fastest update path for experienced SQL Server 2000 developers.
28378: trimming question
28379: Please help! Database won't update
28380: Log not needed
28381: Performance difference over "not exists" and left join?
28382: Why is this view not indexable ?
28383: change database collation
28384: Table Names in 2005
28385: Flat File Prob in SSIS
28386: Last name, first name issue
28387: Trouble connecting to remote db using .net data provider for Sql Server
28388: parse xml and load into DB
28389: view index disappears
28390: Need help with stored procedure
28391: @@FETCH_STATUS
28392: How to perform this unique contraint?
28393: Removing Identity property SQL2K5
28394: indexed view
28395: Bulk Insert
28396: vb.net calling SQL server does not return all rows under Windows XP
28397: Fill factor
28398: global vars in script files ?
28399: Help with datetime
28400: Calculating Yield
28401: weird TSQL question
28402: Alias a column that has 3 values into 3 columns
28403: Move Data from Schema to schema
28404: Track Database Size
28405: Data Integrity Question
28406: osql output file has leading whitespace
28407: SQL Error - substituting ?
28408: Problems with stored procedure
28409: Determine if a trigger exists.
28410: identity set to off for now
28411: count occurrence of character in a field using SQL
28412: Bulk Insert
28413: Count (Distinct ??
28414: How to check whether in distributed transaction or not?
28415: Using Sql 2005 Management Studio for SPs
28416: Is it possible to merge date from 2 or 3 tables into a View?
28417: raise message from Update Trigger from External App
28418: Importing Data
28419: BCP help, or alternative
28420: Q: on "uniqueidentifier"
28421: Linking to FoxPro files from SQL Server
28422: Problem with XQuery Syntax
28423: Need Help to create insert procedure
28424: Arabic and Far East text saving as ???
28425: Problem with SQL Statement and JOIN
28426: Need help with T-SQL in Sql Server 2005 to build a WHERE clause
28427: Time/Calendar best practices
28428: Can I release temp SQL Tables?
28429: Copy a table
28430: How to add message to sql server log?
28431: sql 2k insert into error
28432: Microsoft.SqlServer.* assemblies: are they redistributable?
28433: Determin start and end date of a month
28434: Insert more then one records at a time.
28435: BCP into image columns
28436: Datetime and Indexes
28437: DTS execute package task
28438: DTS execute package task
28439: I cannot explain the difference in execution plans.
28440: SQL Server 2000 Stored Procedures Handbook Read it for Free!
28441: Microsoft SQL Server 2000 High Availability Free Preview eBook5.co
28442: INNER JOIN key words
28443: Syntax error converting the varchar to a column of data type int.
28444: how to improve the Performance
28445: Syntax error when SELECT in parenthesis
28446: Match dates in two tables, combining historical events
28447: Create a new table from 2 diffrent tables
28448: Parsing data from strings
28449: Foreign key integrity when combining two SQL Server databases
28450: can we increment the column --autimatically---is there any possiblity with tiggers
28451: Database design
28452: why is a cursor faster than insert @table_name?
28453: create a Maintenance plan
28454: Where is the execution plan
28455: Scheduling a DTS package without admin privileges.
28456: Testing For File Existence in Transact-SQL
28457: Passing paramater as type date to stored procedue
28458: Order on Second Select of Using Statement
28459: DateTime Calculation
28460: OPENXML Invalid column name error on update
28461: Reporting the space used of an individual logfile from a single DB.
28462: Can I do this without a cursor?
28463: Looping vs. Set operation - question
28464: Changing the datatype of a column which is part of a PK
28465: Create table as I need it, how to reference in query?
28466: help with a query
28467: SQL 2005 login
28468: GROUP BY Question
28469: Problem running SSIS package from sp
28470: How to check whether I am in distributed transaction or not
28471: Prelogin Packet structurally invalid
28472: help with index
28473: Replacement for SETUSER
28474: Transaction log
28475: Simple join
28476: Limit query results
28477: error handling
28478: Profiler Question
28479: Help with Stored Procedure, Taking too long to run...
28480: do process
28481: Calulated Fields vs UDF's
28482: Automating a time-sensitive query
28483: Oracle vs. SQL Server schema compare
28484: Determining single-column candidate keys
28485: How to create an Worldwide Opened Webservice by SQL2005?
28486: Exec a StoredProc from in a Select statement that returns mult. ro
28487: Generate Scripts without the Collate statement
28488: Summing a column
28489: Data from previous quarter
28490: can you invoke com and dotnet components from psql
28491: Formatting Data
28492: Visual Basic
28493: How to detect an EndPoint is existed or not?
28494: joins
28495: sql server localhost installation
28496: How to do this
28497: send and return value from storedprocedure
28498: Access denied on ScriptTransfer call
28499: Script : Clear connections on a database
28500: Problems connecting to SQL 2005 DB on server
28501: Log space utilization information
28502: Buying a car without a driver's seat
28503: Bulk insert
28504: problem in fulltext search in MS SQL Server
28505: How to change QUOTED_IDENTIFIER for table?
28506: How to design this?
28507: Converting Access database to SQL Server w/ flat files
28508: How to move a table to different schema in SQL 2005
28509: Delete formatting from strings
28510: FTP help
28511: Copying column into another
28512: Connection - MSSQL - HOST_ID
28513: ABS () and dates
28514: Materials Needed
28515: SQL Syntax Check
28516: DMO Enumerating SProc Parameters
28517: How to get ID for new record
28518: Proper use of Inner Join with nested select?
28519: How to include total in query?
28520: slick query question
28521: PIVOT problems
28522: Get Missing Dates
28523: Possibly simple query but I'm not good enough to fathom it!
28524: SQL Query Analyzer and Column Names
28525: display FLOAT datatype with commas?
28526: Linked server to Oracle - error on NVARCHAR2()
28527: sp_recompile on a table - are sprocs truly recompiled?
28528: Beginners SQL Query i cant suse out
28529: CHECK constraint
28530: Cycles or multiple cascade paths
28531: sql express - get the data out of here!
28532: Date Conversion
28533: Query Evaluvation and tempdb
28534: Service Broker service
28535: Query Help, PLZ
28536: Load Data from Flat File to Oracle with SQL Loader
28537: Plan not using Index
28538: SQL Query Help
28539: Is ISO/IEC 9075 bad?
28540: INNER JOIN on 3 Tables need distinct rows
28541: SQL 2K5 Query Builder
28542: =?Utf-8?Q?Store_Procedure_return_error_wit?=
28543: simple query help
28544: Problems converting Access UNION query to SQL
28545: update from join slow
28546: Divide by Zero
28547: compare 2 strings
28548: bcp Question
28549: Unable to access perfmon counters remotely
28550: Problem with BULK INSERT in SQL Server 2005 Express
28551: SQL2000 Performance question
28552: problem in fulltext search in MS SQL Server
28553: Complex Query!
28554: SqlServer 2000 - Identity problem
28555: sargable vs non-sargable queries
28556: About Sql Server 2005
28557: inserting UTF-8 values into SQL Server 2005 tables
28558: Cannot return results of temporary table
28559: Financial Query Help
28560: What is .NDF file?
28561: DTS Sproc REturn Value
28562: SPs vs Dynamic SQL
28563: How to lock a particular Row in a sql server
28564: trigger status
28565: disable all triggers
28566: Search value thru SP
28567: Two Questions, please help
28568: Help with time
28569: Syntax Highlighting Printing in Colour
28570: TRIGGER Question
28571: Rename Files
28572: Need Your Thoughts
28573: ORDER BY with SELECT DISTINCT
28574: Getting a count of items
28575: Loading new data - "raw formats"
28576: Help with Trigger
28577: Problem with ALTER TABLE in stored procedure
28578: Distributed Queries require access to administrator temp folder
28579: Problem With the SQL Statement
28580: Closing open sessions
28581: SQL physical stats
28582: Does SQL 2005 Support Chinese??
28583: TSQL For updating IDENTITY Column
28584: Web service hangs on ExecuteNonQuery
28585: SQL Server driver information
28586: Discrepancy between MS Whitepaper and BOL on updating stats and recompiles
28587: Discrepancy between MS Whitepaper and BOL in cache
28588: error: CoCreate of DSO for BULKIMPORTSTREAM
28589: IF Statement in WHERE clause
28590: BEGIN......COMMIT TRANSACTION
28591: Any way to make a stored procedure process asynchronously?
28592: Full Text Help!
28593: Nested Stored Procs w/Transactions
28594: New project - thinking of using Visual studio 2005
28595: Find a date that occurs every 2 days from a fixed date
28596: condense this working SQL into an algorithm
28597: Linked SQL Server Question
28598: Misleading SQL Exception?
28599: Draw many to many relationship diagram
28600: Taking out (CR) (LF) in a ntext data type
28601: Query help - employees and managers
28602: Assigning group number for millions of data
28603: How to get the whole DDL command from EVENT_INSTANCE
28604: Assigning group number for millions of data
28605: Transaction log question
28606: bind storedprocedure's parameters
28607: group Number for millions of records.
28608: with clause in 2000
28609: How can I do amalgamate 3 select queries and then get unique entries from the result
28610: SELECT a FROM x ORDER BY b
28611: xp_cmdshell
28612: List all the tables on a SQL Server
28613: function within view
28614: Coalescing data from more than 2 tables
28615: ingnore error for "Insert Into" query..
28616: ORDBY BY difference between two numbers
28617: calling stored using CDatabase
28618: drastic change in speed
28619: Inserting/updating rows from a delimited text file.
28620: Hierarchy
28621: Using automation on tables
28622: Can I access...................
28623: Missing results from stored proc
28624: One-To-Many return the many in a single row
28625: Does DATEADD change the datatype?
28626: SQL 2005 and Backups
28627: trouble with SSIS CPackage::LoadFromXML fails.
28628: using SQL-DMO to create maintenance plan
28629: If IN is an OR .. what would be the equivalent AND
28630: itzik ben-gan
28631: Need help with assumed fairly simple query
28632: Generate a GUID in MS SQL (t/SQL)
28633: how to save entity relationship diagram to a file
28634: month end date...
28635: SSIS - check for duplicate file in Script task?
28636: How ro append characetrs to auto-incrementing number
28637: Case conditional action
28638: Calculation
28639: Is not = to query
28640: How to check the existence of table in a specific file or in fileg
28641: How can i reprogram this? It's taking forever to run.
28642: problem retrieving correct max(date) row from this dataset
28643: how to UNIQUE my dataset results
28644: SPSS with SQL Server 2000
28645: Check if DB Constraints exist on a table
28646: pre-SQL 2005 XML workaround
28647: SQLCLR Assembly using SMO
28648: Server: Msg 208, Level 16, State 0
28649: Need to show zero's (0) when using coalesce.
28650: how do i authenticate into a Web Service through sqlclr?
28651: how do i authenticate into a Web Service through sqlclr?
28652: IDENTITY_INSERT
28653: Trying to accomplish using Self Join
28654: one control loop with Substring to correct first normal column violation
28655: Unique Distinct Records
28656: Get Last day of month.
28657: how to replace part of the value of a variable?
28658: Trim function
28659: Declaring default value for a variable
28660: DAO TableDef and SQL Server
28661: Constraints and Foreign Keys....
28662: creating a query sql
28663: Detecting Circular References.
28664: Copying Data to a File
28665: UDF and parameters
28666: Query by Time-Slices
28667: PLEASE PLEASE PLEASE HELP...[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.
28668: Help converting procedural VB code to SQL
28669: Calculate Time Off
28670: NEED HELP with sql server express and Windows Service !!
28671: procedures attribute in xquery
28672: Are declared primary keys necessary in SQL Server?
28673: Read DESCRIPTION from a backuped DB file in .Net
28674: SQL Syntax
28675: need spurce code for asp project
28676: Inner join of 2 in-line UDFs - why is it so slow?
28677: Removal of punctuation from fields
28678: SQL Job - Errors?
28679: adding two sum() 'ed values
28680: Workable limit on number of indices
28681: BCP
28682: fifo-syntax SQL
28683: Question about Insert/Update/Delete to return fail/success
28684: newbie question on indices
28685: Is it a bug of SQL Server 2000 SP4?
28686: Yet another (dead)locking question - is this possible???
28687: Newbie - Help required with Query (sample tables/data included)
28688: CHECK constraint
28689: Large value types out of row - objectproperties
28690: SQL CASE Check and Select
28691: Easy Transact SQL Question
28692: Return multiple dependent tables to a dataset
28693: Backup a database
28694: Selecet with Pading
28695: Cannot Connect
28696: BCP issue
28697: Question: Datalogger->Tables
28698: DBNULL is giving me a headach!
28699: [OT] How to know when it's time to goto sleep.
28700: Help with stored procedure or Trigger.