- How to have strings automatically truncated? (6 replies)
- Optimizing a JOIN (5 replies)
- Checking for existing column (1 replies)
- Difference Between NULL and Blank in SQL (4 replies)
- Stored procedure returns no value (2 replies)
- getting the matching columns from two tables (2 replies)
- Insert first n columns from select (8 replies)
- SQL cache so GREEDY? (0 replies)
- Cannot connect to a new installed SQL Server 2000 (1 replies)
- Executing a Views from a Trigger (7 replies)
- more date problems... (1 replies)
- Use MS SQL Server 2005 Developer version to open MDF file? (3 replies)
- How does one set read-uncommitted on the entire DB? (5 replies)
- Can I do this in SQL Analyzer or with a dts package? (2 replies)
- comma deliminited coloumn (4 replies)
- Convert Sting to Date (7 replies)
- Select row with only ONE occurence (3 replies)
- how to import image jpeg file to table in oracle (0 replies)
- Logshipping Corruption Problem (0 replies)
- Replicate between to MSSQL 2000 Servers (4 replies)
- Problem with variable of type money? (7 replies)
- MSSQL Query Memory when using long fields (2 replies)
- Preventing SQL Injection attacks (4 replies)
- How can I remove duplicate entries in a sql query? (14 replies)
- Referential Integrity - linking multiple tables to transaction table (6 replies)
- Query Memory? (1 replies)
- Statistics IO logical reads sometimes 15 million and other times down to 90 thousand? (4 replies)
- Space Available Within A Filegroup (1 replies)
- SQL Server: beginner: "Login failed for user 'sa'." (1 replies)
- Help with Query (2 replies)
- Newbie - Help required with Query (sample tables/data included) (7 replies)
- Problem with database filegroup restructuring in SQL Server? (1 replies)
- How to check if DB Constraints are enabled in a database? (6 replies)
- Out of range datetime value error when inserting using select...union (1 replies)
- Fast look up of long (n)varchar (3 replies)
- Does anyone know what the "Option value changed" error message is? (0 replies)
- troubleshooting data updates (2 replies)
- itzik ben-gan (6 replies)
- slecting multiple distinct columns.. (2 replies)
- Special characters in MSSQL. (4 replies)
- inserted the image in a column----how can i view the image (2 replies)
- Stored Procedure (2 replies)
- How can I do amalgamate 3 select queries and then get unique entries from the result (1 replies)
- beginner: "Login failed for user 'sa'." (2 replies)
- Changing subnets help? (0 replies)
- Can a stored procedure parameter be optional (7 replies)
- sum with increment (5 replies)
- Changing Machine Names MSDE (1 replies)
- Appending tables (13 replies)
- MSDE 2000 changing disablenetworkprotocols after installation (0 replies)
- how to write one stored procedure for a (same column )present in 20 tables (2 replies)
- Sybase tool to manage database (0 replies)
- Unable to access perfmon counters remotely (0 replies)
- Divide by Zero (3 replies)
- Can't fit results of tsql query in excel (4 replies)
- Query Brain Teaser - Revenue Projections (3 replies)
- need help to take the variables associated with the 1st occurrence of a date variable (3 replies)
- bcp with format file (2 replies)
- Speed up Bulk Update (3 replies)
- Query assistance (2 replies)
- Possibly simple query but I'm not good enough to fathom it! (3 replies)
- Getting list of recently added IDENTITY items (41 replies)
- Execution Plan Hinting (14 replies)
- sql query in vb (2 replies)
- Problem connecting AS400/DB2 with SSIS (0 replies)
- SQLInjection with OpenXML (1 replies)
- Memory limitations, 2005 Standard (2 replies)
- Update a uniqueidentifier from a string!!! (4 replies)
- Help optmizing a stored proc (2 replies)
- how to install 64-bit version? (2 replies)
- Optimization jobs - transaction deadlock victim (6 replies)
- Different query plans for view and view definition statement (9 replies)
- can i increment the column (c1+2) ---by creating the trigger (1 replies)
- Oracle Application and laptops (3 replies)
- dbcc shrinkfile - SQL Server 2000 - invalidate log? (7 replies)
- Transactional Replication with Immediate updation DBNETLIB problem. (0 replies)
- freeTDS ODBC (1 replies)
- Too Many SET Options (2 replies)
- SQL Server Scanning Tables (1 replies)
- Linked Server via ODBC and stored procedure (1 replies)
- User-defined function and temporary tables (1 replies)
- Syntax of updating table variables? (2 replies)
- Pipe delimiter problem (3 replies)
- Identifying Duplicates in a table (2 replies)
- looking to collect distinct date part out of datetime field (5 replies)
- Naming syntax in 2005 (5 replies)
- Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000 (1 replies)
- [ANNOUCE] New XML Schema Video Tutorial (1 replies)
- Values of two columns in two different tables--presentation using select (4 replies)
- Integrated Services (0 replies)
- Error (8626) while inserting record into table with text field and which is the base for indexed view (1 replies)
- convert a datatype (3 replies)
- 2005 Database Mirroring & Witness (5 replies)
- Timeout expired (4 replies)
- Identifying "filler" (2 replies)
- General Question about doing calculations in SQL (1 replies)
- SQL Server 2005 vs Ascential (1 replies)
- Greatest value (2 replies)
- Plz Help!! (1 replies)
- views dependent on other views (5 replies)
- One of two subscribers not in sync - Replication (0 replies)
- Communication betwee two tables (0 replies)
- DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 ) (3 replies)
- Communication betwee two tables (1 replies)
- Error in Query (3 replies)
- Browser Time Out: when executing a DTS package (1 replies)
- Finding the natural key (13 replies)
- Not grasping outer joins for ms-sqlserver :: 3 tables to join (4 replies)
- Getting previous values of a field (4 replies)
- Selecting records by date - need a little help (2 replies)
- Data Warehouse Nulls (2 replies)
- Compare given period in current year / previous year (3 replies)
- Querying a column with brackets in its name (4 replies)
- change of value at the time of insertion (3 replies)
- query... (4 replies)
- query... (0 replies)
- Performance (1 replies)
- Full text index on a view (0 replies)
- Sql Server Performance (3 replies)
- [ANNOUNCE] Edit and Validate XML (0 replies)
- 2000 vs 2005 -- AnsiNullsStatus (6 replies)
- bcp right truncation: how to ignore (2 replies)
- SQL query - duplicate records - different dates - how to get only latest information? (24 replies)
- Alternative to OpenXML (2 replies)
- To retrive a table from one database to and another database(same table) (2 replies)
- Deploy .MDF to a web host (3 replies)
- Help with INSERT TRIGGER - fails with error. (3 replies)
- Delete Many Rows (12 replies)
- waittype=WRITELOG (6 replies)
- outer join column (8 replies)
- Stored Procedure Help (5 replies)
- Dell Raid 0+1 (5 replies)
- SQL Server Maintenance Routines/Procedures (0 replies)
- mysterious corruption of stored procedures (5 replies)
- bigpubs2000 (2 replies)
- Design problem (1 replies)
- add a column specified location in Table.. (11 replies)
- Row to Column (2 replies)
- Possible to disable welll-formedness checking when inserting XML data. (1 replies)
- Check constraint does not work (compare with null) (6 replies)
- Help with a substring query (7 replies)
- Reporting a table with two columns from another table (5 replies)
- T-SQL Problem (4 replies)
- SQL--- GROUP BY Clause (1 replies)
- Job succeeds manually but fails if scheduled (6 replies)
- Resource for developing your own accounting software using MS technologies (0 replies)
- SQL script for changing all identical columns (0 replies)
- Joing tables using more than one field (2 replies)
- charindex question (1 replies)
- IDENT_CURRENT problem (5 replies)
- NEWBIE NEEDS HELP (0 replies)
- can you launch a crystal report from a sql trigger (1 replies)
- Using OSQL and DTSRUN (5 replies)
- Unwanted Sort (4 replies)
- Many to one Select (2 replies)
- trigger to parse a string from insert statement (2 replies)
- SQL Server License Control and Management (9 replies)
- How do I change the default collation string of an installation (3 replies)
- open MDF file without MSDE (1 replies)
- Transactional replication without synchronizing snapshot initially. (0 replies)
- Monitoring SQL Server transactions (1 replies)
- Update n rows (7 replies)
- Maximum number of databases used for each query in 2005? (1 replies)
- [Announce] XQuery Webinar: Freeing XML and Relational Data for the Web (0 replies)
- SQL Server 2005: TRIGGER AFTER INSERT (2 replies)
- Update the salary of each manager to be double the average salary of the employees he/she manages (2 replies)
- Join returns more than one row, Post code regular expressions (2 replies)
- Connecting to another SQL Server (1 replies)
- NEWBIE (Start/End for ::fn_dblog) (0 replies)
- Select 'Current LSN' and 'Transaction ID' from ::fn_dblog (1 replies)
- Performance Enhancements with Service Pack 4? (1 replies)
- slow insert, logical fragmentation (11 replies)
- Help selecting the proper child record (4 replies)
- connecting in a script to another db (2 replies)
- Optimising queries (5 replies)
- Website navigation hierarchy with SQL Server 2005 (1 replies)
- bug - insert miliseconds (2 replies)
- help with group by statement (2 replies)
- Help selecting an alias (4 replies)
- Grant Win Acct Permission (1 replies)
- generation of sql for an alter column etc (4 replies)
- SQL Server 2005 install - no Management Server (2 replies)
- Licensing Question (1 replies)
- Accessing Oracle Tables From Within SQL Server 2000 (4 replies)
- French characters are not imported properly with bcp (8 replies)
- Copying encrypted stored procedures. (1 replies)
- Query/View: The 2 newest periods for each indicator (10 replies)
- SQL Server 2000 for sale (0 replies)
- Multiple Foreign Keys on Same Table (11 replies)
- Multiple Foreign Keys on Same Table (0 replies)
- Multiple Foreign Keys on Same Table (1 replies)
- LDAP authentication for Yellowfin on SQLserver (2 replies)
- SQL Server 2005: Collation Conflict Error when selecting Database Properties (21 replies)
- I need help, please (2 replies)
- ANN: Database Workbench 2.8.5 released (0 replies)
- Where to write XQuery statements? (3 replies)
- Assigning group numbers for millions of data (5 replies)
- Order by in a INSERT INTO..SELECT (29 replies)
- ranged datetime predicates & cardinality estimates (2 replies)
- [ANNOUNCE] Release 2 of Stylus StudioŽ 2006 Now Available (0 replies)
- Row Numbers for a View (11 replies)
- How to fire a trigger without changing table data (5 replies)
- SQL Server 2005: Migrate DTS to Where? (5 replies)
- Management Studio Express (1 replies)
- Database poster (2 replies)
- Update Table (1 replies)
- Sql server report (4 replies)
- Select first n rows of table (2 replies)
- Updating Linked Records Across DB's (1 replies)
- Odd query plan for view (4 replies)
- Cursor looping versus set-based queries (13 replies)
- SQL Consultant Required (0 replies)
- Stripping input mask from phone numbers (2 replies)
- how to setup the permission of share fold in log shipping ? (0 replies)
- Problem with a join due to multiple Nulls (10 replies)
- Stored procedure with unknown numer of paramters, how? (7 replies)
- database design for fast client updates (4 replies)
- 2005:how to find installed assemblies (1 replies)
- Down and dirty database infrastructure (3 replies)
- speeding up inserts (3 replies)
- Optimizing SQL - Union (5 replies)
- Hiding NULL (2 replies)
- Transpose Rows to Columns ? (3 replies)
- Can this be optimized? Newbie question (5 replies)
- Sqlserver Login and user (2 replies)
- I'm sure this is an easy one...Error trap to skip over a "bad" object. (5 replies)
- Full text indexing with Japanese characters problem (5 replies)
- Automatic statistics update (1 replies)
- http://www.sql-ex.ru answers (0 replies)
- Timeout fixed by recompile (0 replies)
- Bind Variable in CURSOR (1 replies)
- Timeout Expired (3 replies)
- SQL Server 2005 Client Tools (0 replies)
- Update SQL 2000 Query (converting an Old Access 2k query to SQL) (2 replies)
- Need a So-Called SSN Encryption (9 replies)