SQL Language

SQL Language

This section describes SQL statements and syntaxes.

Blogs

Graphics Design

Getting List of Data Types using system function in SQL Server 2008

Lajapathy Arun

12y

3.2k

0

Graphics Design

How to Sum the time in Varchar column in SQL Server

Santhosh Kumar Jayaraman

Santhosh Kumar Jayaraman

12y

19.7k

1

Graphics Design

How to get the list of all Tables without Indexes in MS-SQL

Anil Kumar

12y

2.5k

3

Graphics Design

How to get list of all Indexes of a table in MS-SQL

Anil Kumar

12y

4.5k

2

Graphics Design

How to use output parameter to get the last inserted record ID

Vikas Ahlawat

12y

4.3k

4

Graphics Design

Creating and Executing a Parameterized SQL statement

Farukh Mujawar

12y

2.5k

2

Graphics Design

About SQL Performance

Kunal Vaishya

12y

2.3k

0

Graphics Design

Autoincrement value using stored procedure

Satyapriya Nayak

Satyapriya Nayak

12y

26k

1

Graphics Design

Upgrading the version from Evaluation to Standard/Enterprise/Developer version

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.6k

0

Graphics Design

Understanding Stored Procedure Basics

mahesh p

12y

3.1k

0

Graphics Design

How to get the second highest from a Table

Dileep Kumar Patel

Dileep Kumar Patel

12y

2.8k

3

Graphics Design

Difference between Stored Procedure (SP) and User Defined Function

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.9k

0

Graphics Design

SET or SELECT -- is there any performance difference?

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.3k

2

Graphics Design

How to use dynamic sql for a nvarchar of more than 4000 characters?

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

5k

0

Graphics Design

Get the Top Data from SQL Server

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2k

0

Graphics Design

Get the Top Data with Ties from SQL Server (If there are same data….Ties in data will happen. If we need all the data.

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.1k

0

Graphics Design

Variable in Top Clause (Dynamic value for the top clause):

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.1k

0

Graphics Design

REBUILDING VS REORGANIZE THE INDEX

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.2k

0

Graphics Design

Query in one of the forum:

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.1k

1

Graphics Design

How can we force SQL Server to use a specific index when executing a query?

Venkatesan Jayakantham

Venkatesan Jayakantham

12y

2.9k

0

<<
10
11
12
13
14
>>

221 - 240 of 402