Home > Archive > SQL Server Programming > April 2006
Pages: [1] 2 3 4 5 6 7
| Posts(3) | April 30, 2006, 10:07 pm | COPY to a .txt file | | Posts(18) | April 30, 2006, 7:11 pm | Strange behavior with MS SQL | | Posts(9) | April 30, 2006, 7:11 pm | bug in string processing if the GO keyword is inside the string | | Posts(6) | April 30, 2006, 7:11 pm | ... or changing system table | | Posts(4) | April 30, 2006, 7:11 pm | Calculating Hours, Mins over 24 hour periods | | Posts(2) | April 30, 2006, 7:11 pm | SQL 2005: Replication: location of snapshot files? | | Posts(2) | April 30, 2006, 7:11 pm | Re: How do I make a field automatically get its values from anothe | | Posts(2) | April 30, 2006, 7:10 pm | How do I make a field automatically get its values from another fi | | Posts(3) | April 30, 2006, 7:10 pm | Splitting a String | | Posts(1) | April 30, 2006, 7:10 pm | Using SQL Server 2005 Public Keys in VB.Net | | Posts(3) | April 30, 2006, 7:10 pm | Re: Is there performance penalty for returning resultsets instead of rows | | Posts(3) | April 30, 2006, 7:10 pm | Select query with column name + value | | Posts(3) | April 30, 2006, 7:10 pm | SET ANSI_WARNINGS OFF | | Posts(5) | April 30, 2006, 7:10 pm | how to ALTER COLUMN ? | | Posts(4) | April 30, 2006, 7:10 pm | Help Setting Sum of Column | | Posts(18) | April 30, 2006, 8:10 am | Mother Celko's Monday SQL Puzzle #2 | | Posts(4) | April 30, 2006, 8:10 am | Analyzer 2000 using 2005 database gives error | | Posts(4) | April 30, 2006, 8:10 am | Previewing Crystal Report | | Posts(4) | April 30, 2006, 8:10 am | Hierarchical queries in SQL Server 2000 | | Posts(2) | April 29, 2006, 10:05 pm | Newbie?: Can This Be Done?- If so please direct | | Posts(2) | April 29, 2006, 10:05 pm | sqlite current_timestamp | | Posts(3) | April 29, 2006, 7:05 pm | How to find Server Collation from SQL 2005 tables/views? | | Posts(9) | April 29, 2006, 7:05 pm | Help with SQL QUESTION | | Posts(1) | April 29, 2006, 7:05 pm | Transactional Replication - Modifying Target tables | | Posts(6) | April 29, 2006, 7:05 pm | returns null not cost value in SP | | Posts(3) | April 29, 2006, 7:05 pm | Analyze SPS | | Posts(3) | April 29, 2006, 7:05 pm | temp table in sp_executesql | | Posts(6) | April 29, 2006, 7:05 pm | Convert digits to letters | | Posts(19) | April 29, 2006, 7:05 pm | Insert multiple lines | | Posts(3) | April 29, 2006, 7:05 pm | sql script. | | Posts(5) | April 29, 2006, 7:05 pm | IIF Statement on Select | | Posts(4) | April 29, 2006, 7:05 pm | Array as variable ? | | Posts(2) | April 29, 2006, 7:05 pm | SMO Restore Question | | Posts(9) | April 29, 2006, 7:05 pm | Sending a variable to a cursor with an In statement | | Posts(4) | April 29, 2006, 8:04 am | insert into statement for image | | Posts(2) | April 29, 2006, 8:04 am | Re: Help please with updating large amounts of data on SQL Server | | Posts(1) | April 29, 2006, 8:04 am | SMO Restore Question | | Posts(1) | April 29, 2006, 8:04 am | Is there performance penalty for returning resultsets instead of | | Posts(6) | April 29, 2006, 4:05 am | Output file size changes when date format reduced | | Posts(7) | April 29, 2006, 4:05 am | EXECUTE permissions | | Posts(3) | April 29, 2006, 4:05 am | Stored Procedures and several queries | | Posts(5) | April 29, 2006, 4:05 am | Loading controls with objects versus recordsets | | Posts(2) | April 29, 2006, 4:05 am | Report Syntax help !!!!!!! | | Posts(4) | April 28, 2006, 10:05 pm | Recommended Reading to Learn 2005 | | Posts(2) | April 28, 2006, 10:05 pm | Repost: Exporting Information | | Posts(2) | April 28, 2006, 7:08 pm | 2005 Management Studio questions | | Posts(23) | April 28, 2006, 7:08 pm | problem with no rows being returned - but rows are there | | Posts(5) | April 28, 2006, 7:08 pm | Return Null on Unmatched Join? | | Posts(1) | April 28, 2006, 7:08 pm | SQL query: is object in a static list showing up in daily results? if so, how many t | | Posts(5) | April 28, 2006, 7:08 pm | View Performance? | | Posts(4) | April 28, 2006, 7:08 pm | Blocking | | Posts(5) | April 28, 2006, 7:08 pm | Problem with sum function and group by | | Posts(6) | April 28, 2006, 7:08 pm | IDENTIDY row as bigint? | | Posts(5) | April 28, 2006, 7:08 pm | problem using default value in SP | | Posts(4) | April 28, 2006, 7:08 pm | Conversion of Access query using First() Aggregate | | Posts(1) | April 28, 2006, 7:08 pm | FW: Errors Occurred (80040e21) and DBSTATUS_E_UNAVAILABLE at SetData() | | Posts(12) | April 28, 2006, 7:08 pm | Shrink database? | | Posts(3) | April 28, 2006, 7:08 pm | Data transformations | | Posts(5) | April 28, 2006, 7:08 pm | SQL SIMPLE result sent in Oracle stored procedure | | Posts(4) | April 28, 2006, 7:08 pm | how to override/trap Tsql errmsg and use custom errmsg in SP? | | Posts(1) | April 28, 2006, 7:08 pm | MSDTC Problems | | Posts(6) | April 28, 2006, 7:08 pm | Normalization Problem | | Posts(4) | April 28, 2006, 7:08 pm | SQL Server Express "Description" Property | | Posts(4) | April 28, 2006, 7:08 pm | How to SELECT FROM In-Memory dataset in C# .NET? | | Posts(12) | April 28, 2006, 7:08 pm | Execute stored procedure for each value returned in a query | | Posts(1) | April 28, 2006, 7:08 pm | SQLBindParameter() bigint not working | | Posts(8) | April 28, 2006, 7:08 pm | Textcopy and nText problems | | Posts(2) | April 28, 2006, 7:08 pm | SQL Concatenation | | Posts(10) | April 28, 2006, 7:08 pm | Local MDF Files--can I make this work? | | Posts(3) | April 28, 2006, 7:07 pm | SSIS Result Set | | Posts(13) | April 28, 2006, 7:07 pm | Top 10 clients per case type & country | | Posts(2) | April 28, 2006, 7:07 pm | Comparing data structure | | Posts(3) | April 28, 2006, 7:07 pm | Trouble With A Trigger | | Posts(3) | April 28, 2006, 8:10 am | RE: Help please with updating large amounts of data on SQL Server | | Posts(16) | April 28, 2006, 8:10 am | Table format change | | Posts(5) | April 28, 2006, 8:10 am | best way of making changes to a production database | | Posts(3) | April 28, 2006, 8:10 am | Help please with updating large amounts of data on SQL Server 2000 | | Posts(4) | April 28, 2006, 8:10 am | System procedure | | Posts(1) | April 28, 2006, 8:10 am | The War on terrorism | | Posts(3) | April 28, 2006, 8:10 am | store procedure | | Posts(3) | April 28, 2006, 8:10 am | Guid / uniqueidentifier ... | | Posts(3) | April 28, 2006, 8:10 am | Location of query results (sql 2000) | | Posts(1) | April 28, 2006, 8:10 am | Best Practices for SQL Server 2005 | | Posts(15) | April 28, 2006, 8:10 am | Which query will be faster ? | | Posts(5) | April 28, 2006, 4:07 am | OLE automation, FolderExists, copy, etc from stored procedure | | Posts(5) | April 28, 2006, 4:07 am | Logging Errors to a User-Table in Yukon | | Posts(3) | April 28, 2006, 4:07 am | Accessing the FileSystem | | Posts(3) | April 28, 2006, 4:07 am | Error connecting to SQL Server 2005 - ... does not allow remote connections? | | Posts(2) | April 28, 2006, 4:07 am | Grant execute on many procs in 2005 | | Posts(1) | April 27, 2006, 10:04 pm | Develop your own Accounting software using Microsoft technologies | | Posts(10) | April 27, 2006, 10:04 pm | order of tables in an INNER JOIN | | Posts(15) | April 27, 2006, 7:08 pm | performance of temp table | | Posts(3) | April 27, 2006, 7:08 pm | Gaining complete exclusive access to a given table | | Posts(5) | April 27, 2006, 7:08 pm | Help with a Query | | Posts(4) | April 27, 2006, 7:08 pm | how to use TABLESAMPLE in select statement... | | Posts(3) | April 27, 2006, 7:08 pm | Cursor, CTE and syntax issue. Thanks for your help! | | Posts(5) | April 27, 2006, 7:08 pm | Joining Rows in a SubQuery | | Posts(5) | April 27, 2006, 7:08 pm | text vs varchar as input params for a stored proc | | Posts(9) | April 27, 2006, 7:08 pm | Indexes versus views | | Posts(8) | April 27, 2006, 7:08 pm | How to connect two SQL Server using private network. | | Posts(3) | April 27, 2006, 7:08 pm | Date and Time in SQLServer 2005 | | Posts(10) | April 27, 2006, 7:08 pm | Problem with Grouping | | Posts(4) | April 27, 2006, 7:08 pm | IP address Long to octec format | | Posts(12) | April 27, 2006, 7:08 pm | indexed view and 'ANSI_NULLS | | Posts(2) | April 27, 2006, 7:08 pm | Victory! | | Posts(3) | April 27, 2006, 7:08 pm | Trigger doesnt work on Importing through DTS | | Posts(14) | April 27, 2006, 7:08 pm | Dynamic IDENTITY seed | | Posts(3) | April 27, 2006, 7:08 pm | Multiple column unique constraint | | Posts(3) | April 27, 2006, 7:08 pm | Safe encryption of stored procedures for SQL-Server 2000 | | Posts(5) | April 27, 2006, 7:08 pm | update statistics | | Posts(4) | April 27, 2006, 7:08 pm | Replacing a single quote | | Posts(17) | April 27, 2006, 7:08 pm | Not cool...linking to password-protected Access database | | Posts(5) | April 27, 2006, 7:08 pm | How to script permissions? | | Posts(5) | April 27, 2006, 7:08 pm | Conditional Selection | | Posts(2) | April 27, 2006, 7:08 pm | Can't index functinon-based column | | Posts(1) | April 27, 2006, 7:08 pm | Execution time | | Posts(1) | April 27, 2006, 7:08 pm | Re: How to page SQL query result returned from FOR XML statement? | | Posts(7) | April 27, 2006, 7:08 pm | Need some suggestions about using UNIQUEIDENTIFIER | | Posts(9) | April 27, 2006, 7:08 pm | Structure Question | | Posts(1) | April 27, 2006, 7:08 pm | Updated SQL Server 2005 Books Online available | | Posts(5) | April 27, 2006, 7:08 pm | Scheduled jobs not repeating (log shipping restore) | | Posts(7) | April 27, 2006, 7:08 pm | Advice requested : Choosing the best Key for a table | | Posts(4) | April 27, 2006, 7:08 pm | RE: Query to get name of views which reference a give column from | | Posts(3) | April 27, 2006, 7:08 pm | Deletion - best practices | | Posts(3) | April 27, 2006, 7:08 pm | Query to find default value for a column | | Posts(9) | April 27, 2006, 7:08 pm | UNIQUE INDEX AND ERROR HANDLING | | Posts(3) | April 27, 2006, 7:08 pm | injection attack using transaction log | | Posts(2) | April 27, 2006, 7:08 pm | + char(45)+ | | Posts(2) | April 27, 2006, 7:08 pm | Query to get name of views which reference a give column from a ta | | Posts(4) | April 27, 2006, 8:06 am | URGENT HELP! SQL+VB.NET for New Application | | Posts(1) | April 27, 2006, 8:06 am | Re: bcp -- no errors, but 0 rows copied | | Posts(28) | April 27, 2006, 8:06 am | How to effectively create dynamic queries? | | Posts(3) | April 27, 2006, 8:06 am | DATEDIFF | | Posts(3) | April 27, 2006, 8:06 am | Cancelling an insert with a trigger | | Posts(4) | April 27, 2006, 8:06 am | Delay in inserting records continuously into the Database | | Posts(4) | April 27, 2006, 8:06 am | Grouping with a full join | | Posts(11) | April 27, 2006, 8:06 am | show the records dependent on some conditions | | Posts(5) | April 27, 2006, 8:06 am | conditionally executing sql statement | | Posts(5) | April 27, 2006, 4:06 am | Create table - default for column (sql 2000) | | Posts(9) | April 27, 2006, 4:06 am | cant figure out how to write query.. | | Posts(2) | April 27, 2006, 4:06 am | marked transactions | | Posts(4) | April 27, 2006, 4:06 am | [OT] Stupid TV Commercial | | Posts(5) | April 27, 2006, 4:06 am | Linked server connection | | Posts(3) | April 27, 2006, 4:06 am | List of tables used in query | | Posts(8) | April 27, 2006, 4:06 am | limit size of image column | | Posts(2) | April 27, 2006, 4:06 am | dynamically delete data | | Posts(7) | April 27, 2006, 4:06 am | Columns to Rows - Group By count | | Posts(4) | April 27, 2006, 4:06 am | insert no. automatically | | Posts(1) | April 27, 2006, 4:06 am | 500 + Freeware Utilities Available | | Posts(4) | April 26, 2006, 10:05 pm | Check Constraint ot Instead of trigger ? | | Posts(5) | April 26, 2006, 10:05 pm | Update Table | | Posts(2) | April 26, 2006, 10:05 pm | Need to Add Data that is checked on a separate table | | Posts(8) | April 26, 2006, 10:05 pm | Issue with SqlUserDefinedAggregate | | Posts(3) | April 26, 2006, 10:05 pm | Reserved Words | | Posts(3) | April 26, 2006, 10:05 pm | How can I know a user table's size? | | Posts(5) | April 26, 2006, 10:05 pm | perform aggregate function & group by | | Posts(6) | April 26, 2006, 10:05 pm | Max OR's and AND's in a WHERE clause | | Posts(2) | April 26, 2006, 10:05 pm | DTS/ SQL Agent question | | Posts(5) | April 26, 2006, 7:08 pm | SQLServer 2005 XML DataType is (almost) useless!!! (Please correct me if I am wrong) | | Posts(8) | April 26, 2006, 7:08 pm | I love using IDENTITY | | Posts(4) | April 26, 2006, 7:08 pm | sql2005 notification (email, pager and so on) | | Posts(2) | April 26, 2006, 7:08 pm | UDP Port for SQL 2000 | | Posts(1) | April 26, 2006, 7:08 pm | Report Output: What is the solution? | | Posts(3) | April 26, 2006, 7:08 pm | Merge two SELECT query into one. execution time doubled, Why? | | Posts(3) | April 26, 2006, 7:08 pm | bcp -- easy for you, hard for me | | Posts(3) | April 26, 2006, 7:08 pm | IIF & IsNull Functions | | Posts(3) | April 26, 2006, 7:08 pm | Check Constraint | | Posts(6) | April 26, 2006, 7:08 pm | Query Performance | | Posts(43) | April 26, 2006, 7:08 pm | stored procedure with table as a variable | | Posts(2) | April 26, 2006, 7:08 pm | PL/SQL RPC call from Sql Server linked server (OraOLEDB) | | Posts(1) | April 26, 2006, 7:08 pm | Incremental counts and timeouts | | Posts(1) | April 26, 2006, 7:08 pm | RE: What is the problem of using the IDENTITY column as the only key f | | Posts(4) | April 26, 2006, 7:08 pm | Store Proc | | Posts(2) | April 26, 2006, 7:08 pm | Re: Yukon xp_cmdshell setting | | Posts(4) | April 26, 2006, 7:08 pm | Result set with nested stored procedures | | Posts(1) | April 26, 2006, 7:08 pm | DTS default data types | | Posts(4) | April 26, 2006, 7:08 pm | Join using LIKE ? | | Posts(4) | April 26, 2006, 7:08 pm | Simple Problem. Delete Row Where Bit Select = Some Number | | Posts(1) | April 26, 2006, 7:08 pm | RE: SQLServer 2005 XML DataType is (almost) useless!!! (Please correct | | Posts(1) | April 26, 2006, 7:08 pm | Looking for ways to optimize a Stored Procedure. | | Posts(5) | April 26, 2006, 7:08 pm | Left Outer Join On Mutiple Tables | | Posts(2) | April 26, 2006, 7:08 pm | Power user question | | Posts(19) | April 26, 2006, 7:08 pm | PRIMARY key versus UNIQUE index | | Posts(4) | April 26, 2006, 7:08 pm | procedure only returns 0 | | Posts(9) | April 26, 2006, 7:08 pm | Update query | | Posts(3) | April 26, 2006, 7:08 pm | what sql datatype | | Posts(8) | April 26, 2006, 7:08 pm | SQL Server oddity | | Posts(6) | April 26, 2006, 7:08 pm | Cross Tab SELECT | | Posts(4) | April 26, 2006, 7:08 pm | INSERT INTO... SELECT STATMENT w/Extra nonSQl data | | Posts(12) | April 26, 2006, 7:08 pm | Converting mixed text to number | | Posts(3) | April 26, 2006, 7:08 pm | How to performance case-insensitive search on XML data type in SQLServer 2005? | | Posts(5) | April 26, 2006, 7:08 pm | Joining Question | | Posts(4) | April 26, 2006, 7:08 pm | Invalide object name 'INSERTED' | | Posts(1) | April 26, 2006, 7:08 pm | dts migration wizard in sql2k5... | | Posts(2) | April 26, 2006, 7:08 pm | Transaction fails to rollback | | Posts(1) | April 26, 2006, 7:08 pm | ODBC TImeOut | | Posts(6) | April 26, 2006, 7:08 pm | Enterprise Manager rewriting my SQL...is this OK? | | Posts(1) | April 26, 2006, 7:08 pm | data driven query - insert statement in the update query!! | | Posts(4) | April 26, 2006, 7:08 pm | Menu Hierarchy Display Order (Recursion) | | Posts(5) | April 26, 2006, 8:07 am | check constraints |
|
|