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

view full version: back to formated view

22401: TSQL to view a table's DDL
22402: Is there a way to use a function like Replace on a Text data type?
22403: Views and CTEs performance problem
22404: varchar(8000) data being truncated to 4096
22405: Calculaing # of days elapsed between each visit
22406: User's default schema
22407: SQL Server Job Notification
22408: Adding a space in a field
22409: Document management is SQL Server
22410: Another Instance of SQL Server
22411: SQL DMO Lists files severs too
22412: incrementing a counter in sql
22413: UPdating a table column with substring of another column
22414: Can't use Shared Memory protocol to connect
22415: scripts fails under ADO but no error returned.
22416: Easy question about combining queries
22417: merge two date ranges with overlap from two tables
22418: Default text case
22419: Query to values from two different tables with outer join
22420: Complex Query in SQL Server 2000
22421: Inner join of one table with two aliases
22422: Searching for Close Variations
22423: Sql Server 2005 Database mail error message.
22424: how to kick all users out of a database
22425: Dynamic SQL - Execute (@var1+@var2)
22426: Run Application Whit Parameter from Sp
22427: Run Application Whit Parameter From Sp
22428: SQLCMD / OSQL / ISQL - Having to hit enter and then type go again.
22429: FOR UPDATE
22430: SQL Parser
22431: how to: INSERT IGNORE INTO?
22432: show dependencies of a fact table
22433: URGENT !!! SELECT * returning different set of records
22434: SQL Server 2000 conversion of varchar to smallint
22435: TSQL bit manipulation up to 128 bits???
22436: dynamic sql in UDF
22437: Timeout sql+asp
22438: Installing a database
22439: Dictionary Sorting Weirdness
22440: Another Rounding question
22441: Returning only rows with highest version
22442: Displaying fixed value in columns in select query
22443: sql job @command param
22444: more complex many to many table query
22445: Backup of the database
22446: Arrays in stored procedures
22447: sp_detach_db Changes Security ERROR
22448: Date Query Problem
22449: access the active directory
22450: Restore database to default location on anohter server?
22451: sort a table with duplicate values
22452: SSMS05 : where are SS2K jobs ?
22453: Problem with xp_smtp_sendmail
22454: many to many table query
22455: How to design grouping of codes
22456: SP Metadata Help
22457: Display rowset
22458: Generate Script for TSQL Job Doesnt work
22459: File Import in SQL 2005
22460: Solution and question about indexes in SQL 7 vs. SQL 2000
22461: Question about Nested Sets
22462: Update linked server from local server
22463: self join problem
22464: Using carriage return with multiple tables
22465: HELP!!! - Problem with hints...
22466: Identity column based on other value
22467: Casing a name like McKinley
22468: ObjectSpaces?
22469: Importing Data from a File
22470: [BULK-OP-LOG]
22471: Joining the results of a select with a new select statement
22472: Table from varchar(max) field
22473: Date calculation and segmenting data by date interval
22474: Need help with intersection table query
22475: Problem with componentone component
22476: Best practice - parsing a comma-separated string
22477: Client-Side Database Mirroring Details
22478: selecting Max Date from 1 table
22479: Determine working days within a date range
22480: uploading file into SQL 2005 using .asp
22481: Problem with Stored procedure and execute_sql
22482: "0x80004005 Microsoft OLE DB Provider for ODBC Drivers" help!
22483: Questions Exam 70-431
22484: calculating a row's length
22485: Connection Pooling and Sql 2005
22486: Need help for transaction
22487: SQL Query Problem (Join)
22488: need good wayt to estimate a row size
22489: Cache
22490: Shot cut keys and free online tutorials in visualbasic6 and ms-sql server 2000
22491: Custered Index on Materialized View
22492: exclude row starting with int
22493: Last insert ID
22494: HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?
22495: Design Difficulties
22496: Help with upating a column with joined tables that use aggragate functions.
22497: Updating With Aggregation?
22498: returning random/distinct rows?
22499: looping comma seperated in a SP
22500: String concatenation
22501: Add this instance of SQL to Active Directory.
22502: How to list table names and field values
22503: Pros/cons going from SQL 2000 to 2005?
22504: Fixing code that returns Error 306
22505: Query for filtering by a field
22506: Need help with Query for Report
22507: Nested cursor using different server?
22508: Distributed transaction
22509: Nested CASE WHEN?
22510: SQL query problem, help needed please
22511: Search Question
22512: Getting Count of a Certain Field null versus not null
22513: Enforcing data integrity
22514: GOTO and Variable [SQL2K]
22515: SELECT INTO Fails
22516: Concatenate with a twist
22517: COALESCE with LIKE '%'
22518: How to get rid of 1> 2> 3> in the log file?
22519: which type of replication is the best to use in SQL server
22520: parse
22521: Select records by date after first of next month
22522: Triggers for update and save history
22523: Comparing date range within a range
22524: UPDATE FROM TWO DIFFERENT DATABASES
22525: 2005: using user define type
22526: How to find intersect (unmatched data) between two tables in ms sql server
22527: Aggregate function inside select statement
22528: Datediff & Timediff
22529: Tool for data generation(loading)
22530: how to reclaim unused space?
22531: no SORTING
22532: SQL Server 2005 -- Concurrenctly Updates
22533: Track changes in table fields
22534: Problem with Distributed Transaction
22535: Executing the Stored Procedure from command prompt
22536: Creating a unique user...
22537: stored proc to new table
22538: insert populating not null with trigger
22539: prefacing procs with sp_ still bad form?
22540: OLE Object
22541: Key Question
22542: Directory listing without xp_cmdshell?
22543: Usage of Object_id
22544: File New/Exists/Empty in SQL 2005 (SSIS or otherwise)?
22545: sql 2000 query help
22546: eliminating the use of temp tables with derived tables
22547: Database design question?
22548: Sql Variable for an inner select?
22549: Deadlock
22550: Filtered data from stored proc (noob??)
22551: Cool Ebooks Site
22552: sql server 2005 - WMI alerts
22553: MS Access Graphs
22554: help with sql statement
22555: Does Item fit into Box? (Tricky query for me)
22556: Limiting delete
22557: query design help
22558: best aproach advice...
22559: Service Pack 1 - CTP vs. RTM????
22560: function to return today at midnight
22561: insert using subquery
22562: Ordering chaos
22563: Need to get columns that are not NULL
22564: help me in select query
22565: Finding number of occurrences of string in record
22566: RE: Database design for multilanguage web application
22567: Combining INSERT & UPDATE Errors
22568: **case cluase**
22569: Sql 2005 ent. edition and previous backup files
22570: Strange performance problem with a UNION view - Please help
22571: Retrieve Query
22572: Retrieve Query
22573: how to convert int to time
22574: how to view date only from date/time date
22575: Block/lock issue caused by xp_sendmail
22576: Need Help : Connecting Locally
22577: Table ownership
22578: Sort order problem
22579: Text concatination
22580: The colour combination & flash of this site is gd.
22581: copy from ntext to nvarchar
22582: best way to get percentages
22583: Is it acceptable to...
22584: LEFT OUTER JOIN
22585: Transactions in PHP on SQL Server 2005
22586: MSSQLSERVER I/O error (bad page ID) detected
22587: Why VC++ ADO runs slow on WIN2003 cluster ?
22588: Best site for java and programmer
22589: stored procedure execution
22590: sql query copy database
22591: VS 2005 Standard Edition
22592: turn table sideways...
22593: querying multiple tables
22594: Triggers
22595: illegal characters
22596: Managing Multiple Servers
22597: subquery inside select to concatenate results ?
22598: SQL Query help
22599: CREATE TABLE Defaults have double passwords
22600: master table and child table andfield concatenation and loop records ?
22601: How to get the record created date?
22602: Get MCSE 2003 in 10 Days Without Exams(Pay After Check Results)100% Passing Gaurantee
22603: Returning records updated
22604: Red-Gate Log Explorer
22605: update all columns if exists, or do the insert based on pk
22606: Column permission being ignored by Access Form Combo box
22607: please help on count(distinct <expression>)
22608: SELECT INTO From Result Set
22609: No rows returned
22610: Insert using subsqueries
22611: Disconnected rowsets
22612: SUM() gone wrong.
22613: need help for a query
22614: Question for T-SQL Gurus
22615: Query returning wrong data
22616: Trying to avoid a stored procedure, is this possible?
22617: Query help
22618: sqldbtype.nvarchar in application but field is a varchar in database
22619: SET ANSI_WARNINGS OFF: can this be table-specific?
22620: Table design request for comment. (Help please)
22621: Debugging in SS2005 ?
22622: Check if file exists then delete it
22623: any idea how to decode hex time string '0x01 C6 56 B1 8C EA 40 00'
22624: Need help in writting query....
22625: Sql 2k UDF help
22626: Stored Procedure Problem
22627: VIEW's ORDER BY columns necessary in column list
22628: connect to oracle database
22629: Rights Question
22630: Vertical Partitioning Advice
22631: Running .sql file using C#
22632: decimal (28,2)
22633: Restoring Master Database
22634: real-world query - too difficult for me!
22635: Made for Software Engineers!
22636: opening SQL server 2000 MDF + LDF file from DVD
22637: Mask certain number of a Credit Card Number?
22638: DateTime Question (Again)
22639: How to execute a combined SQL character string in stored procedure
22640: How to do row level locking in SQL Server 2005?
22641: Which syntax is better in SQL?
22642: FOREIGN KEY that REFERENCES a server login for a database?
22643: Does CONVERT update the source data
22644: There is a good photo website
22645: ALMOST DONE, I THINK?
22646: Could we use query in From clause?
22647: SQL Replace If
22648: General design question
22649: How to take a BACKUP of a single or more Tables in Sql Server
22650: CLR out of memory
22651: SSIS data flow design
22652: Convert Query from access
22653: Backup SQL Server database to UNC
22654: sql query - sp
22655: loop though records and CONCATENATE results
22656: Grouping in Derived Tables
22657: Syntax for selecting all but one
22658: Slow performance in UDF from a sql job.
22659: wierd sql query problem
22660: SSIS
22661: Full Text Search - Weighing COLUMNS differently in queries
22662: INFORMATIONSCHEMA nullable
22663: sp_executesql: How to have a parameter within a string
22664: Storing DateTime Values - Sometimes with Time, Sometimes Without Time
22665: Trying to copy a row in a table
22666: Is this possible? Recursive data structure...
22667: sql 2k view with Union duplicating records
22668: What is best way to manage database changes?
22669: User-defined function not show up after being created
22670: Nested Queries Help
22671: How to insert and retrieve multimedia files into/from database
22672: Using functions in a join... referencing columns
22673: How can I Rearrange my Data
22674: Error Handling not workinh after select a bad table
22675: Select data that can't be converted.
22676: Trying to find out what records are accessed and what are garbage.
22677: Build Querys for external data sources
22678: =?Utf-8?Q?How_to_optimize_LIKE_=E2=80=99%MySearchS?=
22679: Top behaviour
22680: Query taking long-long time
22681: using getdate with a default param in sp
22682: Cross Table Query
22683: Executing DTS package as Other Loggin
22684: 3 most-recent contact dates
22685: nested insert
22686: Acess denied with Backup database
22687: Timestamp in User-Defined Function Causes Error
22688: Circular Autonum Keys
22689: Application Role vs One SQL Login
22690: local time function
22691: tricky query?
22692: create PIPE delimited file from T-SQL
22693: Like Comparison
22694: newID default value not working using XML Bulk Upload 3.0
22695: RTRIM ?
22696: column access logging
22697: security strategies
22698: Connection Time Out Issue
22699: How to sp_addExtendedProperty for a login?
22700: Year earlier than 1753
22701: Year less than 1753
22702: Compositing web services, invoking DB web services from outside DB
22703: How To Change Default File Location
22704: How can I find names of columns with triggers?
22705: No Logging
22706: Backup Restore DB ?
22707: Dymanic vs Static Columns
22708: SQL Server 2005 JDBC 1.1 integrated security question
22709: minimum permissions to use SQL-DMO to enumerate databases
22710: Using Cursors and comparing the current record and the one after.
22711: Store Procedure in Store Procedure
22712: Query abt Srvc Broker Sample HelloWorld_CLR
22713: Query on EXECUTE sp_executesql
22714: storing RESTORE VERIFYONLY results in table for historical purposes
22715: Query on EXECUTE sp_executesql
22716: How to preserve the character '0' from the sql server?
22717: Synchonization of an application an a SQL Server
22718: Problem with local variables, stored procedures and multiple datab
22719: help with update trigger
22720: Sample deployment script
22721: add field query problem
22722: Getting date in own format like yyyy/dd ...
22723: Pivoting Data In SQL Server 2000
22724: which one is more efficient
22725: help with update statement
22726: SQL 2005: VARCHAR(MAX) vs VARCHAR(4000)
22727: CAST question
22728: Determining the API used by an application
22729: How to select top N grouping by....
22730: rename a table
22731: Excel to SQL 2000
22732: Casc
22733: Convert Julian date to Standard date
22734: Parsing Query
22735: Parsing Query
22736: Excel to SQL 2000
22737: Email address edits
22738: Table-valued UDF Performance Change with SQL 2005
22739: Using Cursors and comparing the current record and the one after t
22740: SQL JOIN (I think)
22741: Dynamic SQL procedure with openrowset
22742: Subquery returned more than 1 value Error
22743: Cursor to set-based: help!
22744: Complicated updates
22745: can't deploy CLR stored procedures
22746: update image field in 500 records to all be the same.
22747: ATTN MS: Need for a REAL BEFORE trigger
22748: Join
22749: ANSI_NULLS and QUOTED_IDENTIFIER problem when inserting rows from QA
22750: Identity field problem after recreating table