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

view full version: back to formated view

24151: If file exist, FTP file
24152: Outlook locked with sql 2005
24153: How to add condition to where clause?
24154: How to empty log file in SQL 2005?
24155: ORDER BY DATETIME field BUG?
24156: Select Distinct Data from Symmetric Table
24157: using aggregate functions in co-related query to find some column value
24158: Some difficult joins
24159: SQL Server 2000 View -- Case Statement
24160: Job Outcome Constants (SQLDMO_JOBOUTCOME_TYPE)
24161: Beginning Balance Query
24162: Images in SQL
24163: Incrementing column in a query
24164: joining two tables
24165: How To Move A Database Table
24166: How to query for transaction's isolation level...
24167: t-sql statement one-one match
24168: convert year part of a date
24169: Subquery performance concern
24170: Custom data extension has trust issues
24171: Query tuning
24172: trigger vs default
24173: Bulk insert from text file in to multiple table
24174: Adding a line return to an SQL messge
24175: ASP error with stored procedure
24176: A query runs 1 times slower from a .NET application the from Query Analizer
24177: NT Events
24178: Find the nearest date of one column of a table from another table
24179: Views and Query Optimizer
24180: question-synch
24181: Last Execution Time of Stored Procedure
24182: BETWEEN PROBLEM IN DATETIME QUERY
24183: GROUP BY with multiple columns
24184: How to get the dates on which a proc is altered ??
24185: Using Index
24186: SQL Server 2005 and Cursors
24187: finding the closest exchange rate from another table based on the date
24188: Help with varchar to date
24189: Select double byte character from varchar() field (SQL 2005)
24190: schedule dts at a remote server
24191: Formatting a Select Statement
24192: Best Way To Aggregate a Large Table
24193: can a SELECT return this result ?!
24194: can a SELECT return this result ?!
24195: can a SELECT return this result ?!
24196: can a SELECT return this result ?!
24197: can a SELECT return this result ?!
24198: convert kb into mb
24199: Issue with T-SQL and SQL 7 to SQL2000 conversion
24200: Joining two SQL queries with different conditions
24201: Recursive/Tree Type Query in SQL 2000
24202: Many-to-Many Variation
24203: auditting select statement
24204: Creating GUID for Identity key
24205: Date comparison logic in a trigger without hard-coding the year
24206: SQL Server 2005 - SQL-DMO Sample Code
24207: many to many query with 1 row per result?
24208: Making an Access - SQL db solution portable
24209: trigger/(exists) problem
24210: Unique Constraint on Table Variables
24211: Event Properties
24212: how create linked server to informix
24213: A tricky query
24214: Distinct and Unique
24215: Quick Method to delete from Two Tables
24216: how to model inheritance?
24217: SQL 2005: How to list all Stored Procedure like sp_tables
24218: Can one exec a stored procedure in a case statement in a stored procedure?
24219: Traversing a tree hierachy backwards
24220: Joining table to itself
24221: proc execution time in management studio vs query analyzer
24222: index size data large than data size
24223: Max function Problems - Stumped!
24224: SQL Backup: Database needs to be in single user mode
24225: Marking copied records
24226: Database in use ??
24227: Alter column name of table?
24228: SELECT...CASE in stored procedures
24229: SELECT...CASE in stored procedures
24230: in sql server 2000+ is there some stored procedure that shows your current disk space usage?
24231: Related Tags
24232: BCP Out Command
24233: Error calling one stored procedure from another until...
24234: Need help with a query's where clause
24235: Don't know where to start
24236: Bulk Insertion of XML or Relational Data into SQL 2005
24237: Stored Procedure Question
24238: ASP.NET and SQL Server
24239: increment (dynamic sql) doesn't return value
24240: Immutability of procedure parameters
24241: SQL to Oracle update trigger fails due to distributed transaction error 7391
24242: dts sql server using file system object
24243: Storing SQL in a table
24244: increment a variable in DTS transformation
24245: Error 7306 when trying to do an update on a linked server
24246: DTS failure write to event log
24247: Storing a transaction
24248: use @@spid for temp table
24249: add column if it doesn't exist
24250: Cast as Varchar
24251: SELECT question (How to make a select with date from until, getting each row)
24252: SQL Parser component
24253: While
24254: firing a dts package's execution
24255: Novice question, returning 1 record per
24256: MAXERRORS in BCP Does'nt work
24257: Rows per date
24258: Data change event
24259: select between question
24260: xp_sendmail
24261: SQL Syntax
24262: using extended properties
24263: Recommendations - XML or traditional relational structure
24264: row_number query
24265: How To Search A Database Table
24266: Strange problem with spaces...!
24267: SELECT Statement
24268: Deferrend Name Resolution for a field in a Stored Procedure
24269: Select and Case statement
24270: DateSerial in Access to SQL
24271: Define Job using SQL DMO
24272: View ORDER BY lost on web
24273: running jobs
24274: SQL2005 Setup
24275: which sql sp is installed in my computer
24276: OLEDB Provider for Postgres
24277: A script to generate a script?
24278: Generate random seed on a huge table
24279: Smarter Caching in SQL2005 for UDF's
24280: read varbinary(max)
24281: What is the Basic Difference Between Viiews And Procedures ..
24282: sum
24283: DBCC SHRINKFILE AND BACKUP LOG
24284: Creating User Defined Function for Rolling Calendar Year
24285: How to rewrite query
24286: Copying SPs from one DB to another
24287: Using Openrowset with Cube
24288: T-SQL Grammar file
24289: updating rows using a cursor
24290: One Date 5 Queries
24291: Creating primary key on a view
24292: unable to return bigint from stored proc
24293: Need help with SQL code
24294: DataBase Backup
24295: Bulk Insert with text Qualifier
24296: Visual Studio 2005 Pro > SQL Server 2005 > Asp.Net 2.0
24297: Checking which tables were modified by a program?
24298: Error Using ODP.NET
24299: group data by time interval
24300: SQL Query
24301: How to flatten groups of two rows to a single row
24302: Strign Manipulation performance
24303: SQL Server does not support updating remote tables via triggers?
24304: accing shered volume
24305: Multiple-step OLE DB
24306: launch macro with a parameter from dos batch
24307: duplicate rows
24308: Help With Query
24309: Order by, Using a param
24310: Efficiently refering to non-identifier fields on "one" side of joi
24311: exams 2005
24312: SQL error 7101
24313: use excel as a data source
24314: DATETIME QUESTION
24315: Service Accounts
24316: Convert string to DateTime
24317: Select everything that is in one table, but not in the other?
24318: entering store procedure result to table
24319: Log File Size reduction
24320: Adding a constraint question
24321: Row Size Limit?
24322: mssql: case statements with multiple columns
24323: Read-Only and Suspect
24324: problem with Linkedserver-Odbc-oledb-informix
24325: Insert data to the one table from anther table
24326: Creating SQL Classes ?
24327: GROUP BY Question
24328: Data Modeling Question - Medical Lab Test Results
24329: Querying Active Directory / LDAP groups using T-SQL
24330: sql 2005 equivalent for length in spt_datatype_info?
24331: SqlDependency.Starts work for local but not remote Sql Server 2005
24332: Calculate Age
24333: How to select/insert datetime field
24334: 1NF Violation?
24335: Seemingly conflicting advice on indexes
24336: Syncing users on a standby Server
24337: SET NOCOUNT ON?
24338: SQL Date
24339: trouble with table-valued function
24340: Why I get this error while opening page?
24341: ;?
24342: Oracle Interview questions and answers
24343: Give me your Thoughts-Storing format in database
24344: connect fail to informix with 7399 error
24345: ordinal_position
24346: [ConnectionWrite (send()).]General network error
24347: How to use Case Statement
24348: Progress and 4GL verses SQL Server and VB/VBA
24349: SQL Query question
24350: spt_datatype_info in sql 2005 ? need length of text field
24351: Cursor not completing when stored procedure runs within it
24352: Data Modeling Question; Patients and Referrals
24353: Invalid entries in sysindexes
24354: Getdate() default value does not get created
24355: Help Me Write This Query
24356: one to (one or zero) relationship
24357: Calling nested stored proedure many times
24358: HELP with case statement [Divide by zero error encountered.] !!!
24359: displaying milliseconds in VB 6 program
24360: Help with SP or Function
24361: One stored procedure calls another stored procedure
24362: Aaron Bertrand PLEASE HELP
24363: Resizing TempDB From a Trigger
24364: Create SCHEMA - Basic Question - 2005
24365: Simple Synonym Question
24366: Count Of items, Count of Items Passed and percentage passed
24367: Using Variable in OPENROWSET statement...
24368: strategy for updates in stored procedures
24369: ORDER BY clause with unknown column name
24370: Dyncamic SQL
24371: Not Recocnised function problem
24372: Reference alias field name
24373: limit to where claus
24374: Books for sql2005
24375: SP IO Statistics and Execution Plan different - why?
24376: Is Sql-Server 2005 Object Oriented DBMS
24377: Select top rows from each group
24378: monitoring servers
24379: NEW IT JOBS
24380: [ConnectionWrite (send()).]General network error
24381: SQLDMO how to execute a sql script file(.sql) / sql code?
24382: An error occurred during local report processing.
24383: pass string to stored procedure
24384: How to insert picture into Image column?
24385: Complex sql update
24386: changing table design - interesting
24387: Querying entire database
24388: Row already belongs to another table.
24389: Format numeric to display dollar value $1,000.00
24390: Stored Proc Debug c0000005 Abend
24391: moving northwind
24392: Second try: Need a little help with a sql query
24393: Need help with a query
24394: Need to add date during bulk import from csv
24395: VS.NET: SQL Server Project
24396: how to get sqlcmd return values
24397: int 4 to 04
24398: how to select
24399: executeBatch fails on stored proc call
24400: Dynamic query in a function
24401: sp_sqlagent_get_perf_counters
24402: UTC string to DATETIME
24403: How to Create Virtual Database
24404: Using TOP
24405: Schema Discovery
24406: Aggregate Case Conditions
24407: Execution Plan of a CLR Stored Procedure?
24408: How to view transactin log?
24409: Filtering out null results of subquery
24410: Dateformat
24411: Export data to linked servers (almost impossible) ?
24412: sql 2000 design/documentation tools
24413: SQL statement syntax error..Please read
24414: SQLBPA for SQL2005
24415: The Temp Table blues OR The Dynamic SQL blues
24416: Too many table names in the query
24417: Reset Automatic Numbering
24418: Error 3271 while doing a backup
24419: grouping by a datetime column
24420: Transaction Log Question
24421: How to check the existence of a login with the SQL-DMO?
24422: Unikey Keys Design Question
24423: Sort Tab Order
24424: How to Speed up the query time?
24425: Inserting records into Postgres from SQL server 2k Using Openquery
24426: SQL query transform columns into rows
24427: convert input parameter into field
24428: Query performace problem
24429: 2 types of deadlock errors
24430: Are we going right?
24431: Help with Stored Procedure
24432: Count how many times a character appeared in a string
24433: Inserting Records, Skipping Duplicates
24434: Change Notifications
24435: query to find sales person who did sale every quarter
24436: How Persistent are Derived Tables
24437: identify what tables are used in trace
24438: Need a guru
24439: Advice Requested on Primary Key: Is char(20) better than binary(20)
24440: Copy data TO linked server
24441: SQL 2005 Developer License
24442: Totals and Average from multiple tables
24443: Stored Procedure and Trigger Programming books
24444: UNION ALL natural order
24445: Difference in these two queries
24446: Is this possible? SQL Server 2000 Write times
24447: Query Oracle database date time using DTS
24448: join vs where
24449: convert hexadecimal datetime to normal datetime
24450: a count query
24451: SqlCacheDependency - Cache.Insert not working
24452: help with a query
24453: Re sort
24454: Stored Procedure Causing Deadlock
24455: View performance
24456: Debugger 'step into' stops working after hitting a line ..
24457: Eliminate Rows with Redundant Columns
24458: Deleting Duplicate Records
24459: Memory Use
24460: Problem mit Stored Procedure
24461: The context connection is already in use (SQLCLR)
24462: how i can make script Database with Data?
24463: Select / Group By First Word in Column
24464: Extracting data types
24465: SQL mail login pwd
24466: Count rows to max value
24467: Attaching and detaching a standby database onto a different server
24468: I've never seen this before
24469: DENY SELECT on SCHEMA issue
24470: Numeric or Int to store prices
24471: design question
24472: Type determining
24473: where can find the SQLDMO reference?
24474: Error severity Level 10 and SqlError .NET Class
24475: Deploying .Net / SQL Server 2005 replication
24476: SP updates my fields to NULL
24477: Select Count
24478: SqlServer 2005 OUTPUT Clause
24479: MSDTC Unavailable Windows 2003
24480: SQLCMD / ISQL /OSQL - Rows affected message
24481: Derived Column in CREATE TABME
24482: Is there any way to transparently not doing an insert?
24483: comparing query results
24484: The query engine on WHERE conditions
24485: Help with a query
24486: How to Get Using Query
24487: Problem in stored proc with a null value in dynamic SQL
24488: Ownership chaining problem in SQL 2005 with UDF in default constraint
24489: Retrieve Primary key coloumn by querying system table of Sql server 2000
24490: selecting only the month/year part of a date value
24491: Capturing a Lock:Deadlock Chain programatically (with .net)
24492: Managed vs SQL Stored Procedure....
24493: Execute SQL dynamically
24494: divide by zero error
24495: Stored Proc for FLU shots
24496: Need help with the SELECT statement below please.
24497: Grouping performance monitor time data after pivoting help please
24498: Group no. of records by text in a text/varchar field
24499: alter table
24500: Getting an error I can't figure out