Similar ideas popular now
7 ways to insert data into Sql Server table
1). Simple Sql INSERT Query 2). Simple Sql INSERT INTO Query 3). Simple Sql INSERT INTO with selected columns Query 4). Simple Sql INSERT INTO with multiple values Query 5). Sql INSERT Rows from another table 6). Sql INSERT INTO With Multiple Data Using UNION ALL Query 7). Sql Query to Move Rows From One Table into Another Row By Row Using While Loop
SQL Server UNION, UNION ALL, EXCEPT and INTERSECT Operator
Sql Set Statements are used to combines the results of two or more queries into a single result set. The following are basic rules for combining the result sets of two or more queries: 1) The number and the order of the columns must be the same in all queries. 2) The data types must be compatible. #sql #sqlserver #asp #aspdotnet #csharp
2 Minutes for types of commands in SQL Server
One of the most important question asked in interview, you might know with in 2 minute session only. T-SQL is abbreviation of Transact-Structured Query Language (SQL). Data definition language (DDL) Data Manipulation Language (DML) Data control language (DCL) Transactional Control Language (TCL) Database Console Command (DBCC)
T-Sql tactics to replace multiple spaces with single space
T-Sql to replace multiple spaces with single space - Every developer face same problem many times when user enters continuous white space between two words. Here you will Know technique, How to Replace Multiple Spaces in String with Single Space in SQL Server?. Its too simple logic which is easy to use.
12 Easy steps to remove identity column within SQL server table. | SW Class
12 Easy steps to remove identity column in SQL server. Sometimes we face a problem with primary key column in database with uncertain sequence generated due to deleting some data from table or SQL server sequence jump when SQL server restarts. To avoid this problem we plans to turn of auto sequence generated by identity column. It seems very easy in case of only one table. what happen if more than one table is present with in database with foreign keys dependency.