All DevCenters
MSDN Home
Windows Live ID
MSDN Archive:   MSDN Archive Home   |   Browse Archive   |   Share Code   |   Help and FAQs
Home
Downloads
Discussions
People
License
 
Discussions List | Create New Discussion
1-10 of 46 < Previous Next >
Discussions for TSQL Samples from Venkatesan Prabu - SQL Server MVP
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: Finding the n th Highest value in SQL Server: In most of the SQL interviews, you will face this question frequently. So, I would like to write an article on this. Scenario: Find the 6th...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: Finding the n th Highest value in SQL Server: In most of the SQL interviews, you will face this question frequently. So, I would like to write an article on this. Scenario: Find the 6th...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: Finding the n th Highest value in SQL Server: In most of the SQL interviews, you will face this question frequently. So, I would like to write an article on this. Scenario: Find the 6th...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: Finding the n th Highest value in SQL Server: In most of the SQL interviews, you will face this question frequently. So, I would like to write an article on this. Scenario: Find the 6th...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: In most of the SQL interviews, you will face this question frequently. So, I would like to write an article on this. Scenario: Find the 6th highest ID in a table Possible Solutions: A...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: In most of the SQL interviews, you will face this question frequently. So, I would like to write an article on this. Scenario: Find the 6th highest ID in a table Possible Solutions: A...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: I have seen a request in one of the popular forum to order by a varchar column (Only on the integers and not on the varchar data). Below is the sequence of queries to do an order by on t...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: CASCADE DELETE OPTION IN SQL SERVER: I have seen lot of SQL developers were struggling to delete multiple tables simultaneously. Scenario: I have deleted the master table and I would ...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: Finding the length of the string without STRLEN function: I have seen a request in one of the forum on String Lenght function. Finding the string length with out STRLEN built-in function...
Jump to: First Post
Latest post:
Apr 27 2010
1 Post
First post: venkatesanj wrote: NVARCHAR OR VARCHAR TO FLOAT IN SQL SERVER: For converting the data from one datatype to another, you need to use CONVERT function. The syntax is CONVERT(DATATYPE,COLUMN NAME) SAMPLE Q...
Jump to: First Post

Configure View

Sorted by Latest post
Search
Filter
(by tag)
All tags
1-10 of 46 < Previous 1 2 3 4 5 Next >
Show 10 25 50 All discussions
Updating...
Page view tracker