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

view full version: back to formated view

31151: trigger on column
31152: how can I prevent all jobs start up at the same time?
31153: NULL IN JOINS
31154: obtain first and last occurance of contiguous blocks of data
31155: Redeploying CLR UDT
31156: Can a multi-column index be used for single-column searching?
31157: Client connectivity to SQL Server 2005
31158: Client connectivity to SQL Server 2005
31159: First INSERT in the transaction is not being committed
31160: service account
31161: ignore duplicates from joined tables
31162: ID Creation/ASP/SQL Server
31163: Sql Server Express and VS2003
31164: Calling sp_StartJob again when the job is running, what would happen?
31165: month and 2 digit year
31166: Detaching & Attaching Database
31167: Getting a stored procedures return value -- URGENT !!
31168: How to drop sql server object?
31169: Date
31170: There are some bugs for Management Studio.
31171: A little advice about locks with SQL 2000
31172: Access SubQuery Help Needed.....................
31173: create new table based on union of range data
31174: Connection closed durring application execution
31175: DateTime variables
31176: [OT] Job Posting
31177: duplicate number
31178: Cursor loop is broken
31179: sql profiler vs. query analyzer
31180: xp_SendMail & Char(13)
31181: Table load with duplicates on Primary Key in import file
31182: Check the continuity of dates
31183: SQL Server Instance Name
31184: identify 'next' pk value
31185: INFORMATION_SCHEMA.SCHEMATA does not return all rows on SQL 2005
31186: Alter column add constraint unique
31187: Function Returns Data Type Error
31188: Help with relational set division, please! Good challange!
31189: can this query be cleaner or written better?
31190: Most efficient way to write this
31191: Int vs tinyint
31192: finding length of text field
31193: Table grows at extreme rate but is not full
31194: How to send variable to Oracle in a distributed query
31195: xp_SendMail and CHAR(13)
31196: Update fails after IF EXISTS
31197: Tracking Employees LogTImes
31198: Case stmt
31199: JOIN with table valued function very slow
31200: create other index
31201: Link Server settings
31202: OPTIMIZER LOCK HINTS
31203: Select most recent date time
31204: A new group for statisticians has been formed. Request to join
31205: sysname
31206: trigger
31207: Managing DTS Programmatically
31208: What Are The Issues With MS Access Client to SQL Server DB
31209: Tool to find sqlserver and code dependences
31210: variable TOP value?
31211: trouble using a user defined function
31212: UPLOADING A TEXT FILE INTO A TABLE
31213: Performance - Joins vs Filters
31214: Help - I need a book on SQL
31215: Column X is same, column Y is different?
31216: Property QuotedIdentifierStatus is not available for UDF.. Help?
31217: Database backup stopped and Can't Kill SPID
31218: Imbedded subroutine prefix error
31219: Enterprise manager compatibility
31220: DELETE Trigger
31221: FOR XML performance question
31222: NULL in Joins
31223: extract non-unique records from a table
31224: default column value
31225: Memory problems using Sql Server 2000
31226: Installing Reporting Services on Win 2003 Server with error message "The key 'ReportingServices.WebServiceUrl' does not exist
31227: Rolling Back deleted Data
31228: strip nulls out of image column
31229: Using ADO to duplicate records.
31230: Median Calc
31231: Local Temporary Table Bottlenecks?
31232: Stored procedure creation terribly slow until reboot
31233: SQL Server Management Studio Express
31234: designing history tables
31235: Results of EXEC into table?
31236: Indexed Views in Enterprise Edition...?
31237: multiple inserts in transaction
31238: Need some feedback. What do you think about storing my data like
31239: Joing two tables but avoid cartesian product
31240: Dynamic SQL Column Total Help
31241: Datetime constraint: is there a better way to do this?
31242: Unique transaction identifier
31243: Calculate Median
31244: make 1 record with Union statement
31245: Self Referencing Table question.
31246: Add a field
31247: Problem - Division between floating numbers
31248: external/unsafe access assembly in SQL 2005
31249: SQL 2005 Compatability in a View
31250: Executing Dynamic SQL with update
31251: Trigger Question in Sql 2005
31252: Locking while updating
31253: Query with "not null"?
31254: Select whole numbers in decimal field
31255: getdate
31256: Views and indexes
31257: Question about storing a tree in the database
31258: Having problems with distinct and count
31259: update query syntax question
31260: simple insert of strings
31261: Avoid Looping / Cursors. Help with Statement.
31262: If exists from within a select statement.
31263: SQL2000 can a generate an incremental row #?
31264: Computing several columns for each row in source table and joining to get result
31265: SQL 2005 Default instance does not show up in server lists
31266: Complex Query
31267: Division query
31268: adjust my code
31269: SQL 2005 and weird SP performance problem
31270: avoid using cursors....
31271: IsNumeric decimal value returns false (NOT the "dot"-issue)
31272: Database Size
31273: Pivot-related query
31274: Query two databases on same machine
31275: Predefined sort order
31276: Field locked
31277: It's unbelievable and unacceptable
31278: SQL 2000 SP4
31279: SQL 2000 sp4
31280: outputing the results of a parameterized stored procedure to a tab
31281: outputing the results of a parameterized stored procedure to a tab
31282: x64 SQL and DBLIB
31283: Can I determine insert order without an explicit field
31284: Help Required - Selecting the last transaction for a client..
31285: ADO.Net 2.0 Bulk copy vs SSIS
31286: Missive
31287: Something easy for you SQL gods, I'm sure...
31288: Allocate by assets
31289: really large stored procedures
31290: Rolling Totals
31291: Pulling Random Distinct Percentage
31292: CREATE TABLE without columns
31293: SQLAgent Job New Step -- app database not showing
31294: VB Script + SQL DMO Error
31295: Using the Query Anaylzer debugger for a DATETIME input
31296: Should I use a cursor?
31297: Probability table
31298: uniqueidentified
31299: hunting down deadlocks
31300: Elegant alternative to table-valued function
31301: A new group for statisticians has been formed. Request to join
31302: Call function from a procedure and assign return value to variable (sql server)
31303: Union clause
31304: SQLDMO: How to enumerate DB Maintenance Plans?
31305: Primary Key Violation Constraint, how to debug.....
31306: using exec stmt in select query
31307: Insert Error
31308: Escaping the Escape characters [ ]
31309: SQL WHERE clause spanning dates
31310: PRC file extensions in MSSQL Management Studio 2005
31311: sp_configure "user options" and @@options function
31312: Un-encrypting Stored Procs
31313: Partitioning using Date - TimeKey (Ref to another table) column
31314: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACT
31315: SQL Injection - Table created t_jiaozhu
31316: What is the version of sql server
31317: Using Two motch memory
31318: SQL Distinct Value and Order by some Field......
31319: Extracting info regarding ETL's
31320: How Can I Get Client User Ip Number
31321: How to create view or stored proc in another db using stored proc?
31322: An interesting Question on DBDesign
31323: How can I make SQL Server 2005 automatic generate scheme script for backup everyday?
31324: Send Email Message using MS SQL Server
31325: How do you determine the level of fragmentation on a heap?
31326: need help to know when the long run qurey stoped
31327: Can I Clear SQL Event Log
31328: Create table
31329: Newbie Question - Go easy
31330: getting overflow error doing avg(size)
31331: Weekly timecard display w/MSSQL2000 & Classic ASP
31332: nocount returns rows affected
31333: SQL Server 2005 Cost?
31334: ASC / DESC based on CASE
31335: Comparing one record to the next
31336: Bulk Insert fail for TempTable (bulkAdmi)
31337: Access SubQuery Help Needed.....................
31338: Can't install Sql Server Express
31339: How to set and query related records on the same table as groups postings
31340: Convert to Number IF it is a number
31341: Error converting Varchar to Int - SQL 2000
31342: Switch to SQL over Access?
31343: reusing temp table across different procs
31344: Filter by concatenated field
31345: Unknown SQL Crash!
31346: Can I index a table in UDF ?
31347: User defined Function much slower than stored procedure
31348: Updating duplicate records and then deleting one of the duplicates
31349: How To Remove Leading Zeros
31350: adding new textboxes by pressing a button
31351: Reserved words
31352: user defined function returns weird results
31353: Question about style
31354: money data-type query
31355: Query to return duplicate records
31356: Updating the newest of several records
31357: Determining check constraint
31358: REPLACE ALL
31359: ISQLW in 2005?
31360: Timestamp and INSTEAD OF TRIGGER
31361: building a report - problem with nulls in math
31362: ALTER TABLE (ADD column question)
31363: Creating trigger at runtime
31364: FOR XML vs. ADO
31365: Book recommendation
31366: Syntax error converting from a character string to unique identifier
31367: SQL Cache Invalidation
31368: ... not in ... what is the fastest way ?
31369: Uninstall .Net Framework
31370: How to drop all primary key of all tables in DB?
31371: how to get compatibility level of a database?
31372: setting a field filter to all records
31373: Can SQL Server 2000's Select statement assign multi-variables from Table?
31374: Please help me with a query statement!!
31375: Generate BCP data file with money columns using C#?
31376: Dynamically select tables
31377: export to XML
31378: can primary key be derived/created from 2 columns?
31379: Table design advice for wildcarded maximum value.
31380: Alternative to sp_processmail for processing emails
31381: Execute SSIS package via sp
31382: How Alter column name of table?
31383: Default values do not get created in SQL 2005 tables
31384: Write ' in T-SQL
31385: Table xml schema
31386: Too many fields in one table ??
31387: Joining fields
31388: Transaction Log Filling
31389: Create new sql server login
31390: BULK INSERTing UNICODE data with format files
31391: TSEQUAL
31392: size of result
31393: No of fields in a table
31394: Capture Auto Increment Value
31395: AutoNum + Exception
31396: CLR Assemblies
31397: SBSMONITORING??
31398: online sites
31399: Multiple file import SQLExpress
31400: Sending/Using NULL in sp
31401: How to force SQL Server to handle all numeric types as doubles?
31402: time out
31403: Date format reloaded
31404: trigger.
31405: why deadlock?
31406: The case of the inadequate case function
31407: Appending Text to a SQL Text Data Type
31408: How to fetch AutoANSIToOEM, RegisteredOrganzation, etc. in SQLServer?
31409: SELECT Min Date
31410: T-SQL 258 XML Iteration Boundary?
31411: SELECT INTO PROBLEM
31412: MD5 Hashing rows?
31413: SID to dotnet SecurityIdentifier
31414: Cursor is the only choice?
31415: insert a un-ordered data to a clustered indexed column, what would happen?
31416: Union duplicates
31417: Storing Richtextbox data In Sql
31418: need to know the detail about cursor.
31419: Stored Procedure Output Parameter Woes
31420: CAN'T SOLVE SELECT GROUPING WITH MAX FUNCTION
31421: T-SQL does not support breakpoint Conditions
31422: Scripting of database objects in SQL 2005
31423: Case in Join
31424: how to install multiple instances of Reporting Services?
31425: Design Question - SQL 2000 to 2005 App Upgrade (CLR?)
31426: Field value determines whether there is extra info that should be held about that record
31427: Picture insert
31428: five connection limit
31429: Profiler event class question
31430: getting per case info from 1:n related case and log table fast
31431: sql statement formatting
31432: Using input parameters differently for different values
31433: Mapping from flatfile to SQL server database...
31434: AntiVirus Software
31435: Log File Error
31436: handling parameters that could be missing
31437: SQL Server locking
31438: Query
31439: How to get the Column Name of primary key of a table?
31440: Trouble using sql IN statement with list of datetimes
31441: network error
31442: Use of NULL and DEFAULT
31443: Need to Execute SQL Script after SysPrep or after first boot
31444: Using Case Conditions in WHERE clause
31445: SQL Server :
31446: Select Calculations
31447: Developing CLR Objects - Visual Studio Requirements?
31448: Record locking within a stored procedure
31449: How to decide whether trigger is a good idea?
31450: SCHEMA - primary key - SQL problem
31451: Transform while Importing Data
31452: if condition and batch statements
31453: NewBie Question: SQL Server AddNew and ASP
31454: Question about the best way to relate some tables.
31455: dts to update table
31456: Service Broker Error : Cannot find the remote service
31457: Help with cursor and decimal values
31458: data import question
31459: Long running DTS package
31460: bulk insert problem
31461: design question
31462: compare '002' and '00²'
31463: Limitation of sql standard
31464: Database Table special permissions
31465: Determine Nearest Day
31466: Help with xp..sendmail needed!
31467: Deadlocks
31468: Help with stored procedure!
31469: Row based security
31470: diff between CPU time and elapsed time?
31471: interval dates
31472: Evaluation of conditions
31473: Suggestions / direction on learning SQL Server 2005 ?
31474: SQL Server 2000 and SQL Server 2005 - Installation issues
31475: how to write query for rownuber in alphabet
31476: For Xml Auto Help
31477: Block row from been updated
31478: column data types?
31479: complex and large triggers
31480: SSIS 05: load excel data from sharepoint doc library
31481: Apostrophes and Dynamic SQL
31482: Table design question on LARGE table
31483: help in writing dynamic sql query
31484: Query help
31485: inserted in dynamic query
31486: linked server and pipe delimted file
31487: If Else If condition failing
31488: producing a date time report in SQL/DTS
31489: Execution Plan
31490: Using a Join Twice to the Same Table Within a Select Statement
31491: Indexes & "OR"
31492: Best Data Type for a Tracking ID?
31493: Using Uniqueidentifier in a string
31494: Any harm in adding a primary key...
31495: Server Memory usage\Performance problem
31496: Problem executing stored procedure to update all rows of a table
31497: Saving Store procedure on table
31498: INSERT multiple rows with same data
31499: listing non system databases
31500: detect and solve deadlocks