Home > Archive > SQL Server Programming > June 2005
Pages: [1] 2 3
| Posts(3) | June 11, 2005, 3:59 pm | About automatic process at midnight | | Posts(2) | June 11, 2005, 3:59 pm | kill logged in processes to a database | | Posts(4) | June 11, 2005, 3:59 pm | Disabling constraints | | Posts(3) | June 11, 2005, 3:59 pm | all from one table to another | | Posts(12) | June 11, 2005, 3:59 pm | Primary Key, bigint or char? | | Posts(3) | June 11, 2005, 3:59 pm | dropping a table on a linked server | | Posts(4) | June 11, 2005, 3:59 pm | Nullable Unique Constraint | | Posts(6) | June 11, 2005, 3:59 pm | After DBCC SHRINKFILE | | Posts(2) | June 11, 2005, 3:59 pm | LEFT out join question | | Posts(2) | June 11, 2005, 3:59 pm | Query Problem | | Posts(3) | June 11, 2005, 3:59 pm | transferring data to an Oracle linked server | | Posts(8) | June 11, 2005, 3:59 pm | 1 field or 2? | | Posts(4) | June 11, 2005, 3:59 pm | Query batch completed with errors... | | Posts(2) | June 11, 2005, 3:59 pm | I don't understand it | | Posts(3) | June 11, 2005, 8:58 am | Using uniqueidentifier as URL parameter | | Posts(2) | June 11, 2005, 8:58 am | Cannot truncate logfile in SQL server 2000 | | Posts(2) | June 11, 2005, 8:58 am | BizRule implementation | | Posts(2) | June 11, 2005, 8:58 am | Using insert/update/delete statement in UDF | | Posts(3) | June 11, 2005, 8:58 am | READPAST - please help me | | Posts(4) | June 11, 2005, 8:58 am | Importing text file | | Posts(4) | June 11, 2005, 8:58 am | Sysindexes | | Posts(2) | June 11, 2005, 3:58 am | Returning Date without | | Posts(3) | June 11, 2005, 3:58 am | Passing a table to a SP | | Posts(2) | June 11, 2005, 3:58 am | returning date without time part | | Posts(2) | June 11, 2005, 3:58 am | How to identify unused databases | | Posts(3) | June 11, 2005, 3:58 am | tempdb not shrinking | | Posts(4) | June 11, 2005, 3:58 am | Can't get fn_get_sql to work | | Posts(10) | June 11, 2005, 3:58 am | ntext column | | Posts(2) | June 10, 2005, 8:58 pm | Different port | | Posts(12) | June 10, 2005, 8:58 pm | Duplicate Column Names - A Good Trick to Avoid Temp Tables? | | Posts(2) | June 10, 2005, 8:58 pm | Select into | | Posts(5) | June 10, 2005, 8:58 pm | Select Question | | Posts(3) | June 10, 2005, 8:58 pm | syntax error | | Posts(11) | June 10, 2005, 8:58 pm | Instead of trigger to increment PK | | Posts(9) | June 10, 2005, 8:58 pm | Can't run SP with GETDATE() | | Posts(1) | June 10, 2005, 8:58 pm | RE: Need advice for publishing SQL DTS Packages / Automating changes f | | Posts(9) | June 10, 2005, 8:58 pm | Enterprise Manager and its particularities | | Posts(13) | June 10, 2005, 8:58 pm | Need help with slow running query | | Posts(100) | June 10, 2005, 8:58 pm | Problems with identity column | | Posts(4) | June 10, 2005, 8:58 pm | Test the impact of an index | | Posts(4) | June 10, 2005, 8:58 pm | RDO resultset performance problem | | Posts(2) | June 10, 2005, 8:58 pm | Fast "bulk" inserts... | | Posts(3) | June 10, 2005, 8:58 pm | Duplicate order nums in Orders | | Posts(4) | June 10, 2005, 8:58 pm | Uniqueidentifier or int32 | | Posts(6) | June 10, 2005, 8:58 pm | How to Transfer data from Excel to SQL SERVER 2000 | | Posts(72) | June 10, 2005, 8:58 pm | Code in the database or middle tier (the CLR controversy) | | Posts(4) | June 10, 2005, 8:58 pm | Changing table colon's properties | | Posts(3) | June 10, 2005, 8:58 pm | Duplicating rows in tables... | | Posts(8) | June 10, 2005, 8:58 pm | Moving GROUP BY Clauses | | Posts(3) | June 10, 2005, 8:58 pm | osql with proxy account errors | | Posts(2) | June 10, 2005, 8:58 pm | Dynamically creating variable names | | Posts(5) | June 10, 2005, 8:58 pm | update query | | Posts(1) | June 10, 2005, 4:03 pm | RE: updating a column based on values in another column in the sam | | Posts(3) | June 10, 2005, 4:03 pm | List Available Sql Servers | | Posts(3) | June 10, 2005, 4:03 pm | simple query | | Posts(10) | June 10, 2005, 4:03 pm | trigger doesn't seem to work w/cursor | | Posts(1) | June 10, 2005, 4:03 pm | RE: updating a column based on values in another column in the sam | | Posts(4) | June 10, 2005, 4:03 pm | Retrieve Stored Procedure Code | | Posts(3) | June 10, 2005, 4:03 pm | updating a column based on values in another column in the same ta | | Posts(6) | June 10, 2005, 4:03 pm | Weird resuld from SP | | Posts(3) | June 10, 2005, 4:03 pm | table information query | | Posts(3) | June 10, 2005, 4:03 pm | sql | | Posts(4) | June 10, 2005, 4:03 pm | Moving data and log files | | Posts(9) | June 10, 2005, 4:03 pm | release the Database Locks... | | Posts(2) | June 10, 2005, 4:03 pm | Killing xp_cmdshell | | Posts(3) | June 10, 2005, 4:03 pm | RE: 2ND POST: Is there a way to insert a record using another as a tem | | Posts(2) | June 10, 2005, 4:03 pm | Help with 1toMany update/case stmt? | | Posts(8) | June 10, 2005, 4:03 pm | How to Access network drive | | Posts(1) | June 10, 2005, 4:03 pm | Re: Warning: The query processor could not produce a query plan from the optimizer be | | Posts(1) | June 10, 2005, 4:03 pm | Re: Warning: The query processor could not produce a query plan from the optimizer be | | Posts(5) | June 10, 2005, 4:03 pm | Rand function | | Posts(3) | June 10, 2005, 4:03 pm | Filter remaining rows | | Posts(6) | June 10, 2005, 4:03 pm | Why is Insert causing duplicate records? | | Posts(4) | June 10, 2005, 4:03 pm | returning multiple values in a subquery | | Posts(7) | June 10, 2005, 4:03 pm | Database adapter? | | Posts(6) | June 10, 2005, 4:03 pm | error 63 ??? | | Posts(2) | June 10, 2005, 4:03 pm | Q: NB on the Insertion command. | | Posts(7) | June 10, 2005, 4:03 pm | VAT decimal places | | Posts(7) | June 10, 2005, 4:03 pm | Too much to join | | Posts(5) | June 10, 2005, 4:03 pm | create table with dynamic constraint | | Posts(1) | June 10, 2005, 4:03 pm | Re: 2ND POST: Is there a way to insert a record using another as a tem | | Posts(1) | June 10, 2005, 4:03 pm | Data Mining | | Posts(1) | June 10, 2005, 4:03 pm | Warning: The query processor could not produce a query plan from the optimizer becaus | | Posts(2) | June 10, 2005, 4:03 pm | Inner Joins | | Posts(1) | June 10, 2005, 4:03 pm | Oracle to Sql Server Migration | | Posts(5) | June 10, 2005, 4:03 pm | Join and duplicate values | | Posts(2) | June 10, 2005, 4:03 pm | Changing table properties | | Posts(1) | June 10, 2005, 4:03 pm | Oracle to Sql Server Migration | | Posts(4) | June 10, 2005, 4:03 pm | 2ND POST: Is there a way to insert a record using another as a template? | | Posts(2) | June 10, 2005, 4:03 pm | SQL Server Mail box - xp_readmail | | Posts(8) | June 10, 2005, 4:03 pm | query on recursive table | | Posts(10) | June 10, 2005, 4:03 pm | SET IDENTITY_INSERT | | Posts(2) | June 10, 2005, 8:59 am | Reset Identity | | Posts(3) | June 10, 2005, 8:59 am | Problem with varchar(max) in SQL Server 2005 | | Posts(4) | June 10, 2005, 8:59 am | Error 8152 | | Posts(2) | June 10, 2005, 8:59 am | T-SQL and primary key | | Posts(2) | June 10, 2005, 8:59 am | Adjusting Employee Hours | | Posts(3) | June 10, 2005, 8:59 am | Backup from server 1 and restore to server2. | | Posts(4) | June 10, 2005, 8:59 am | string filteration | | Posts(3) | June 10, 2005, 8:59 am | Changing table properties | | Posts(4) | June 10, 2005, 8:59 am | Scandinavian collation | | Posts(2) | June 10, 2005, 8:59 am | Making a view | | Posts(6) | June 10, 2005, 4:03 am | Hierarchical Result Set! | | Posts(4) | June 10, 2005, 4:03 am | SELECT for consecutive runs ofvalues | | Posts(2) | June 10, 2005, 4:03 am | Query Help | | Posts(7) | June 10, 2005, 4:03 am | Any facility to hold string data of length more than 8000 characters? | | Posts(2) | June 10, 2005, 4:03 am | Re: UPDATE SET.... ORDER BY? Help! Assumed working... but not | | Posts(1) | June 10, 2005, 4:03 am | Let this SQL Server ADO.NET code generator write the code for you | | Posts(2) | June 10, 2005, 4:03 am | Re: UPDATE SET.... ORDER BY? Help! Assumed working... but not yet. | | Posts(2) | June 10, 2005, 4:03 am | multi excel files to sql server | | Posts(1) | June 10, 2005, 4:03 am | Re: Need-a-Guru: Gaps in Sequences - Part II | | Posts(13) | June 10, 2005, 4:03 am | Need-a-Guru: Gaps in Sequences | | Posts(4) | June 9, 2005, 8:59 pm | update statement | | Posts(2) | June 9, 2005, 8:59 pm | subquery help | | Posts(8) | June 9, 2005, 8:59 pm | Trigger question. | | Posts(1) | June 9, 2005, 8:59 pm | Re: create table with dynamic constraint - SOLVED | | Posts(2) | June 9, 2005, 8:59 pm | stored procedure and views | | Posts(4) | June 9, 2005, 8:59 pm | Case setup for multiple fields | | Posts(3) | June 9, 2005, 8:59 pm | Grouping by defined number of days. | | Posts(4) | June 9, 2005, 8:59 pm | importing delimited files... | | Posts(8) | June 9, 2005, 8:59 pm | How Eliminate Dupes from MAX DATE | | Posts(4) | June 9, 2005, 8:59 pm | How to optimize this query | | Posts(3) | June 9, 2005, 8:59 pm | Release date of SQL Server 2005 | | Posts(4) | June 9, 2005, 8:59 pm | Just a concept | | Posts(1) | June 9, 2005, 8:59 pm | Address Selection Query | | Posts(5) | June 9, 2005, 8:59 pm | Case Syntax | | Posts(2) | June 9, 2005, 8:59 pm | dynamic sql w/sp_executesql - servername parameter issue | | Posts(4) | June 9, 2005, 8:59 pm | Proper Case Syntax on Name Column | | Posts(3) | June 9, 2005, 8:59 pm | SQL timeout while adding 2 new columns to table | | Posts(1) | June 9, 2005, 4:02 pm | Need advice for publishing SQL DTS Packages / Automating changes | | Posts(6) | June 9, 2005, 4:02 pm | Primary key at the beggning of each record | | Posts(3) | June 9, 2005, 4:02 pm | Select statement | | Posts(2) | June 9, 2005, 4:02 pm | Time Math | | Posts(4) | June 9, 2005, 4:02 pm | Suppress raiserror in transact-sql job? | | Posts(5) | June 9, 2005, 4:02 pm | ER Diagram | | Posts(1) | June 9, 2005, 4:02 pm | Timeout on commit | | Posts(1) | June 9, 2005, 4:02 pm | Pretty much my thoughts ... | | Posts(4) | June 9, 2005, 4:02 pm | Profiler Specific Stored Procedure | | Posts(3) | June 9, 2005, 4:02 pm | Transactions | | Posts(3) | June 9, 2005, 4:02 pm | About my way to insert rows. | | Posts(8) | June 9, 2005, 4:02 pm | convert to string to execute ? | | Posts(1) | June 9, 2005, 4:02 pm | Adjusting Employee Hours | | Posts(2) | June 9, 2005, 4:02 pm | different records result if a use N (unicode data) | | Posts(2) | June 9, 2005, 4:02 pm | Chunked Delete? | | Posts(3) | June 9, 2005, 4:02 pm | How do I speed up this self-referencing query? | | Posts(4) | June 9, 2005, 4:02 pm | Help! Two-Part SQL Update | | Posts(1) | June 9, 2005, 4:02 pm | Is there a way to insert a record using another as a template? | | Posts(2) | June 9, 2005, 4:02 pm | How to do this in a report? | | Posts(5) | June 9, 2005, 4:02 pm | Disregard null parameter in WHERE clause | | Posts(1) | June 9, 2005, 4:02 pm | Fun with Maintenance plan scripting | | Posts(5) | June 9, 2005, 4:02 pm | Amazing logical error in sql query | | Posts(3) | June 9, 2005, 4:02 pm | Calculating the adjustment of employee hours | | Posts(6) | June 9, 2005, 9:00 am | Is it Possible to download mails? | | Posts(2) | June 9, 2005, 8:59 am | YTD problem - adding extra field to table | | Posts(11) | June 9, 2005, 8:59 am | Timestamp datatype in MS-SQL Server | | Posts(1) | June 9, 2005, 8:59 am | Re: unable to open web project. Gives the following error "The connection with t | | Posts(11) | June 9, 2005, 8:59 am | need help with sample query | | Posts(4) | June 9, 2005, 8:59 am | Execute Script From C# Application Rather Than From QA | | Posts(2) | June 9, 2005, 8:59 am | SQL Server Query Analyzer Debug Question | | Posts(4) | June 9, 2005, 8:59 am | ALTER TABLE MyT ALTER COLUMN IdtyCol t_idty NOT NULL Identity | | Posts(1) | June 9, 2005, 8:59 am | something for procedure | | Posts(3) | June 9, 2005, 8:59 am | ISO 11179-5 for element naming | | Posts(1) | June 9, 2005, 3:59 am | Re: unable to open web project. Gives the following error "The connection with t | | Posts(2) | June 9, 2005, 3:59 am | assigning process priority to transactions? | | Posts(8) | June 9, 2005, 3:59 am | 64 bit SQL | | Posts(1) | June 9, 2005, 3:59 am | unable to open web project. Gives the following error "The connection with the s | | Posts(1) | June 9, 2005, 3:59 am | Re: Arithmetic with integer and money data types produces invalid | | Posts(4) | June 9, 2005, 3:59 am | Unclosed Quotation Mark before the Character -- Error | | Posts(2) | June 9, 2005, 3:59 am | sp_recompile & table-valued UDF -- Possible BUG? | | Posts(1) | June 9, 2005, 3:59 am | Arithmetic with integer and money data types produces invalid results | | Posts(3) | June 9, 2005, 3:59 am | VARCHAR not evaluating properly | | Posts(8) | June 9, 2005, 3:59 am | help docs for osql.exe parameters | | Posts(4) | June 9, 2005, 3:59 am | Image Column Data and Backup | | Posts(4) | June 8, 2005, 8:59 pm | Bulk Insert From Client PC | | Posts(3) | June 8, 2005, 8:59 pm | SQL question | | Posts(4) | June 8, 2005, 8:59 pm | Monitoring ... | | Posts(6) | June 8, 2005, 8:59 pm | SQL statement that removes characters | | Posts(3) | June 8, 2005, 8:59 pm | Executing SP From a Batch file | | Posts(2) | June 8, 2005, 8:59 pm | Database Locking | | Posts(3) | June 8, 2005, 8:59 pm | Group by performance | | Posts(4) | June 8, 2005, 8:59 pm | Query Analyzer | | Posts(8) | June 8, 2005, 8:59 pm | Rounding datetime values down | | Posts(10) | June 8, 2005, 8:59 pm | Retrieve data but with all the services stopped | | Posts(7) | June 8, 2005, 8:59 pm | How to find transposed data and near misses | | Posts(3) | June 8, 2005, 8:59 pm | Mid Data Point | | Posts(4) | June 8, 2005, 8:59 pm | query problem | | Posts(7) | June 8, 2005, 8:59 pm | Calculation for adjusting employee hours | | Posts(1) | June 8, 2005, 8:59 pm | Further more | | Posts(3) | June 8, 2005, 8:59 pm | finding out which columns are in an index. | | Posts(5) | June 8, 2005, 8:59 pm | Returning uniqueidentifier after insert | | Posts(1) | June 8, 2005, 4:02 pm | How to fid out replication is healty | | Posts(5) | June 8, 2005, 4:02 pm | Sql Locking problems | | Posts(3) | June 8, 2005, 4:02 pm | system variable for hostname? | | Posts(3) | June 8, 2005, 4:02 pm | How to determine the domain for sp_grantlogin? | | Posts(6) | June 8, 2005, 4:02 pm | selecting insert into another database | | Posts(2) | June 8, 2005, 4:02 pm | Dynamic Crosstab | | Posts(6) | June 8, 2005, 4:02 pm | Help with sql | | Posts(1) | June 8, 2005, 4:02 pm | Re: Login failed for user '(null)' - Not associated with a trusted | | Posts(5) | June 8, 2005, 4:02 pm | Good Question | | Posts(2) | June 8, 2005, 4:02 pm | help with sqlserver errors |
|
|