|
| Getting List Of tables With Number Of Records Of Each In SQL Server |
| UpsizingWizard to migrate an AccessDB to SQL |
| Right Join Using Left Join Clause |
| Automatic Database(MySQL) backup |
| Using =null instead of isnull |
| Some Interesting features of ENUM data type in MySQL |
| Use of SET NOCOUNT in stored procedures |
| Screen all incoming query-strings to prevent SQL injection |
| Empty or Shrink the database |
| Some Useful SQL Queries |
| Swap table name in MySQL, SQL Server |
| GO (Transact-SQL) |
| SQL Query Optimization |
| Self join and its usage |
| Reset the identity column next inserting identity value. |
| Execute sql stored procedure or sql query from Access. |
| How To Make A Case Sensitive SQL Query Search |
| Extended Properties for Documenting the SqlServer Database |
| Display Dates In A Range |
| Secure Way Of Executing The Update Statement In Sql Server |
| How to take backup of SQL Server database schedule wise |
| How To Encrypt All Store Procedure In SQL Server Database |
| Configuring MSSQL Server to talk to PHP in Ubuntu |
| Dynamic Where Clause |
| Sending Email in Oracle/plSql |
| Remove Multiple Spaces from a string using SQL Server |
| How to preserve SQLite db in AIR application uninstallation/reinstallation |
| How to drop primary key constraint in SQL Server |
| How to configure C3P0 connection pooling in Hibernate |
| How to delete duplicate rows in a table using CTE |
| Physical Mysql - what are these? (.FRM, .MYI, .MYD). Need this? |
| How to find those tables which do not have any auto-incremental column in SQL Server |
| Use Stored Procedure's result set in Inline Query or in another stored procedure |
| Limiting the retrieval of data in SQL Server 2008 |
| Calculate Geographical Area using SQL Server |
| Printing the query executed last by codeigniter framework using active record class |
| Temporary Tables or Table Variables: Choose One! |
| Deleting Duplicate Data In MySQL |
| How to find the engines of MySQL tables |
| How to add row number in a query result set. |
| Creating and inserting data to a table using the SELECT statement |
| Stored Procedure execution using MySQL Extension |
| Common Table Expression in SQL Server |
| Fetch Nth Column of a Table |
| Using FIELD function in ORDER BY clause in MySQL |
| Table variables in SQL Server |
| How to use Transaction in Entity FrameWork? |
| EXPLAIN your query in MySQL |
| Find Stored Procedure (s)/Function(s) related to a Table(s) in Database |
| Difference between utf8_general_ci and utf8_unicode_ci |
| Access data from remote database server using FEDERATED Storage Engine in MySQL 5.0 and up |
| Using Pivot Operator in SQL- Server |
| XML DataType in SQL Server 2005 |
| Count affected rows after SQL Query Statement |
| Difference between @@IDENTITY, SCOPE_IDENTITY() and IDENT_CURRENT() in SQL SERVER |
| Search datetime data in SQL Server (using 'where' clause?) |
| SQL Server Index - V (Index Fragmentation) |
| How to update field values partially in MySQL UPDATE statement? |
| SQL Server Index - I (Basics) |
| SQL Server Index - II (Clustered Index) |
| SQLServer Index - III (Non-Clustered Index) |
| SQL Server Index - IV (Composite and Covering Index) |
| INSERT data from one table into another |
| INSERT, UPADTE or DELETE a row and return column/columns value with single query |
| Using BINARY function in MySQL for case sensitive search |
| MYSQL Binary Logs And Purge |
| Sort data according to value of two columns |
| How to find DB size and table info in MYSQL |
| Think Before Using 'Distinct' Command Arbitarily |
| How to return Modified data in SQL Server |
| DateTime Mystery In SQL Server |
| Fixing Reporting System UI issue in IE8 |
| Make Your "Order By" Clause Dynamic |
| Using CASE expression in SQL queries |
| How to copy data to an identical table in another database |
| Using "WITH TIES" SQL Clause |
| DATALENGTH() AND LEN() |
| Dealing with NULL values in SQL Server |
| Executing SSIS package from local machine using C# code |
| Retrieving List of DB created by user from SQL Express 2005 |
| SET and SELECT in SQL Server |
| Why not to use TEXT data type in SQL Server 2000 |
| Using SQL JOIN to get data from different tables conditionally |
| How to swap data between columns in SQL Server |
| How to Escape Wildcard Characters While Searching in SQL Server |
| Renaming Database Objects |
| Get list of existing TRIGGERs in MYSQL |
| Replace function in MySQL |
| Backup SQL Database Through Code In VB.NET |
| How to get the Deleted Identity Numbers in SQL Server 2005 |
| TRY- CATCH in SQL SERVER 2005/2008 |
| Using Regular Expressions with MySQL queries to Search |
| MySQL: Using "ON DUPLICATE KEY UPDATE" while inserting record |
| SQLSERVER Transaction rollback |
| Display summary report using a simple query in MYSQL |
| MySQL: Implementing case-sensitive functionality in query |
| How to use UPDATE with JOIN in SQL queries |
| Selecting records from more than One Database Using Single Query |
| Avoid Causing havoc with Live Site/DB |
| Store data temporarily on your page and finally insert it into database |
| How to select Random rows in SQL Server using TABLESAMPLE |
| T-SQL: Finding Top and Bottom records |
| Top with ties option in SQL Server |
| How to backup and restore MySQL database. |
| MSSQL-Insert records for columns where IDENTITY is set |
| How to create folders in SQLReport server dynamically ? |
| T- SQL: Query with case-sensitve functionality |
| Using Having clause with Count function in SQL |
| Forming Comma Separated String in SQL Server |
| Deleting Duplicate records in SQL Server |
| Run the existing SQL Script programmatically with SMO |
| SQL Server: Restrict the duplicate insertion of records to the database using Store Procedure |
| MySQL : Exporting The Resultset of a Table into CSV File |
| MySQL: How to get the Particular Data Range |
| How To Set Page Break in a report Conditionally |
| Get database connection string using UDL files |
| SQL Server : Multiple record insert |
| Making Inserts into from one table to another table excluding duplicates - without using cursor / temp table/ loop |
| MySQL: Filter or Search Records Using Regular Expression |
| How to add dynamic data in to the SQL Report header and footer |
| MYSQL:Ordering A TextField Numerically |
| SqlServer Query Optimization Tips |
| Importance of Max Degree of Parallelism in SQL Server |
| Use of cross apply to show ',' separated values(SQL Server) |
| How to create temporary table in MySQL |
| How to relocate database from C#.NET (SQL Server 2000) |
| Which one to use in a SQL query:-"Not Exists"/ Left Join / Not In"? |
| Consuming No space for storing NULL value in table |
| Set the Recovery model of the database to Simple/Full |
| How to display tabular data in CLR proc |
| How to use a comma seperated list as paramater to a stored procedure |
| MySQL: Ordering values according to a predefined pattern |
| Bulk Copy with Oracle using Array Binding |
| Capture identity values while inserting multiple rows in Sql Server 2005 |
| New Line character and Forming a comma Separated String in SQL Server |
| Transact-SQL :- ROW_NUMBER() |
| Advantage of sp_executesql over Exec |
| How to INSERT, UPDATE or DELETE record in one statement |
| Some Useful Date Time conversion Tips in SQL |
| Using Inner Cursor in MySQL |
| How to insert more than one record using a single insert statement |
| How to use double quotes in dynamic SQL statements |
| How to use the Transact-SQL functions CONTAINSTABLE and CONTAINS to do a search on a full-text enabled table |
| SQL Server Update Statistics |
| Avoiding the use of Triggers in SQL Server |
| Get Record Count of a table in SQL Server without doing a Table Scan |
| User friendly DATETIME Functions in SQL Server 2008 |
| How to reuse query execution plan? |
No comments:
Post a Comment