ttmind

Main Content

Please wait...

Essential Linux Command for Beginners

Essential Linux Command for Beginners Few essential things you should know before using linux: when you are asked to enter password in command prompt, it will not show anythings like **** or ●●●●. So don’t panic just type password and enter the password. Linux command are case sensitive you have to write upper case if it is in uppercase and like wise in lowercase. Never ever use command rm -rf/ ,this will delete all directories and data on it . Here rm means remove , -r ....Read More

Use of TOP and DISTINCT in SQL SERVER

TOP and DISTINCT clause. TOP applies to: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse and Parallel Data Warehouse DISTINT applies to: SQL Server Analysis Services TOP Clause: TOP is mainly used to limit the result of query in terms of number or percentage of the result from database. It selects result limits to TOP from N numbers of data from ordered rows by using ORDER BY statement otherwise it selects undefined order data. TOP can be used in statem ....Read More

SQL Server Stored Procedures: Part-5

SQL Server Dynamic SQL and SQL Injection SQL Server Stored Procedures: Part-4, Click here. Dynamic SQL is used to construct SQL statement dynamically at run time. In case you don’t know all the SQL statement at compilation time, dynamic SQL is effective. You can use dynamic SQL to create Stored Procedure to query data whose table name is unknown at compilation time. For Example: CREATE PROC uspEmployee( @tableName NVARCHAR(100), @topN INT, @Column NVARCHAR(100) ) ....Read More

SQL Server Stored Procedures: Part-4

SQL Server TRY CATCH For SQL Server Stored Procedures: Part-3, Click here. TRY CATCH Statement SQL Server TRY CATCH construct is used to handle error in stored procedure. Syntax: BEGIN TRY --Statements that may cause exceptions END TRY BEGIN CATCH --Statements that handle exceptions END CATCH If TRY block executes without any error then CATCH block does not executes. But if TRY block executes with error then control transfers to the statements in CATCH block. Functions of CATCH ....Read More

SQL Server Stored Procedures: Part-3

SQL Server CURSOR For SQL Server Stored Procedures: Part-2, Click here. Database cursor act like a pointer in a database. It process query on each row one by one. Cursor act like a pair of tweezers to pick up each row of data from bag of data. You should use cursor if you have large amount of data and need to act individually on each row. Cursor doesn’t need to allocate big chunk of space in server to load result set like in SQL. Life cycle of SQL Server cursor: Step for using a cu ....Read More

SQL Server Stored Procedures: Part-2

Control-of-flow statements: For SQL Server Stored Procedures: Part-1, Click here. BEGIN….END Statement: The BEGIN….END statement contains set of SQL statement and executes block of SQL statement. Syntax: BEGIN { SQL Statement || Statement Block} END For example: BEGIN SELECT First_Name, Salary FROM dbo.EmployeeDb WHERE Salary> 100000; IF @@ROWCOUNT= 0 PRINT 'No one has greater than 100000'; END Syntax D ....Read More

SQL Server Stored Procedures: Part-1

If you don't have database, you can find it here. Creating Stored Procedure: CREATE PROCEDURE or CREATE PROC query is used to create stored procedure: CREATE PROCEDURE uspEmployeeList AS BEGIN SELECT Emp_ID, First_Name, Last_Name FROM dbo.EmployeeDb ORDER BY Emp_ID END Syntax Description: uspEmployeeList is the name of the stored procedure. AS keyword seperates the head and body of stored procedure. BEGIN and END keywords surrounding statement are optio ....Read More

Uploading .csv sample table file data to SQL Server

Bulk Import of Data (SQL Server) Data file for Demonestration of Stored Procedure is in this link GitHub. Step 1: Create Database Step 2: Right click to database created, go to task and to Import Flat File. Step 3: Click Next Step 4: Browse the file, give the table name or keep it default and Click next. Step 5: Preview the data if all you want is correct or not and click next to change table data columns, data type etc. Step 6: Modify columns. Step 7: Click Finish and see summ ....Read More
1. nchar[(n)] (national character) i. Fixed-length Unicode string data. ii. n defines the string length and must be a value from 1 through 4,000. iii. The storage size is two times n bytes. 2. char [(n)] (character) i. Non-Unicode string data with fixed-length. ii. n defines the string length and must be a value from 1 through 8,000. iii. Storage size is n bytes. 3. varchar [(n | max)] (character varying) i. Variable-length, non-Unicode string data. ....Read More

What's new in SQL Server 2019?

Microsoft announced the latest preview of SQL Server 2019 on this September and Celebrating 25 years of SQL Server Database Engine since SQL Server first shipped on Windows NT in 1993. In every release of SQL server, Microsoft makes inner optimizations that enhance performance. In this release there is no License or support it only available for experiments. SQL Server 2019 makes a brought together information stage with Apache SparkTM and Hadoop Dispersed Record Framework (HDFS) bundled toge ....Read More