Home > Archive > SQL Server Programming > June 2006
Pages: [1] 2 3 4 5 6 7
| Posts(6) | June 30, 2006, 10:01 pm | Progress and 4GL verses SQL Server and VB/VBA | | Posts(11) | June 30, 2006, 10:01 pm | update column with cursor | | Posts(24) | June 30, 2006, 10:01 pm | Identity keys in a One-to-Zero-or-Many relationship | | Posts(11) | June 30, 2006, 10:01 pm | Passing a parameter as list in a Stored procedure | | Posts(3) | June 30, 2006, 7:05 pm | Help with select statement | | Posts(9) | June 30, 2006, 7:05 pm | How to count existing items?? | | Posts(2) | June 30, 2006, 7:05 pm | Counting Consecutive days in SQL | | Posts(10) | June 30, 2006, 7:05 pm | How do I make xp_cmdshell transactions run on the client instead of the server | | Posts(5) | June 30, 2006, 7:05 pm | Data is there BUT could NOT find it! | | Posts(2) | June 30, 2006, 7:05 pm | Help with Update, then Insert what wasn't updated statement. | | Posts(3) | June 30, 2006, 7:05 pm | TimeStamp as a String/VarChar | | Posts(5) | June 30, 2006, 7:05 pm | Declare in a view | | Posts(3) | June 30, 2006, 7:05 pm | SQLCMD question | | Posts(3) | June 30, 2006, 7:05 pm | Backup using TSQL Question | | Posts(4) | June 30, 2006, 7:05 pm | Re: Frustrating: Can't get to Provider Options in SQL 2005 Express | | Posts(1) | June 30, 2006, 7:04 pm | SQL Mail Audit | | Posts(2) | June 30, 2006, 7:04 pm | When sql express management studio final version will be released ? | | Posts(4) | June 30, 2006, 7:04 pm | Deleting records from two tables | | Posts(9) | June 30, 2006, 7:04 pm | String or binary data will be truncated. How? | | Posts(2) | June 30, 2006, 7:04 pm | SQL 2005 DML Triggers Auditing | | Posts(2) | June 30, 2006, 7:04 pm | Update a field after a user logs in | | Posts(6) | June 30, 2006, 7:04 pm | Tring to replace a Line Break with a <br> | | Posts(8) | June 30, 2006, 7:04 pm | Incorrect information from a "View" | | Posts(8) | June 30, 2006, 7:04 pm | Function results | | Posts(1) | June 30, 2006, 7:04 pm | Surprizingly poor .NET performance in SQL Server | | Posts(4) | June 30, 2006, 7:04 pm | sql 2000 UDF return table function | | Posts(2) | June 30, 2006, 7:04 pm | Code 128 from SQL | | Posts(3) | June 30, 2006, 7:04 pm | How to sort | | Posts(4) | June 30, 2006, 7:04 pm | Do not Display "NULL" in Results tab | | Posts(4) | June 30, 2006, 8:03 am | alternative to union | | Posts(4) | June 30, 2006, 8:03 am | Need to calculate a weighted average using sql | | Posts(3) | June 30, 2006, 8:03 am | Diagram of the SP relations | | Posts(7) | June 30, 2006, 8:03 am | Search | | Posts(2) | June 30, 2006, 8:03 am | Can't create fulltextcatalogs | | Posts(9) | June 30, 2006, 8:03 am | ORDER BY DATETIME field BUG? | | Posts(3) | June 30, 2006, 8:03 am | Programmatic access to Enabled Protocols in SQL2005? | | Posts(2) | June 30, 2006, 8:03 am | Cursor type changed? | | Posts(4) | June 30, 2006, 8:03 am | SQLXML 4.0 "timestamp" updategram question | | Posts(6) | June 30, 2006, 8:03 am | Interesting interview question........... | | Posts(13) | June 30, 2006, 8:03 am | Help on a Query | | Posts(4) | June 30, 2006, 8:03 am | Update of field if parameter is not null | | Posts(2) | June 30, 2006, 8:03 am | Currency conversion | | Posts(3) | June 30, 2006, 4:04 am | calculated columns in a table | | Posts(9) | June 30, 2006, 4:04 am | Populating the gaps in a data series | | Posts(1) | June 30, 2006, 4:04 am | SQL Server - Concurrent update | | Posts(18) | June 30, 2006, 4:04 am | SQL for columnized totals | | Posts(7) | June 30, 2006, 4:04 am | Exception_Access_Violation Error? | | Posts(14) | June 30, 2006, 4:04 am | Can't be rocket science to delete data older than 30 days? | | Posts(9) | June 30, 2006, 4:04 am | selecting on a null col. | | Posts(3) | June 30, 2006, 4:04 am | How to assign the result of READTEXT to a variable? | | Posts(15) | June 30, 2006, 4:04 am | sql2k5 - row updates | | Posts(2) | June 30, 2006, 4:04 am | CTE, I have a dream... | | Posts(2) | June 30, 2006, 4:04 am | Back Up Strategy | | Posts(3) | June 30, 2006, 4:04 am | simple query for someone ! need a ickle bit of help | | Posts(8) | June 30, 2006, 4:04 am | How to return error from CLR Stored Procedure | | Posts(9) | June 30, 2006, 4:04 am | Contents of a SP | | Posts(3) | June 30, 2006, 4:04 am | Date Conversion Help | | Posts(3) | June 29, 2006, 10:01 pm | What makes BCP out fast? | | Posts(2) | June 29, 2006, 10:01 pm | Join 2 colums | | Posts(7) | June 29, 2006, 10:01 pm | Retrieving NEWSEQUENTIALID | | Posts(2) | June 29, 2006, 10:01 pm | XML Query | | Posts(3) | June 29, 2006, 7:06 pm | Basic Insted Of Insert Trigger | | Posts(5) | June 29, 2006, 7:06 pm | Advice on SQL statement please. | | Posts(2) | June 29, 2006, 7:06 pm | Performance Problems Restoring SQL 7 Win2000 DB To SQL 2000 Win2003 x64 | | Posts(2) | June 29, 2006, 7:06 pm | SQL Statement for finding duplicates | | Posts(2) | June 29, 2006, 7:06 pm | Bulk Insert Problem | | Posts(32) | June 29, 2006, 7:06 pm | Generate random seed on a huge table | | Posts(9) | June 29, 2006, 7:06 pm | Determine if more than one row returned | | Posts(2) | June 29, 2006, 7:06 pm | Help with a Query | | Posts(4) | June 29, 2006, 7:06 pm | Is 'SET NOCOUNT OFF' required? | | Posts(4) | June 29, 2006, 7:06 pm | Select Each User last login time | | Posts(17) | June 29, 2006, 7:06 pm | creating Powerpoint presentations (etc) from SS 2000 T-SQL | | Posts(6) | June 29, 2006, 7:06 pm | help selecting all rows that contains no null value | | Posts(1) | June 29, 2006, 7:06 pm | String Load Error during C# RMO replication??? | | Posts(3) | June 29, 2006, 7:06 pm | CASE function | | Posts(9) | June 29, 2006, 7:06 pm | Find subsequent days | | Posts(7) | June 29, 2006, 7:06 pm | Update DateTime field to Date only | | Posts(10) | June 29, 2006, 7:06 pm | Insert in every ID | | Posts(2) | June 29, 2006, 7:06 pm | SqlDependency fails when not connected to domain | | Posts(1) | June 29, 2006, 7:06 pm | Re: Announcing a new SQL Comparison tool – get your free copy, no catch | | Posts(2) | June 29, 2006, 7:05 pm | RE: Issues with SourceSafe integration with Sql Server Management | | Posts(4) | June 29, 2006, 7:05 pm | date comparison | | Posts(4) | June 29, 2006, 7:05 pm | SP Flow of Control | | Posts(1) | June 29, 2006, 7:05 pm | Visio 2003 and SqlServer 2005 | | Posts(3) | June 29, 2006, 7:05 pm | Common Table Expressions | | Posts(1) | June 29, 2006, 8:37 am | Apostrophes and Dynamic SQL ASP | | Posts(1) | June 29, 2006, 8:02 am | Announcing a new SQL Comparison tool – get your free copy, no catch | | Posts(9) | June 29, 2006, 8:02 am | Rounding error when using UPDATE function | | Posts(3) | June 29, 2006, 8:02 am | Query help | | Posts(1) | June 29, 2006, 8:02 am | How to connect to a remote SQL server through a proxy server? | | Posts(3) | June 29, 2006, 8:02 am | Rights running Exec (SQL) | | Posts(3) | June 29, 2006, 8:02 am | text searching in stored procedures | | Posts(6) | June 29, 2006, 8:02 am | Group By Error Under SQL 2005 | | Posts(2) | June 29, 2006, 8:02 am | Current Process | | Posts(2) | June 29, 2006, 4:07 am | Eleminate trailing zeros in the numeric field | | Posts(2) | June 29, 2006, 4:07 am | Issues with SourceSafe integration with Sql Server Management Stud | | Posts(10) | June 29, 2006, 4:07 am | Finding Parameters in SP | | Posts(10) | June 29, 2006, 4:07 am | UPDATE/ALTER performance | | Posts(2) | June 29, 2006, 4:07 am | sp_helpdevice - How do I access the Return Code within TSQL ? | | Posts(7) | June 28, 2006, 10:02 pm | sp_adduser | | Posts(5) | June 28, 2006, 10:02 pm | How is his done | | Posts(1) | June 28, 2006, 10:02 pm | Urgent: Concurrency in SQL Server 2005: How to use granularity of Locks in Snapshot i | | Posts(4) | June 28, 2006, 10:02 pm | Simple problem doing my head in... | | Posts(7) | June 28, 2006, 7:05 pm | Having some trouble with this select statement... | | Posts(5) | June 28, 2006, 7:05 pm | Decimal division results do not round as expected | | Posts(3) | June 28, 2006, 7:05 pm | Does Database Exist? | | Posts(1) | June 28, 2006, 7:05 pm | Decimal division results do not round as expected | | Posts(5) | June 28, 2006, 7:05 pm | All Required Data Is Not Immediately Available - What to do? | | Posts(3) | June 28, 2006, 7:05 pm | Cancel remaining tasks | | Posts(5) | June 28, 2006, 7:05 pm | Inserting characters into MS SQL Table records | | Posts(3) | June 28, 2006, 7:05 pm | call a stored proc from a stored proc | | Posts(7) | June 28, 2006, 7:05 pm | Performance difference using IN or OR | | Posts(9) | June 28, 2006, 7:05 pm | UDT, what's the point? | | Posts(9) | June 28, 2006, 7:05 pm | Convert $ to varchar decimal problem | | Posts(2) | June 28, 2006, 7:05 pm | Count In Between Two Dates | | Posts(3) | June 28, 2006, 7:05 pm | DTS Package Problem | | Posts(12) | June 28, 2006, 7:05 pm | Calling UDF in where clause | | Posts(4) | June 28, 2006, 7:05 pm | Connect to another db on the same server | | Posts(3) | June 28, 2006, 7:05 pm | sp_spaceused on sql server 2000 | | Posts(5) | June 28, 2006, 7:05 pm | Cascade Inserts/Clone a tree | | Posts(4) | June 28, 2006, 7:05 pm | MSDTC Unavailable Windows 2003 | | Posts(4) | June 28, 2006, 7:05 pm | Easiest way to accomplish sum | | Posts(3) | June 28, 2006, 7:05 pm | Frustrating: Can't get to Provider Options in SQL 2005 Express?? | | Posts(7) | June 28, 2006, 7:05 pm | complex Query | | Posts(2) | June 28, 2006, 7:05 pm | Developing a client server app using SQLServer - Steps | | Posts(20) | June 28, 2006, 7:05 pm | Alternate ways of deleting records - without logging | | Posts(10) | June 28, 2006, 7:05 pm | Finding the first available number in a series. | | Posts(4) | June 28, 2006, 7:05 pm | Shrink and reindex ? | | Posts(1) | June 28, 2006, 7:05 pm | SQL Server 2005 debugger | | Posts(2) | June 28, 2006, 7:05 pm | Sql 2005 Inserting Small Float - Get error is not a valid instance | | Posts(5) | June 28, 2006, 7:05 pm | Data Conversion Problem | | Posts(6) | June 28, 2006, 7:05 pm | Error creating login - Incorrect syntax near 'LOGIN'. | | Posts(3) | June 28, 2006, 7:05 pm | Database Trigger on Update Table | | Posts(7) | June 28, 2006, 7:05 pm | 'field name' is not a recognized OPTIMIZER LOCK HINTS option | | Posts(5) | June 28, 2006, 7:05 pm | Block Duration in SQL Server 2000 | | Posts(4) | June 28, 2006, 7:05 pm | Dates for previous week | | Posts(3) | June 28, 2006, 7:05 pm | Database migration from SQL 2000 to SQL 2005 | | Posts(2) | June 28, 2006, 7:05 pm | Saving files in Windows ascii text in SQL 2005 management studio | | Posts(2) | June 28, 2006, 7:05 pm | How to output the result of a query to a file | | Posts(1) | June 28, 2006, 4:06 am | kader | | Posts(2) | June 28, 2006, 4:06 am | how should be the query for this result | | Posts(4) | June 28, 2006, 4:06 am | Query execution time problem | | Posts(2) | June 28, 2006, 4:06 am | LINK SERVER BAD PERFORMANTCE | | Posts(1) | June 28, 2006, 4:06 am | MSDTC Transaction Errors | | Posts(5) | June 28, 2006, 4:06 am | INSERT | | Posts(1) | June 28, 2006, 4:06 am | Re: Sql 2005 Inserting Small Float - Get error is not a valid instance of data type f | | Posts(4) | June 28, 2006, 4:06 am | Select Statement - Need Help with this | | Posts(1) | June 27, 2006, 11:15 pm | Export Database using DTS Import/Export Wizard | | Posts(2) | June 27, 2006, 10:01 pm | SELECT statement help | | Posts(14) | June 27, 2006, 7:06 pm | Job Scheduling | | Posts(2) | June 27, 2006, 7:06 pm | get byte site of a row? | | Posts(9) | June 27, 2006, 7:06 pm | Cannot Trap Specific Errors | | Posts(10) | June 27, 2006, 7:06 pm | Dynamic SQL Help | | Posts(2) | June 27, 2006, 7:06 pm | CLR performance | | Posts(10) | June 27, 2006, 7:06 pm | Query Performance Problem | | Posts(11) | June 27, 2006, 7:06 pm | Using trigger to update preceding record | | Posts(9) | June 27, 2006, 7:06 pm | Indexes - general question | | Posts(9) | June 27, 2006, 7:06 pm | explanation of update statement | | Posts(4) | June 27, 2006, 7:06 pm | Have Insert statement, need equivalent Update. | | Posts(3) | June 27, 2006, 7:06 pm | Timestamp Debugging in SQL 2005 | | Posts(6) | June 27, 2006, 7:06 pm | Division Calc in Column Returns 0's or 1's | | Posts(1) | June 27, 2006, 7:06 pm | Executing SSIS Package? | | Posts(3) | June 27, 2006, 7:06 pm | ADO Connection, Enterprise Manager and table locks? | | Posts(2) | June 27, 2006, 7:06 pm | Export to text file | | Posts(6) | June 27, 2006, 7:06 pm | SQL Server 2000 - UDF for Encryption | | Posts(11) | June 27, 2006, 7:06 pm | Master database | | Posts(4) | June 27, 2006, 7:06 pm | Using #s in MS Access Sql string problem | | Posts(6) | June 27, 2006, 7:06 pm | Record locking? Well... not exactly... | | Posts(4) | June 27, 2006, 7:06 pm | Export to text file | | Posts(4) | June 27, 2006, 7:06 pm | IsNull() / Coalesce() Performance help | | Posts(2) | June 27, 2006, 7:06 pm | xp_sendmail | | Posts(1) | June 27, 2006, 7:06 pm | Re: Job Scheduling -- Please | | Posts(3) | June 27, 2006, 7:06 pm | Re: The conversion of a char data type to a datetime data type res | | Posts(4) | June 27, 2006, 7:06 pm | Results of SELECT into XML | | Posts(1) | June 27, 2006, 7:06 pm | how to stagger reporting services scheduled deliveries? | | Posts(1) | June 27, 2006, 7:06 pm | RE: Is there an SQL query that will show 1) All logins for a db an | | Posts(4) | June 27, 2006, 7:06 pm | creating procedures | | Posts(7) | June 27, 2006, 7:06 pm | Transfer data | | Posts(11) | June 27, 2006, 7:06 pm | Dateformat | | Posts(2) | June 27, 2006, 7:06 pm | Is there an SQL query that will show 1) All logins for a db and... | | Posts(5) | June 27, 2006, 7:06 pm | auto number via a query | | Posts(3) | June 27, 2006, 7:06 pm | CASE statement | | Posts(1) | June 27, 2006, 7:06 pm | Re: The conversion of a char data type to a datetime data type res | | Posts(6) | June 27, 2006, 7:06 pm | Iterating through a recordset | | Posts(7) | June 27, 2006, 7:06 pm | Conditional join? | | Posts(4) | June 27, 2006, 7:06 pm | Enumerating jobs on a SQL server using SMO - in C# | | Posts(4) | June 27, 2006, 7:06 pm | stop SQL insert statement from inserting incorrect datestamp | | Posts(2) | June 27, 2006, 7:06 pm | DBCC LOG | | Posts(3) | June 27, 2006, 7:06 pm | DayAdd | | Posts(10) | June 27, 2006, 7:06 pm | group by qst | | Posts(2) | June 27, 2006, 7:06 pm | Sql 2005 and web services | | Posts(1) | June 27, 2006, 7:06 pm | Re: The conversion of a char data type to a datetime data type res | | Posts(1) | June 27, 2006, 7:06 pm | DTExec does not work with SQL 2000 structured storage files | | Posts(2) | June 27, 2006, 7:06 pm | Holiday schedule for scheduled DTS Packages | | Posts(4) | June 27, 2006, 7:06 pm | How to escape out single quotes from an T-SQL variable | | Posts(1) | June 27, 2006, 7:06 pm | Re: The conversion of a char data type to a datetime data type resulte | | Posts(3) | June 27, 2006, 7:06 pm | automatic backup / restore to another db | | Posts(3) | June 27, 2006, 7:06 pm | Immutability of procedure parameters | | Posts(5) | June 27, 2006, 7:06 pm | min or max over multiple columns | | Posts(4) | June 27, 2006, 7:06 pm | Import Design Question |
|
|