Home > Archive > SQL Server Programming > March 2006
Pages: [1] 2 3 4 5 6 7 8
| Posts(5) | March 31, 2006, 7:05 pm | Remotely update database | | Posts(7) | March 31, 2006, 7:05 pm | Best way to convert 3/17/2006 to 03172006? use case? | | Posts(5) | March 31, 2006, 7:05 pm | Alter table statement | | Posts(2) | March 31, 2006, 7:05 pm | converting binary data to another data type | | Posts(9) | March 31, 2006, 7:05 pm | How to set Concurrent execution of 2 insert statements | | Posts(3) | March 31, 2006, 7:05 pm | SQL Job behavior...Not Quit on Failure? | | Posts(5) | March 31, 2006, 7:05 pm | Seek clever solution to detect deletion | | Posts(2) | March 31, 2006, 7:05 pm | Data entry table not editable in Access ADP - what do I need to do | | Posts(3) | March 31, 2006, 7:05 pm | Dynamic SQL help | | Posts(3) | March 31, 2006, 7:05 pm | re-creating SP without having to delete previous version? | | Posts(4) | March 31, 2006, 7:05 pm | DataBase Design Problem.... | | Posts(3) | March 31, 2006, 7:05 pm | Integration services | | Posts(9) | March 31, 2006, 7:05 pm | Question about Count (*) | | Posts(4) | March 31, 2006, 7:05 pm | How to delete records on dependent tables? Thank You. | | Posts(2) | March 31, 2006, 7:05 pm | Query Two Databases | | Posts(3) | March 31, 2006, 7:05 pm | Any Ideas? SQL teaser | | Posts(1) | March 31, 2006, 7:05 pm | Re: What is the maximum level to which a database can be normalized for optimal perfo | | Posts(1) | March 31, 2006, 7:05 pm | Re: What is the maximum level to which a database can be normalized for optimal perfo | | Posts(3) | March 31, 2006, 7:05 pm | Insert one table into another but also insert a variable | | Posts(9) | March 31, 2006, 7:05 pm | Help - Just using the time of DateTime or SmallDateTime | | Posts(7) | March 31, 2006, 7:05 pm | table check constraint function | | Posts(9) | March 31, 2006, 7:05 pm | Splitting a Name Field | | Posts(3) | March 31, 2006, 7:05 pm | Normalize data issue. | | Posts(1) | March 31, 2006, 7:05 pm | Re: What is the maximum level to which a database can be normalized for optimal perfo | | Posts(1) | March 31, 2006, 7:05 pm | Re: What is the maximum level to which a database can be normalized for optimal perfo | | Posts(4) | March 31, 2006, 7:05 pm | Re: criteria for a datetime field | | Posts(1) | March 31, 2006, 7:05 pm | Re: why is there a gap in the identity value created in the identi | | Posts(1) | March 31, 2006, 8:04 am | What is the maximum level to which a database can be normalized for optimal performan | | Posts(2) | March 31, 2006, 8:04 am | SQL Server remote start/stop | | Posts(1) | March 31, 2006, 8:04 am | Re: why is there a gap in the identity value created in the identi | | Posts(8) | March 31, 2006, 8:04 am | 2-nd edition of Celko Puzzle book in the works | | Posts(4) | March 31, 2006, 8:04 am | fileLen function in stored procedure | | Posts(1) | March 31, 2006, 8:04 am | Re: why is there a gap in the identity value created in the identi | | Posts(6) | March 31, 2006, 8:04 am | Auto join in SQL Query | | Posts(4) | March 31, 2006, 8:04 am | select with numbering | | Posts(3) | March 31, 2006, 4:08 am | Does SQL Server cache data? | | Posts(1) | March 31, 2006, 4:08 am | The transaction has exceeded the allotted time | | Posts(1) | March 31, 2006, 4:08 am | OpenQuery | | Posts(1) | March 31, 2006, 4:08 am | Stored procedures parametriche | | Posts(13) | March 31, 2006, 4:08 am | Framework Equivalent in MSSQL? | | Posts(2) | March 31, 2006, 4:08 am | fastest way to do this? | | Posts(1) | March 31, 2006, 4:08 am | RE: What 's the purpose of Rollback if SQL-SERVER Transcation are full | | Posts(8) | March 31, 2006, 4:08 am | Error connecting to SQLExpress 2005 locally | | Posts(2) | March 31, 2006, 4:08 am | Emptying Log file | | Posts(2) | March 31, 2006, 4:08 am | Re: Emptying Log file | | Posts(1) | March 31, 2006, 4:08 am | >@>@>@>@>GET MORE CHICKS............LEARN GUITAR............. | | Posts(1) | March 31, 2006, 4:08 am | <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%& | | Posts(3) | March 31, 2006, 4:08 am | passing table variables into functions | | Posts(6) | March 31, 2006, 4:08 am | Searching for script/tools to find hard code database names. | | Posts(6) | March 31, 2006, 4:08 am | The IDENTITY function can only be used when the SELECT statement has an INTO clause | | Posts(1) | March 31, 2006, 4:08 am | Illegal Immigration, the Non-Issue of the Week?????????????? | | Posts(1) | March 31, 2006, 4:08 am | Will illegal immigrants get deported?.........Of course not..................... | | Posts(1) | March 31, 2006, 4:08 am | Amnesty for illegal immigrants will not happen this time..................... | | Posts(2) | March 30, 2006, 10:03 pm | How do I get just one set? | | Posts(1) | March 30, 2006, 10:03 pm | What 's the purpose of Rollback if SQL-SERVER Transcation are fully AICD compliant | | Posts(3) | March 30, 2006, 10:03 pm | sql questions | | Posts(1) | March 30, 2006, 10:03 pm | RE: Can I insert into the same table a new row with the "old" row fiel | | Posts(1) | March 30, 2006, 10:03 pm | Re: why is there a gap in the identity value created in the identi | | Posts(9) | March 30, 2006, 10:03 pm | Error when trying to create new SQL Server login via ado.Net | | Posts(4) | March 30, 2006, 10:03 pm | Recursive Query/CTE - SQL 2K5 | | Posts(1) | March 30, 2006, 10:03 pm | Cross-Database Updates | | Posts(1) | March 30, 2006, 10:03 pm | RE: The IDENTITY function can only be used when the SELECT statement h | | Posts(10) | March 30, 2006, 7:06 pm | How to configure MemToLeave memory option? | | Posts(1) | March 30, 2006, 7:06 pm | AtLeast Function | | Posts(3) | March 30, 2006, 7:06 pm | Incorrect Syantax | | Posts(3) | March 30, 2006, 7:06 pm | self-joined table query | | Posts(2) | March 30, 2006, 7:06 pm | T-SQL Question | | Posts(1) | March 30, 2006, 7:06 pm | how to add a cube template in sql2k5 analysis service? | | Posts(6) | March 30, 2006, 7:06 pm | Is there an easier way to do multiple aggregate columns in tsql | | Posts(1) | March 30, 2006, 7:06 pm | RE: Can I insert into the same table a new row with the "old" row fiel | | Posts(2) | March 30, 2006, 7:06 pm | Need help with count aggregate function that kills performance | | Posts(5) | March 30, 2006, 7:06 pm | batch (.bat) file from sql server? | | Posts(4) | March 30, 2006, 7:06 pm | What is the "current session" for a local temp table? | | Posts(1) | March 30, 2006, 7:06 pm | Re: Maintaining Foreign Key Relationships on Identity Fields when Copying Data Across | | Posts(1) | March 30, 2006, 7:06 pm | Restore a database backed up in another instance | | Posts(10) | March 30, 2006, 7:06 pm | Is this statement vulnerable to code injection? | | Posts(6) | March 30, 2006, 7:06 pm | Trouble in using bcp to get data into table for MS SQL 2005 | | Posts(4) | March 30, 2006, 7:06 pm | Appending Records + Update | | Posts(7) | March 30, 2006, 7:06 pm | I don't want user dynamic sql | | Posts(1) | March 30, 2006, 7:06 pm | RE: CLR UDT problem: Data type "0xF0" (user-defined type) has an inval | | Posts(1) | March 30, 2006, 7:06 pm | Re: Maintaining Foreign Key Relationships on Identity Fields when Copying Data Across | | Posts(6) | March 30, 2006, 7:06 pm | Store big binary files in SQLserver 05 vachar(max) column | | Posts(8) | March 30, 2006, 7:06 pm | PERFORMANCE QUESTION | | Posts(2) | March 30, 2006, 7:06 pm | Re: Physical Server Name - Found it | | Posts(36) | March 30, 2006, 7:06 pm | Any SQL Experts out there? | | Posts(9) | March 30, 2006, 7:06 pm | Properly test for existence of a temporary stored procedure | | Posts(4) | March 30, 2006, 7:06 pm | performance problem | | Posts(1) | March 30, 2006, 7:06 pm | Need help to build this Store Procedure | | Posts(5) | March 30, 2006, 7:06 pm | SQL Cute Little Ditty.... | | Posts(4) | March 30, 2006, 7:06 pm | What is SQL Server 2005 Workbench? | | Posts(1) | March 30, 2006, 7:06 pm | Re: Store multi-choice groupbox selection in a field | | Posts(2) | March 30, 2006, 7:06 pm | Substring, lazy third argument faster? | | Posts(2) | March 30, 2006, 7:06 pm | Flagging duplicate records (again) | | Posts(3) | March 30, 2006, 7:06 pm | Syntax error converting from a character string to uniqueidentifier. | | Posts(1) | March 30, 2006, 7:06 pm | CLR UDT problem: Data type "0xF0" (user-defined type) has an invalid user t | | Posts(1) | March 30, 2006, 7:06 pm | Re: Physical Server Name .. Actually it is a Sql2k Server | | Posts(7) | March 30, 2006, 7:06 pm | Linked servers using SQL Server Authentication | | Posts(5) | March 30, 2006, 7:06 pm | Stuck on Query | | Posts(7) | March 30, 2006, 7:06 pm | Does RETURN have reserved values? | | Posts(2) | March 30, 2006, 7:06 pm | RE: phantom records | | Posts(3) | March 30, 2006, 7:06 pm | If Isnull Question | | Posts(3) | March 30, 2006, 7:06 pm | Creating a database with link | | Posts(11) | March 30, 2006, 7:06 pm | Dynamic IN clause | | Posts(1) | March 30, 2006, 7:06 pm | Physical Server Name | | Posts(1) | March 30, 2006, 7:06 pm | Mirroring and replication | | Posts(2) | March 30, 2006, 7:06 pm | RE: SQL and informix | | Posts(6) | March 30, 2006, 7:06 pm | conditional WHERE clause | | Posts(4) | March 30, 2006, 7:06 pm | Simple T-SQL Question | | Posts(5) | March 30, 2006, 7:06 pm | A couple of easy questions | | Posts(4) | March 30, 2006, 7:06 pm | Combine multiple lines for one record into one comma-delimted field | | Posts(4) | March 30, 2006, 7:06 pm | help files in English (QA) | | Posts(2) | March 30, 2006, 7:06 pm | performance problem | | Posts(5) | March 30, 2006, 7:06 pm | Simple query but no results... | | Posts(2) | March 30, 2006, 12:58 pm | Free MCAD/MCSD ebooks online | | Posts(2) | March 30, 2006, 8:50 am | Error trying to retreive lastlogon value through LDAP ADSI | | Posts(5) | March 30, 2006, 8:04 am | Upgrading from 6.5 compatability to 9.0 | | Posts(6) | March 30, 2006, 8:04 am | selecting last three characters from string | | Posts(4) | March 30, 2006, 8:04 am | problem in SQL SERVER adding large size field to a table | | Posts(3) | March 30, 2006, 8:04 am | About the security | | Posts(7) | March 30, 2006, 8:04 am | Assigning Group Numbers for millions of row | | Posts(4) | March 30, 2006, 8:04 am | Data Modeling: Type + SubTypes | | Posts(5) | March 30, 2006, 8:04 am | Select Next Highest | | Posts(6) | March 30, 2006, 4:05 am | Can Timestamp column value overflow?? | | Posts(2) | March 30, 2006, 4:05 am | checksum_agg on field list not working | | Posts(3) | March 30, 2006, 4:05 am | How to develop database locally and post to web host? | | Posts(4) | March 30, 2006, 4:05 am | Trigger with Text field | | Posts(2) | March 30, 2006, 4:05 am | Error with default database collation | | Posts(3) | March 30, 2006, 4:05 am | Is VARCHAR data type same as UTF-8? | | Posts(3) | March 30, 2006, 4:05 am | Returning single value from multiple recordsets | | Posts(9) | March 30, 2006, 4:05 am | Using Indexes | | Posts(8) | March 30, 2006, 4:05 am | select distinct on all but one column but retain all columns | | Posts(2) | March 30, 2006, 4:05 am | Access ADP,Server 2000, inconsistent behavior with output paramete | | Posts(2) | March 30, 2006, 4:05 am | Query work in sql 200 fails in sql 2005 | | Posts(1) | March 30, 2006, 4:05 am | binary_checksum vs checksum_agg and checksum | | Posts(12) | March 29, 2006, 10:03 pm | Tables having Data | | Posts(8) | March 29, 2006, 10:03 pm | Help me with this Query | | Posts(7) | March 29, 2006, 10:03 pm | Summing up DateTime fields. | | Posts(4) | March 29, 2006, 10:03 pm | Select records with overlapping date range | | Posts(2) | March 29, 2006, 10:03 pm | How To Determine the FileGroup for a Table | | Posts(5) | March 29, 2006, 7:06 pm | Using Case in Where Clause | | Posts(1) | March 29, 2006, 7:06 pm | Issue getting return value from master.dbo.xp_cmdshell | | Posts(3) | March 29, 2006, 7:06 pm | Not null user defined data type does not work | | Posts(3) | March 29, 2006, 7:06 pm | Reduce function call in a Select statment | | Posts(7) | March 29, 2006, 7:06 pm | stored procedure for selective update | | Posts(2) | March 29, 2006, 7:06 pm | how to map existing Login to ASYMMETRIC KEY | | Posts(5) | March 29, 2006, 7:06 pm | Database Engine Tuning Advisor 2005 | | Posts(7) | March 29, 2006, 7:06 pm | Deleting all without contraints | | Posts(3) | March 29, 2006, 7:06 pm | Using decimal instead of int to enforce digit length? | | Posts(22) | March 29, 2006, 7:06 pm | How to perform this unique contraint? | | Posts(9) | March 29, 2006, 7:06 pm | Any way to avoid using a cursor for this? | | Posts(1) | March 29, 2006, 7:06 pm | Pre Execution Step in SSIS is taking around 15 minutes | | Posts(1) | March 29, 2006, 7:06 pm | Help with error returned by sp_makewebtask SP | | Posts(1) | March 29, 2006, 7:06 pm | RE: Using Case in Where Clause -- More Info | | Posts(9) | March 29, 2006, 7:06 pm | Cascading stock values? | | Posts(8) | March 29, 2006, 7:06 pm | 1 Huge Table vs. Many Small Tables | | Posts(4) | March 29, 2006, 7:06 pm | How do I insert data from a flat file into an existing SQL databas | | Posts(3) | March 29, 2006, 7:06 pm | Cross Database Queries in SQL Server 2000 | | Posts(1) | March 29, 2006, 7:06 pm | Not null user defined data type does not work | | Posts(7) | March 29, 2006, 7:06 pm | fixed little bit | | Posts(6) | March 29, 2006, 7:06 pm | copying data between two databases | | Posts(4) | March 29, 2006, 7:06 pm | Error when using xp_sendmail to outside recipients | | Posts(2) | March 29, 2006, 7:06 pm | ansi Joins | | Posts(2) | March 29, 2006, 7:06 pm | SQL Server 2005 express edition question ... | | Posts(6) | March 29, 2006, 7:06 pm | UDF in default constraint? | | Posts(1) | March 29, 2006, 7:06 pm | Timeout on transaction commits only | | Posts(2) | March 29, 2006, 7:06 pm | INSIDER - KNOWLEDGE NEUTRALIZING!! | | Posts(2) | March 29, 2006, 7:06 pm | Help with update | | Posts(11) | March 29, 2006, 7:06 pm | Select Statements with Inner Joins versus Comma Joins | | Posts(3) | March 29, 2006, 7:06 pm | SQL Server 2005 Index Scripting | | Posts(1) | March 29, 2006, 7:06 pm | INSIDER - KNOWLEDGE NEUTRALIZING!! | | Posts(1) | March 29, 2006, 7:06 pm | INSIDER - KNOWLEDGE NEUTRALIZING!! | | Posts(4) | March 29, 2006, 7:06 pm | Result as 'array' | | Posts(4) | March 29, 2006, 7:06 pm | Issues with creating SQL Server Jobs | | Posts(9) | March 29, 2006, 7:06 pm | Combine Many Stored Procedures into One | | Posts(10) | March 29, 2006, 7:06 pm | Nested cursors | | Posts(3) | March 29, 2006, 7:06 pm | Stored Procedure question | | Posts(4) | March 29, 2006, 7:06 pm | assign group number | | Posts(6) | March 29, 2006, 7:06 pm | MSDE (SQL Server 2000) does not return @@Identity | | Posts(8) | March 29, 2006, 7:06 pm | how to call external exe from Database Trigger | | Posts(1) | March 29, 2006, 7:06 pm | Re: replication and trigger | | Posts(4) | March 29, 2006, 7:06 pm | careless to remove data | | Posts(6) | March 29, 2006, 7:06 pm | Sql Server 2005 SP CRL C# | | Posts(3) | March 29, 2006, 8:04 am | msdb error | | Posts(3) | March 29, 2006, 8:04 am | Can SQL 2005 load assembly from GAC? | | Posts(6) | March 29, 2006, 8:04 am | LEFT JOIN section | | Posts(1) | March 29, 2006, 8:04 am | RE: Linked Server , Connection Broken Error - struggling for 4 hours n | | Posts(3) | March 29, 2006, 8:04 am | Why isnt this simple code not working.. Please Assist | | Posts(3) | March 29, 2006, 8:04 am | restore database without some tables records | | Posts(3) | March 29, 2006, 4:12 am | How to detect the current settings of ANSI_NULLS? | | Posts(3) | March 29, 2006, 4:12 am | Obtaining the time | | Posts(2) | March 29, 2006, 4:12 am | Linked Server , Connection Broken Error - struggling for 4 hours now ! | | Posts(7) | March 29, 2006, 4:12 am | Combining record sets from two tables | | Posts(3) | March 29, 2006, 4:12 am | Monitoring Filegroup Space | | Posts(2) | March 29, 2006, 4:12 am | Columns in Table renaming | | Posts(1) | March 29, 2006, 4:12 am | Re: Maintaining Foreign Key Relationships on Identity Fields when Copying Data Across | | Posts(3) | March 28, 2006, 10:03 pm | sql query to add data to a string | | Posts(3) | March 28, 2006, 10:03 pm | Soundex? | | Posts(1) | March 28, 2006, 10:03 pm | Re: Maintaining Foreign Key Relationships on Identity Fields when Copying Data Across | | Posts(1) | March 28, 2006, 10:03 pm | Re: Maintaining Foreign Key Relationships on Identity Fields when Copying Data Across | | Posts(1) | March 28, 2006, 10:03 pm | Re: Maintaining Foreign Key Relationships on Identity Fields when Copying Data Across |
|
|