1401:
Backup script help!
1402:
Problem in using nolock hint with 'OPENQUERY' statement in SQL Server 2005
1403:
Order by based on certain value
1404:
View temporary table from a different connection
1405:
Commas between address elements and the COALESCE function
1406:
Limit database file size.
1407:
Copy entire database structure
1408:
Reading nvarchar-field
1409:
SQL SELECT return most recent
1410:
CreateDate, LastUpdateDate Question
1411:
Filter not case sensitive
1412:
Changing db user's password without knowing the old one
1413:
SQL to XML question
1414:
UPDATE
1415:
How to set up wireless connection to Sql Express 2005?
1416:
Insert @n_records Database
1417:
SQLXMLBulkLoad: how to build schema to join elements
1418:
Need help in Index
1419:
Deterministic ISDATE in a Computed Column Specification
1420:
Query Optimization problem
1421:
Cannot Add A Worksheet To Workbook With VISTA
1422:
retrieve individual value from accumulated data
1423:
Retrieve From Trigger the Inserted Column Value
1424:
Progress from Stored proc in Excel
1425:
summing a quantity field by month (by the number of that month)
1426:
Federated IDs
1427:
Federated IDs
1428:
SQLCommand - Must Declare Scalar Variable @Lastname
1429:
SQL Server Express - Problem?
1430:
"Verticalize" data in a view ?
1431:
sp_send_dbmail
1432:
Script Max Char Len Fields in Table
1433:
Query to Return List of Dates Between GETDATE() Range
1434:
Sifobo Enterprise Manager for SQL Server - Free Download
1435:
MSSQL 2008 RC0: sqlmergex.dll: sqlmerge.AddSubscription fails
1436:
bcp out empty string into csv file
1437:
Need suggestions on table structure for saving data pertaining to
1438:
Help needed - Please
1439:
several tables return as one virtual in tsql function - is it poss
1440:
Trigger to timestamp record being updated
1441:
XML bulk load into SQL Server, combine header info into each recor
1442:
Finding the identity column on a temporary table
1443:
Inserting records with OpenQuery
1444:
Eliminate the duplicated records
1445:
Will ShrinkDB affect the FullText Catalog entries?
1446:
help with stored proc with datetime
1447:
Reporting server
1448:
Rename an XML index?
1449:
FK_Constraint error returned erroneously?
1450:
Call Multi-statement Table-Value User-Defined Function with field.
1451:
Excluding inserts or updates from a transaction
1452:
Help with this FOR XML query
1453:
Sounds easy, but...
1454:
Is this a Valid T-SQL ??
1455:
Is this a Valid T-SQL ??
1456:
Is this a Valid T-SQL ??
1457:
CASE problem
1458:
adding new column
1459:
Teaching myself, but have one hole to fill, please help
1460:
Please help!
1461:
Catching all error messages not only the last one
1462:
file compare for .sql script?
1463:
Multi-company DataBase
1464:
SQL Server Stored procedure execute question
1465:
ExecuteReader Blocks Inserts on a Table
1466:
simple but complex query.. can you fix it?
1467:
olap cube
1468:
query entire database
1469:
INSERT identity
1470:
Pivot Columns
1471:
Many to Many relationship?
1472:
Linked Server Woes (SS2005)
1473:
Row handle referred to a deleted row or a row marked for
1474:
extracting just the month "ID"
1475:
Update Intersect Syntax
1476:
Is the NOLOCK hint same as READ UNCOMMITTED
1477:
Comparing (and if need be swapping) two column contents during an INSERT
1478:
Adding a constraint to SQL Server Table
1479:
What happens when a "NULL" condition is applied to the
1480:
Why does the Cartesian product of two tables differ when
1481:
get value 1.9999 insted of 0.9999
1482:
sysobjects
1483:
Finding occurrences in a table
1484:
sp tuning required
1485:
Cannot Backup To Network Drive
1486:
Freetext AND & OR
1487:
Is there a name for this?
1488:
Make a serie of numbers
1489:
Info
1490:
Dynamic Sql limitations?
1491:
xp_cmdshell bcp help!
1492:
Trying to create a table with a Primary Key, in a partition
1493:
Change fields to unicode
1494:
Help Speeding Up Query
1495:
Default constraints and values
1496:
Placing a field in one particular monthly date record
1497:
How to find creator of tempdb table
1498:
Compare master against sum in data
1499:
Precision on SUM
1500:
less than greater than in a CASE WHEN statement
1501:
xp_smtp_sendmail
1502:
BCP question
1503:
Soundex Problem
1504:
not contained in the aggregate or GROUP BY..problem with DISTINCT?
1505:
CDOSYS and SQL2000 Problem
1506:
Computer column with case statement
1507:
SQL Injection
1508:
Possible without TABLOCKX ?
1509:
Returning data via output parameter
1510:
How to speed-up update
1511:
Can Someone Help Me Do An Insert into This Table?
1512:
please help with data modeling
1513:
SQL 2005 Edition before starting sql?
1514:
Comparing just the date part in datetime SQL
1515:
Need help with SSRS 2005.
1516:
Needed reconmmendations for an enhancement
1517:
Urgent Help Needed in Sql Query
1518:
BLOB IS NULL as column in query
1519:
Top 10 by quantity for each category
1520:
VARCHAR comparison
1521:
T-SQL math is wrong
1522:
perpetual norecovery on hot spare
1523:
Sleeping processes
1524:
How to query for contiguous dates
1525:
Double encoding?
1526:
COUNT and UNION?
1527:
Delete Trigger - Handle Multiple Rows
1528:
inorrect syntax on coalesce function
1529:
Null takes place?
1530:
Getting parent nodes in a tree
1531:
Selecting rows that do not meet an inner join
1532:
Retreiving value from a stored procedure
1533:
duration of OSQL batch on sql2005
1534:
DB analyzer
1535:
DBCC UPDATEUSAGE - how often should I run this?
1536:
ODBC error using Windows authentication
1537:
Slow to connect on 1st attempt
1538:
SQL Question (Basic)
1539:
NEED TO TAKE OUT MY POST
1540:
Why use views?
1541:
SQL2K XML
1542:
These queries are technically the same. Why does only one return d
1543:
how can i insert formula in sqlserver
1544:
rownumber for group by
1545:
temporary table?
1546:
Retreiving result from a stored procedure
1547:
sql:relation and sql:field
1548:
How to do order by and group by?
1549:
How to find out which column is being used as primary
1550:
Locking issue
1551:
Date format
1552:
using REPLACE function to replace a vbCrLf with a <br> tag
1553:
viewing #temp tables
1554:
Joining Two tables.
1555:
Global Exception Handling
1556:
How to get the soonest event from the database?
1557:
Joining tables
1558:
How to get the soonest event from the database?
1559:
collation conflict joining views same DB
1560:
Decimal formatting
1561:
Converting int to nchar
1562:
Sorting Hierachal Data
1563:
Table
1564:
Get backup folder without using registry
1565:
if exists syntax
1566:
Optimizing an index for a select count(distinct)
1567:
encrypting data
1568:
What data type do you use for flight schedule?
1569:
update statements in Instead Of trigger
1570:
Service Broker
1571:
report in asp.net
1572:
Sex sexy sexo sex teen sexs teens shemale Video a preto e branco
1573:
FOREIGN KEY constraints
1574:
Performance CLR function
1575:
best way to compare data
1576:
Deploying CLR to a schema
1577:
Sql sever GUI query tool
1578:
readability vs cost
1579:
Stored procedure to synchronise data
1580:
Err : 40 couldn't open a connection to SQL Server
1581:
not exists - show match from second table
1582:
query showing customers with a balance, etc.
1583:
precision tuning help
1584:
Equivalent of multi-column IN
1585:
Error accessing T-SQL UDF from CLR UDF
1586:
i am getting following error
1587:
Archieve Tables (Purging)
1588:
Question about transactions
1589:
simple SQL engine
1590:
bcp command help
1591:
How can i read the Log file ?
1592:
Can the fulltext engine do this?
1593:
Dynamic SQL
1594:
sql performance for function
1595:
Doing a LIKE with a subselect
1596:
Query data with more than one single quote
1597:
Schema name part of constraint name?
1598:
Data looking different when imported to temporary table
1599:
A little query syntax help
1600:
Problems with Connecting MS SQL Server Through PHP
1601:
Syntax error in case statement
1602:
Selecting 3rd char onwards
1603:
inner join stored procedure
1604:
Indexes and GUIDs
1605:
How to use OPENQUERY..
1606:
creating table-valued function help
1607:
SET NOCOUNT ON
1608:
Dynamic TSQL Question
1609:
Viewpoint Trust Admin- SQL issue
1610:
www jamba handylogo gratis logos fuers handy jamba handy logos
1611:
How to sampling a table by a special column? Please help!!!!!
1612:
using kind of alias in sqlplus
1613:
Parameters were not supplied for the function - SIMPLE UDF
1614:
How - parameter of a string of integers
1615:
How to export data into .csv file thru query
1616:
A tip for newbies from a newbie
1617:
(newbie) - Previously used 2 views now trying to achieve same in S
1618:
SQL 2005 and Enterprise Library Cryptography
1619:
SQLCLR - do you need to free SqlBytes.Stream ?
1620:
sum the row
1621:
Need help with Calendar query.
1622:
execute sql not working to call SPROC
1623:
Need Query - Grouping values & concatenating rows
1624:
Length of index and constraint names
1625:
security advise needed
1626:
Need Query - Transform one-to-many entries into one-to-one
1627:
How SQL engine evaluates this expression
1628:
TRANSFORM/PIVOT (Access to SQL)
1629:
SMO question: Is this the right place? ScriptingOptions question
1630:
When will DB-Library stop working?
1631:
Create backup of SQL 2005 Express, database get smaller
1632:
When will extended stored procedures cease to work?
1633:
Grouping items with different values in 1 field
1634:
using service broker
1635:
Getting the actual SQL statement in a trigger
1636:
Creating a linked server to Timberline from SQL 2005
1637:
Simple Stored Procedure using Date Parameters
1638:
Coalesce Function in a SQL EXEC statement
1639:
Error conversion
1640:
Slow store procedure
1641:
erratic timeout on SQL 2005
1642:
Where does SSIS package get stored?
1643:
How to connect table's name, id and Schema?
1644:
Data Not Refreshing after Stored Procedure Runs
1645:
How can I avoid having an exception propagate back to the calling
1646:
External Functions for SQL Server 2005
1647:
create view to select from another database
1648:
Preparing SQL Data For Use
1649:
Excluding rows that have no child rows in a hireachy type table
1650:
Select Top N plus a count
1651:
Search Stored procedure objects
1652:
Dynamic Partitioning
1653:
Copying data to Oracle table
1654:
Can osql.exe distinguish Accute Accent(0x00B4) from an Apostrophe?
1655:
UPDATETEXT
1656:
Sorting VARCHARs
1657:
checking empty value
1658:
Insert characters every ### characters
1659:
bcp help please
1660:
Count problem
1661:
(LONG) Trying to emulate DROP TABLE IF EXISTS
1662:
Can't change data in view with trigger in Management Studio
1663:
disabling logfile auto growth
1664:
Simulation questions
1665:
Using Case within Select
1666:
CTE on multiple tables?
1667:
SQL syntax and cleaning up
1668:
Where is my mailings ???
1669:
Split single row into 2 or 3
1670:
Query Issue - calculating average for the past 30 days
1671:
test
1672:
HELP with ODBC Error...Incorrect Syntax near ';'
1673:
How establish a queue in SQL/SSIS?
1674:
Merging two tables
1675:
Rounding errors
1676:
Dynamic SQL in a Stored Procedure ...Please help
1677:
Possible to take referential integrity from one database and apply to
1678:
Physical Cursor blinking and blocked
1679:
sp_OAMethod output string limitation still 8000 bytes in SQL2005??
1680:
number of DBs that are online an have been accessed this month? in
1681:
Query criteria for datetime
1682:
error handling sp_xml_preparedocument
1683:
Migrating SQL 2000 DBs to 2005. Access Frequency and Logs?
1684:
Merge Replication w/RMO over web...
1685:
a cool new free tool: data monitoring
1686:
Reading XML file from SQL ...
1687:
What is the max length of SqlCommand.CommandText
1688:
SELECT...INTO creates varchar or nvarchar col on different instances for the same query.
1689:
Nesting SELECTs
1690:
Another big delay...continue
1691:
Find tables with missing columns
1692:
Can this query be written using a CTE rather than a table variable?
1693:
opposite of SELECT TOP(n) *
1694:
A question about keyword search strategy against SQL Server 2000
1695:
Delete command
1696:
help with the query
1697:
Extract element name and attribute name-values from XML
1698:
Log shipping in Standby mode recovery with lost or corrupt TUF file
1699:
MySQL Query
1700:
trigger
1701:
trigger
1702:
Problem persisting a temp table when created with sp_executesql
1703:
How to get database state?
1704:
Importing Stored Procedures using SQLSERVER 2005?
1705:
invalid column in temporary table
1706:
update query problem
1707:
SQL XML query and serialized DataSet
1708:
Finding table names
1709:
Count of records in a table
1710:
date fields only correct if run during a certain time of day
1711:
dynamic use of table names
1712:
Question about Geography type in Sql Server 2008
1713:
Retrieving only the first entry ...
1714:
Updating one table using another with multi join
1715:
turning on SELECT INTO/BULKCOPY when doing BCP
1716:
OSQL pass an arg to a .SQL script?
1717:
Big delay in query
1718:
Question on Activex script in DTS
1719:
backup database on another server as instance
1720:
OLEDB HResult error reference?
1721:
How to get a list of stored procedure's names which are
1722:
Full Text Search / WHERE clause speed question
1723:
Newbie question on SQLBindParameter
1724:
Using Max
1725:
Save 60% on Data Entry, Data Conversion, Data Processing Services by
1726:
datatype conversion error
1727:
Float and Real Data Types
1728:
VERY simple SQL question
1729:
a concept question
1730:
earn!! =10,000 US Dollars per month without Investment.
1731:
SQL Trigger
1732:
Generating Sequential Numbers From SQL Database Table
1733:
import export help
1734:
add remove identity by script
1735:
2005 Books Online
1736:
Pivot Problem
1737:
Building a general search query
1738:
sp_executesql and isolation level scope
1739:
Tweaks/Optimizations
1740:
Query Help...
1741:
Using SQL database tuning wizard
1742:
script takes 5 secs but same script in a sproc takes 1.5hrs
1743:
How to trap and ignore 7357 error (UPDATE FoxPro table via linked
1744:
Orphaned Logins after restore another DB - sp_change_users_login The
1745:
finding out sql server options programmatically
1746:
GUIDs generated on server computer or client computer?
1747:
Q: Anyone made a successfull Linked Server to Pervasive 9.5 server?
1748:
lonnnngg commit
1749:
Hourly job running exactly 5 minutes after a round hour
1750:
Use CHAR(13) and CHAR (10) in Stored Procedure