Home > Archive > SQL Server Programming > July 2005
Pages: [1] 2 3
| Posts(4) | July 31, 2005, 5:19 pm | my Store procedure spend TOO MANY TIME, why? | | Posts(3) | July 31, 2005, 5:19 pm | Custom 'Order By' Function? | | Posts(9) | July 31, 2005, 5:19 pm | INSERT statement conflicted with COLUMN CHECK constraint. | | Posts(9) | July 31, 2005, 5:19 pm | Query Tuning. | | Posts(31) | July 31, 2005, 5:19 pm | Stored Procs vs VIEWS: Seeking Comparison | | Posts(2) | July 31, 2005, 5:19 pm | Data Model Help | | Posts(7) | July 31, 2005, 9:01 am | My table design - where did I go wrong? | | Posts(7) | July 30, 2005, 10:01 pm | Granting SA rights to Sr. Developers in Small ITS Groups when ther | | Posts(5) | July 30, 2005, 10:01 pm | Is there such thing as cross-table index or something? | | Posts(4) | July 30, 2005, 10:01 pm | ANSI-Style Joins & Old-Style Joins! | | Posts(5) | July 30, 2005, 5:02 pm | SQL HELP - Hugo Kornelis | | Posts(2) | July 30, 2005, 5:02 pm | xml question | | Posts(2) | July 30, 2005, 5:02 pm | Question | | Posts(4) | July 30, 2005, 5:02 pm | DBCC Logical Scan Bytes/Sec | | Posts(1) | July 30, 2005, 5:02 pm | 1) User-Defined string Functions Transact-SQL 2) BUG in replace | | Posts(3) | July 30, 2005, 5:02 pm | Table Creation Text | | Posts(12) | July 30, 2005, 5:02 pm | how to write a query to get list of user-defined types | | Posts(14) | July 30, 2005, 5:02 pm | how to count the total rows for a query with group by? | | Posts(6) | July 30, 2005, 5:02 pm | Case in a Where clause | | Posts(3) | July 30, 2005, 9:02 am | Slow Stored Procedure when run via ado, fast from query analyzer | | Posts(4) | July 30, 2005, 9:02 am | Upgrading to SQLServer | | Posts(4) | July 30, 2005, 9:02 am | SQLDistribution ActiveX does not reinitializes subscription | | Posts(5) | July 30, 2005, 9:02 am | Is tables created in UDF thread safe? | | Posts(1) | July 29, 2005, 10:02 pm | Re: From one to another table | | Posts(3) | July 29, 2005, 10:02 pm | How to process cubes using VB | | Posts(2) | July 29, 2005, 10:02 pm | Database design question | | Posts(3) | July 29, 2005, 10:02 pm | Using Trace Output | | Posts(6) | July 29, 2005, 10:02 pm | Finding a tape drive | | Posts(4) | July 29, 2005, 5:07 pm | Getting rid of unwanted characters! | | Posts(4) | July 29, 2005, 5:07 pm | Extracting and converting text fields. | | Posts(3) | July 29, 2005, 5:07 pm | JOIN Process Order and Performance Comparisons | | Posts(1) | July 29, 2005, 5:07 pm | SQLServer 2000 EXCEPTION_ACCESS_VIOLATION SqlDumpExceptionHandler | | Posts(5) | July 29, 2005, 5:07 pm | Replace a string across multiple stored procedures | | Posts(1) | July 29, 2005, 5:06 pm | ODBC timeout error 3146 | | Posts(5) | July 29, 2005, 5:06 pm | RE: Releationship between 2 tables which are in 2 different databa | | Posts(2) | July 29, 2005, 5:06 pm | Get DateFormat | | Posts(2) | July 29, 2005, 5:06 pm | SQL Help: Updating aggregate table | | Posts(2) | July 29, 2005, 5:06 pm | Re: Access Update Query Problem | | Posts(2) | July 29, 2005, 5:06 pm | How to Optimize the Profiler Trace? | | Posts(5) | July 29, 2005, 5:06 pm | Scheduled job "show step details" more info? | | Posts(2) | July 29, 2005, 5:06 pm | When to switch from SWITCH() to JOIN | | Posts(6) | July 29, 2005, 9:07 am | temp table vs normal table | | Posts(6) | July 29, 2005, 9:07 am | Releationship between 2 tables which are in 2 different databases | | Posts(4) | July 29, 2005, 9:07 am | Replace temp table with inline table-value function | | Posts(6) | July 29, 2005, 9:07 am | Can you have one field containing multiple data? | | Posts(5) | July 29, 2005, 9:07 am | Seeing the heart of a DTS from a Query Analyzer session* | | Posts(7) | July 29, 2005, 9:06 am | Newbee question about permissions and sp_OACreate | | Posts(1) | July 29, 2005, 9:06 am | Re: SQL Server means 'ß' = 'ss' is TRUE. What's wrong? | | Posts(6) | July 29, 2005, 4:03 am | DB to DB sp | | Posts(1) | July 29, 2005, 4:03 am | Administrative task: users and groups | | Posts(1) | July 29, 2005, 4:03 am | RE: Peculiar Crosstab Query | | Posts(3) | July 29, 2005, 4:03 am | Stop a DTS Package | | Posts(3) | July 29, 2005, 4:03 am | Truncating logs with a PHP script | | Posts(2) | July 29, 2005, 4:03 am | SP to document maintenance plan ? | | Posts(5) | July 29, 2005, 4:02 am | cross-section select | | Posts(6) | July 29, 2005, 4:02 am | querying the data dictionary | | Posts(8) | July 29, 2005, 4:02 am | Three ways for do the same | | Posts(6) | July 29, 2005, 4:02 am | SQL Join and Where to Put the 'ON' | | Posts(4) | July 29, 2005, 4:02 am | Cursor logic vs. set based solutons | | Posts(4) | July 28, 2005, 10:02 pm | Dynamic AND! | | Posts(5) | July 28, 2005, 10:02 pm | CHECK | | Posts(5) | July 28, 2005, 10:02 pm | view sql statement via trigger | | Posts(3) | July 28, 2005, 10:02 pm | Is it possible ? | | Posts(6) | July 28, 2005, 10:02 pm | Please Help!! | | Posts(25) | July 28, 2005, 10:02 pm | Just Venting | | Posts(5) | July 28, 2005, 10:02 pm | Trigger problem | | Posts(3) | July 28, 2005, 10:02 pm | Select on 2 tables where value may be equal or null | | Posts(1) | July 28, 2005, 5:04 pm | Re: Error message in a job, SQLSTATE 42S02 (Error 208) | | Posts(1) | July 28, 2005, 5:04 pm | temp table vs normal table | | Posts(1) | July 28, 2005, 5:04 pm | temp table vs normal table | | Posts(1) | July 28, 2005, 5:04 pm | The facts you should know about making money online! | | Posts(1) | July 28, 2005, 5:04 pm | Re: Beating a dead horse - Drop table from proc | | Posts(2) | July 28, 2005, 5:04 pm | Running queries on queries | | Posts(2) | July 28, 2005, 5:04 pm | OPENXML - element has _xpath in name | | Posts(3) | July 28, 2005, 5:04 pm | Tax calculation net to gross. | | Posts(5) | July 28, 2005, 5:04 pm | Error message in a job, SQLSTATE 42S02 (Error 208) | | Posts(14) | July 28, 2005, 5:04 pm | Recyle an identity column number when max is reached | | Posts(8) | July 28, 2005, 5:04 pm | Delete and return data | | Posts(3) | July 28, 2005, 5:04 pm | where logic selection | | Posts(10) | July 28, 2005, 5:04 pm | Uniqueidentifier GUID question | | Posts(9) | July 28, 2005, 5:04 pm | Get SQL Statement that caused the change? | | Posts(1) | July 28, 2005, 5:04 pm | Re: SQL Server means 'ß' = 'ss' is TRUE. What's | | Posts(8) | July 28, 2005, 5:04 pm | Trim leading 000 from varchar field | | Posts(8) | July 28, 2005, 5:04 pm | Removing IDENTITY from a tabe column | | Posts(5) | July 28, 2005, 5:04 pm | Permissions problem | | Posts(1) | July 28, 2005, 5:04 pm | Unique field names | | Posts(1) | July 28, 2005, 5:04 pm | Re: SQL Server means 'ß' = 'ss' | | Posts(2) | July 28, 2005, 5:04 pm | Convert varchar to numeric | | Posts(10) | July 28, 2005, 5:04 pm | Passing a Table var as an input/output parameter | | Posts(9) | July 28, 2005, 5:04 pm | Simple SELECT statement??? | | Posts(2) | July 28, 2005, 5:04 pm | Parsing a SQL Query | | Posts(4) | July 28, 2005, 5:04 pm | monitor large update | | Posts(1) | July 28, 2005, 5:04 pm | Re: SQL Server means 'ß' = 'ss' is TRUE. What's wrong? | | Posts(1) | July 28, 2005, 5:04 pm | RE: SQL Server means 'ß' = 'ss' | | Posts(4) | July 28, 2005, 5:04 pm | Archive data before deletion | | Posts(10) | July 28, 2005, 5:04 pm | Select Top @Variable * from table | | Posts(1) | July 28, 2005, 9:11 am | Re: Replace temp table with inline table-value function (ADDENDUM) | | Posts(2) | July 28, 2005, 9:11 am | numeric data | | Posts(1) | July 28, 2005, 9:11 am | RE: SQL Server means 'ß' = 'ss' | | Posts(1) | July 28, 2005, 9:11 am | Re: SQL Server means 'ß' = 'ss' is TRUE. What's wrong? | | Posts(3) | July 28, 2005, 9:11 am | David Portas on Any one? Query Help Please | | Posts(1) | July 28, 2005, 9:11 am | RE: SQL Server means 'ß' = 'ss' | | Posts(1) | July 28, 2005, 9:11 am | SQL Server means 'ß' = 'ss' is T | | Posts(14) | July 28, 2005, 9:11 am | Trouble using Table data type | | Posts(6) | July 28, 2005, 9:11 am | Performance question: Separate database or additional table? | | Posts(4) | July 28, 2005, 9:11 am | Ciclic Foreign Keys? | | Posts(7) | July 28, 2005, 9:11 am | several locations for datafiles | | Posts(6) | July 28, 2005, 9:11 am | system stored procedures output | | Posts(5) | July 28, 2005, 9:11 am | DYNAMIC USE | | Posts(3) | July 28, 2005, 9:11 am | OPENROWSET MSDASQL Microsoft Text Driver | | Posts(3) | July 28, 2005, 9:11 am | DATABASE Testing | | Posts(5) | July 28, 2005, 9:11 am | Combination of "=" and "like" in a SELECT statement | | Posts(3) | July 28, 2005, 9:11 am | update statment problem | | Posts(6) | July 28, 2005, 9:11 am | SQL TRANSACTIONS | | Posts(5) | July 28, 2005, 9:11 am | UNION and minusing 3rd result set | | Posts(4) | July 28, 2005, 9:11 am | Multilple statements inside a Transaction | | Posts(2) | July 28, 2005, 9:11 am | Connection problem with ODBC to MSDE | | Posts(6) | July 28, 2005, 4:03 am | Subquery returned more than 1 value | | Posts(4) | July 28, 2005, 4:03 am | SQL 2005 recursive XML scalar function error | | Posts(2) | July 28, 2005, 4:03 am | XSLT and SQL | | Posts(2) | July 28, 2005, 4:03 am | Failed to get the call stack! error | | Posts(3) | July 27, 2005, 10:02 pm | Stored procedure information sql server 2000 | | Posts(2) | July 27, 2005, 10:02 pm | select calls to a text file in c# | | Posts(12) | July 27, 2005, 5:08 pm | Difficult Insert where clause. | | Posts(6) | July 27, 2005, 5:08 pm | User Defined Function hang sometimes | | Posts(3) | July 27, 2005, 5:08 pm | Stored Proc to get table names | | Posts(8) | July 27, 2005, 5:08 pm | How to reset IDENTITY fields? | | Posts(1) | July 27, 2005, 5:08 pm | Re: reporting services emails | | Posts(5) | July 27, 2005, 5:08 pm | RE: Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLSer | | Posts(4) | July 27, 2005, 5:08 pm | Query Help, Please | | Posts(2) | July 27, 2005, 5:08 pm | Re: Would putting an index on a SmallDateTime field increase perfo | | Posts(2) | July 27, 2005, 5:07 pm | variable in the from clause | | Posts(10) | July 27, 2005, 5:07 pm | raiserror in trigger | | Posts(3) | July 27, 2005, 5:07 pm | Locking SQL Logins | | Posts(3) | July 27, 2005, 5:07 pm | Recommended method to avoid duplicate folio numbers | | Posts(4) | July 27, 2005, 5:07 pm | SQLXML bulkload using sp_OA procedures | | Posts(6) | July 27, 2005, 5:07 pm | Concurrently updating same row | | Posts(3) | July 27, 2005, 5:07 pm | Evil SQL Statment | | Posts(6) | July 27, 2005, 5:07 pm | Generate SQLscript for db? | | Posts(9) | July 27, 2005, 5:07 pm | Simple nested SP without Recordset | | Posts(6) | July 27, 2005, 5:07 pm | Block a truncate command | | Posts(1) | July 27, 2005, 5:07 pm | Re: Using CASE in WHERE clause | | Posts(2) | July 27, 2005, 5:07 pm | catchin errors occured in sql server with DELPHI | | Posts(4) | July 27, 2005, 5:07 pm | objec_id issue | | Posts(2) | July 27, 2005, 5:07 pm | Visio and SQL server | | Posts(17) | July 27, 2005, 5:07 pm | Clustered Index | | Posts(1) | July 27, 2005, 5:07 pm | RE: Best Way To Copy Data From One Table to another in the different d | | Posts(1) | July 27, 2005, 5:07 pm | Best Way To Copy Data From One Table to another in the different database | | Posts(2) | July 27, 2005, 5:07 pm | SQL query problem. | | Posts(3) | July 27, 2005, 5:07 pm | object auditing. | | Posts(10) | July 27, 2005, 5:07 pm | ADO recordset field limitations | | Posts(6) | July 27, 2005, 5:07 pm | Calculate 30/360, 30/365 DateDiff | | Posts(1) | July 27, 2005, 5:07 pm | SQL 2005 recursive XML scalar function error | | Posts(8) | July 27, 2005, 5:07 pm | debug a SELECT query and using variable as column name | | Posts(3) | July 27, 2005, 5:07 pm | sp_getapplock | | Posts(4) | July 27, 2005, 5:07 pm | IS Or type check on bit field | | Posts(1) | July 27, 2005, 5:07 pm | SQLPass | | Posts(4) | July 27, 2005, 5:07 pm | Ghost inside a loop | | Posts(9) | July 27, 2005, 9:05 am | Stored Procedure Parameter IP Address | | Posts(2) | July 27, 2005, 9:05 am | RAISERROR in Access project dont display message | | Posts(9) | July 27, 2005, 9:05 am | Varchar Storage and Search Techniques | | Posts(1) | July 27, 2005, 9:05 am | Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLServer 2K stored proce | | Posts(6) | July 27, 2005, 9:05 am | Loop... | | Posts(7) | July 27, 2005, 9:05 am | Populating an integer field to prepare for identity | | Posts(12) | July 27, 2005, 9:05 am | like check with null | | Posts(1) | July 27, 2005, 9:05 am | Maintaining text file uploads | | Posts(3) | July 27, 2005, 9:05 am | SP produces erroneous results? What am I doing wrong here? | | Posts(3) | July 27, 2005, 9:05 am | SQL server runs a subquery even when it's not necessary. | | Posts(4) | July 27, 2005, 9:05 am | Retrieving data from a plain file | | Posts(4) | July 27, 2005, 9:05 am | sp_getapplock | | Posts(2) | July 27, 2005, 9:05 am | Backup Failed to complete command SP_EXECUTESQL;1 | | Posts(9) | July 27, 2005, 9:05 am | Using SP with parameter = '' or NULL ? | | Posts(3) | July 27, 2005, 9:05 am | string function | | Posts(7) | July 27, 2005, 9:05 am | SQL ASP Where + AND | | Posts(2) | July 27, 2005, 9:05 am | update number accuracy | | Posts(5) | July 27, 2005, 9:05 am | returning unique data | | Posts(5) | July 27, 2005, 9:05 am | Connecting to FoxPro & Exporting to Excel | | Posts(2) | July 27, 2005, 9:05 am | rounding | | Posts(2) | July 27, 2005, 4:04 am | ASP Programming Question (build a calendar and connect with SQL Se | | Posts(1) | July 27, 2005, 4:04 am | EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters | | Posts(2) | July 27, 2005, 4:04 am | Few Questions... | | Posts(3) | July 27, 2005, 4:04 am | Fastest Way To Make Test Copy of Database | | Posts(2) | July 26, 2005, 10:05 pm | Reading Profiler CPU, reads, and writes | | Posts(3) | July 26, 2005, 10:05 pm | Deadlock question | | Posts(3) | July 26, 2005, 10:05 pm | my issues with FT Search | | Posts(6) | July 26, 2005, 10:05 pm | How to insert a line break into table field using T-SQL | | Posts(5) | July 26, 2005, 10:05 pm | Should I use table locking? | | Posts(4) | July 26, 2005, 10:05 pm | Quick question regarding Foreign Keys | | Posts(3) | July 26, 2005, 5:04 pm | Connection pooling and timeouts | | Posts(13) | July 26, 2005, 5:04 pm | Looking for a Good HEX editor | | Posts(2) | July 26, 2005, 5:04 pm | rounding | | Posts(3) | July 26, 2005, 5:04 pm | Duplicating data | | Posts(5) | July 26, 2005, 5:04 pm | SQL2K:How to insure that data is NOT recoverable by forensic metho | | Posts(2) | July 26, 2005, 5:04 pm | help with sort | | Posts(14) | July 26, 2005, 5:04 pm | SQL Stored Proc Select question | | Posts(4) | July 26, 2005, 5:04 pm | update using values from another table | | Posts(2) | July 26, 2005, 5:04 pm | generating scripts in SqlServer 2005? | | Posts(2) | July 26, 2005, 5:04 pm | HOWTO Validate a user's login id and password against an LDAP from | | Posts(8) | July 26, 2005, 5:04 pm | order by | | Posts(4) | July 26, 2005, 5:04 pm | CHECK ()? |
|
|