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

view full version: back to formated view

26951: ORDER BY Aggregate and Grouping
26952: Not returning @@Identity
26953: Contraints
26954: Missing data from restore
26955: select and update statements in a while loop is not working proper
26956: Between date problem
26957: requesting query optimization help
26958: Types of SPROCs
26959: script error checking
26960: Is there a way to escape a single quote?
26961: Need help with a Stored Proc. - using BEGIN TRANSACTION and END
26962: Physical File Access
26963: bulk insert which check if record exists
26964: Invalid connection string to MSDE 2000 database
26965: Determining Cascading Delete
26966: About transaction involving table variable
26967: Nested Transactions
26968: Debugger question
26969: Web services question
26970: Transfering MS SQL database to MySQL
26971: Best way to generate next sequence number of a table.
26972: arithmetic operations with money and real
26973: Reverse engineering a database in visio
26974: Wisdom behind using fully qualified table name in field name
26975: Transaction model
26976: 24 Hour
26977: SQLOLEDB with Server=(local) on SQL Server 2005
26978: UPDATE not working
26979: Table information
26980: Results of stored procedure into a table variable.
26981: Very basic question
26982: Browser time out: when executing a DTS package
26983: Query with union no longer updatable in SQL 2005
26984: Do we still have SQLXML in SQL 2005?
26985: SELECT with COMPUTE?
26986: SQL Server 2000 bug ? INDEXKEY_PROPERTY
26987: c# 2005 express edition install difficulty
26988: Creating Dynamic Data Flow Task
26989: group by and sum
26990: select question
26991: SQLXMLBULKLOAD don't fire trigger
26992: Urgent - Calculating Percentage Input fields per record !
26993: Check if record has dependencies
26994: Trying to understand transaction model
26995: Creating table with Identity property
26996: Problem in between clause
26997: Efficiency problems using PRINT in CURSORs
26998: Match timed events
26999: SQL2005 joins and wrong execution plan
27000: DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
27001: how to check whether the sql server is up
27002: Composite index design question
27003: database design:dnamically build where clause
27004: How to simplify my storeprocedure
27005: Group by weekends
27006: Help with trigger
27007: Join table with a UDF?
27008: can't update table owned by dbo with impersonation account
27009: Interface
27010: Question about error handler
27011: SQL Server 2000 xml solution
27012: Call a Dll from Stored Procedure
27013: How to make argument/parameter optional in UDF/Trigger?
27014: how to create function which eval expression
27015: sp_OAMethod Returns Empty String
27016: Pick TOP 1 row per GROUP BY group
27017: How can I consume webservices from MS SQL 2005
27018: Can I build WHERE clause dynamically in a Stored Procedure in SQL Server 2005?
27019: combine data in one row?
27020: How to copy a table including all constraints,... to same database
27021: Newbie Select Problem
27022: Dynamic Where clause
27023: Stored prodedure OUTPUT parameter
27024: How can I use stored procedure's recordset output into simple SELECT statement?
27025: Static variable in SQL procedure ?
27026: SQL-DMO broken!
27027: Rowcount reporting incorrectly...
27028: Synchronizing data between sql 2000 and sql 2005
27029: looping with SQL
27030: Bulk Insert
27031: creating xml and passing it on.
27032: problem with datepart ....
27033: What is the cost Sql Server incurs by using the SqlDependency class?
27034: Isolation Levels
27035: ex stored proc and COM objects
27036: Creating a table from a view
27037: Having problems getting stored procedure to work.
27038: Select this and last years data to show side by side
27039: Challanging task, for fun - answer two questions from given data!
27040: Looking for a generic list
27041: Turkish characters are not displayed correctly on production server
27042: Any way to avoid using a cursor for this?
27043: Error (8626) while inserting record into table with text field and which is the base for indexed view
27044: How to set sql server setting let to set null value when a empty string (zero length) set to column?
27045: ALTER TABLE ... IDENTITY question....
27046: Migrating to SQL Server!
27047: Truncating vs. Rounding
27048: snapshots on sql25k
27049: HELP ME!
27050: HELP ME!
27051: A question of design
27052: PID in VHDL code
27053: Maintanance job fails
27054: Maintanence job fails
27055: SQL Server Agent
27056: values of Columns in two different table ---presentation
27057: values of Columns in two different table ---presentation
27058: Values of two columns in two different tables--presentation using select
27059: Values of two columns in two different tables--presentation using select
27060: Need help with stored procedure
27061: Creating a Backup Server software
27062: SQL 2005 Books Online and synchronize feature
27063: Can SQL Server 2005 using C# make a SOAP call do set operations?
27064: DTS Parsing Delimited Record
27065: Database Backup And Transaction Log - SQL Server 2000
27066: about MSSQLSERVER run as LocalSystem
27067: To find the number of occurrences
27068: query
27069: Calling a Stored Procedure inside mysql.
27070: New One Here - Dont Laugh
27071: User Defined Functions and 4-part names
27072: DTS and "SQL Server does not exist or access denied"
27073: -2147217887 Error when sending to SQL 2005
27074: Extract data from 350 seperate Excel Files
27075: Is this a permissions issue?
27076: Import & Delete Rows
27077: WHERE NOT EXISTS STATEMENT
27078: SQL Query Help
27079: Help with a loop.
27080: Strange Maths
27081: Advice
27082: Connecting to DB2 / AS 400 from SQL Server
27083: Suggestion Sought
27084: How to determine when the last successful full backup occurred?
27085: serial number in result of select statement
27086: ISQL & strange charcters
27087: Searching and replacing substrings
27088: Extended Stored Procedure <-> CLR
27089: Compare Permissions Between Databases
27090: Resubmit: "Trouble connecting to remote db using .net data provider for Sql Server"
27091: Inserting via a view
27092: DBCC CheckDB
27093: Insert into Problem
27094: Extended Store Procedure Query
27095: How to create a column names using results of query?
27096: Evaluating @@error
27097: Is it Possible to Concatenate a Text Column of a Table
27098: Using @ within column name of a table
27099: lop deleted row
27100: Best practice - triggers and SP
27101: How to order??
27102: Creating SQL triggers thru managed code
27103: how to enable auditing in SQL (or how to maintain session state variables)
27104: List out duplicate names only
27105: ; in T-SQL
27106: Query Notifications
27107: PIVOTing
27108: DTS Problem in stored proc
27109: Primary keys lost after DTS
27110: Calculation including previous record value
27111: Community Question: Fastest update path for experienced SQL Server 2000 developers.
27112: trimming question
27113: Please help! Database won't update
27114: Log not needed
27115: Performance difference over "not exists" and left join?
27116: Why is this view not indexable ?
27117: change database collation
27118: Table Names in 2005
27119: Flat File Prob in SSIS
27120: Last name, first name issue
27121: Trouble connecting to remote db using .net data provider for Sql Server
27122: parse xml and load into DB
27123: view index disappears
27124: Need help with stored procedure
27125: @@FETCH_STATUS
27126: How to perform this unique contraint?
27127: Removing Identity property SQL2K5
27128: indexed view
27129: Bulk Insert
27130: vb.net calling SQL server does not return all rows under Windows XP
27131: Fill factor
27132: global vars in script files ?
27133: Help with datetime
27134: Calculating Yield
27135: weird TSQL question
27136: Alias a column that has 3 values into 3 columns
27137: Move Data from Schema to schema
27138: Track Database Size
27139: Data Integrity Question
27140: osql output file has leading whitespace
27141: SQL Error - substituting ?
27142: Problems with stored procedure
27143: Determine if a trigger exists.
27144: identity set to off for now
27145: count occurrence of character in a field using SQL
27146: Bulk Insert
27147: Count (Distinct ??
27148: How to check whether in distributed transaction or not?
27149: Using Sql 2005 Management Studio for SPs
27150: Is it possible to merge date from 2 or 3 tables into a View?
27151: raise message from Update Trigger from External App
27152: Importing Data
27153: BCP help, or alternative
27154: Q: on "uniqueidentifier"
27155: Linking to FoxPro files from SQL Server
27156: Problem with XQuery Syntax
27157: Need Help to create insert procedure
27158: Arabic and Far East text saving as ???
27159: Problem with SQL Statement and JOIN
27160: Need help with T-SQL in Sql Server 2005 to build a WHERE clause
27161: Time/Calendar best practices
27162: Can I release temp SQL Tables?
27163: Copy a table
27164: How to add message to sql server log?
27165: sql 2k insert into error
27166: Microsoft.SqlServer.* assemblies: are they redistributable?
27167: Determin start and end date of a month
27168: Insert more then one records at a time.
27169: BCP into image columns
27170: Datetime and Indexes
27171: DTS execute package task
27172: DTS execute package task
27173: I cannot explain the difference in execution plans.
27174: SQL Server 2000 Stored Procedures Handbook Read it for Free!
27175: Microsoft SQL Server 2000 High Availability Free Preview eBook5.co
27176: INNER JOIN key words
27177: Syntax error converting the varchar to a column of data type int.
27178: how to improve the Performance
27179: Syntax error when SELECT in parenthesis
27180: Match dates in two tables, combining historical events
27181: Create a new table from 2 diffrent tables
27182: Parsing data from strings
27183: Foreign key integrity when combining two SQL Server databases
27184: can we increment the column --autimatically---is there any possiblity with tiggers
27185: Database design
27186: why is a cursor faster than insert @table_name?
27187: create a Maintenance plan
27188: Where is the execution plan
27189: Scheduling a DTS package without admin privileges.
27190: Testing For File Existence in Transact-SQL
27191: Passing paramater as type date to stored procedue
27192: Order on Second Select of Using Statement
27193: DateTime Calculation
27194: OPENXML Invalid column name error on update
27195: Reporting the space used of an individual logfile from a single DB.
27196: Can I do this without a cursor?
27197: Looping vs. Set operation - question
27198: Changing the datatype of a column which is part of a PK
27199: Create table as I need it, how to reference in query?
27200: help with a query
27201: SQL 2005 login
27202: GROUP BY Question
27203: Problem running SSIS package from sp
27204: How to check whether I am in distributed transaction or not
27205: Prelogin Packet structurally invalid
27206: help with index
27207: Replacement for SETUSER
27208: Transaction log
27209: Simple join
27210: Limit query results
27211: error handling
27212: Profiler Question
27213: Help with Stored Procedure, Taking too long to run...
27214: do process
27215: Calulated Fields vs UDF's
27216: Automating a time-sensitive query
27217: Oracle vs. SQL Server schema compare
27218: Determining single-column candidate keys
27219: How to create an Worldwide Opened Webservice by SQL2005?
27220: Exec a StoredProc from in a Select statement that returns mult. ro
27221: Generate Scripts without the Collate statement
27222: Summing a column
27223: Data from previous quarter
27224: can you invoke com and dotnet components from psql
27225: Formatting Data
27226: Visual Basic
27227: How to detect an EndPoint is existed or not?
27228: joins
27229: sql server localhost installation
27230: How to do this
27231: send and return value from storedprocedure
27232: Access denied on ScriptTransfer call
27233: Script : Clear connections on a database
27234: Problems connecting to SQL 2005 DB on server
27235: Log space utilization information
27236: Buying a car without a driver's seat
27237: Bulk insert
27238: problem in fulltext search in MS SQL Server
27239: How to change QUOTED_IDENTIFIER for table?
27240: How to design this?
27241: Converting Access database to SQL Server w/ flat files
27242: How to move a table to different schema in SQL 2005
27243: Delete formatting from strings
27244: FTP help
27245: Copying column into another
27246: Connection - MSSQL - HOST_ID
27247: ABS () and dates
27248: Materials Needed
27249: SQL Syntax Check
27250: DMO Enumerating SProc Parameters
27251: How to get ID for new record
27252: Proper use of Inner Join with nested select?
27253: How to include total in query?
27254: slick query question
27255: PIVOT problems
27256: Get Missing Dates
27257: Possibly simple query but I'm not good enough to fathom it!
27258: SQL Query Analyzer and Column Names
27259: display FLOAT datatype with commas?
27260: Linked server to Oracle - error on NVARCHAR2()
27261: sp_recompile on a table - are sprocs truly recompiled?
27262: Beginners SQL Query i cant suse out
27263: CHECK constraint
27264: Cycles or multiple cascade paths
27265: sql express - get the data out of here!
27266: Date Conversion
27267: Query Evaluvation and tempdb
27268: Service Broker service
27269: Query Help, PLZ
27270: Load Data from Flat File to Oracle with SQL Loader
27271: Plan not using Index
27272: SQL Query Help
27273: Is ISO/IEC 9075 bad?
27274: INNER JOIN on 3 Tables need distinct rows
27275: SQL 2K5 Query Builder
27276: =?Utf-8?Q?Store_Procedure_return_error_wit?=
27277: simple query help
27278: Problems converting Access UNION query to SQL
27279: update from join slow
27280: Divide by Zero
27281: compare 2 strings
27282: bcp Question
27283: Unable to access perfmon counters remotely
27284: Problem with BULK INSERT in SQL Server 2005 Express
27285: SQL2000 Performance question
27286: problem in fulltext search in MS SQL Server
27287: Complex Query!
27288: SqlServer 2000 - Identity problem
27289: sargable vs non-sargable queries
27290: About Sql Server 2005
27291: inserting UTF-8 values into SQL Server 2005 tables
27292: Cannot return results of temporary table
27293: Financial Query Help
27294: What is .NDF file?
27295: DTS Sproc REturn Value
27296: SPs vs Dynamic SQL
27297: How to lock a particular Row in a sql server
27298: trigger status
27299: disable all triggers
27300: Search value thru SP