Bayt.com

Trending T SQL Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Oracle
SQL Server
T SQL
Database
PLSQL
mohamed khiry's image
Question added by mohamed khiry Senior Database Administrator confidential
8 years ago

Do you know how to count duplicate values in sql ?‎

Answers:
48
Followers:
Views:
1275
Vote Count:
3
Report Inappropriate
Answer should contain a minimum of 25 characters.
SQL
Computer Science
T SQL
antonios awadallah's image
Question added by antonios awadallah HRMS Application Consultant HITS Technologies
7 years ago

How might you get around hard coding the elements in a fetch cursor?‎

Answers:
1
Followers:
Views:
64
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
SQL
Computer Science
T SQL
antonios awadallah's image
Question added by antonios awadallah HRMS Application Consultant HITS Technologies
7 years ago

How to find the query running on a given SPID?‎

Answers:
1
Followers:
Views:
92
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
SQL
Computer Science
T SQL
antonios awadallah's image
Question added by antonios awadallah HRMS Application Consultant HITS Technologies
7 years ago

How to find the statistics are outdated?‎

Answers:
1
Followers:
Views:
80
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
PL SQL
RDBMS
Oracle
SQL Server 2000 2008
T SQL
Syed Sumair's image
Question added by Syed Sumair IT Project Manager Saudi National Bank
8 years ago

How to get max and sub max in group by sql query? ‎

Table:    IDSalesDate /1/ 1/1/ 1            /3/   3          /8/ 4          // 5          // 6          1// 7          /2/ 6          /4/ 7            //   ‎ ... See More

Answers:
7
Followers:
Views:
978
Vote Count:
1
Report Inappropriate
Answer should contain a minimum of 25 characters.
T SQL
Abdul Rafi K's image
Question added by Abdul Rafi K Technical Lead Symphony Teleca
8 years ago

How to insert deleted keys in a table where there is an identity(1,1) column in a table, without disabling identity constraint?‎

Answers:
8
Followers:
Views:
127
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Queries
SQL Server 2000 2008
T SQL
Microsoft SQL Server
Technology
ziad jendi's image
Question added by ziad jendi Technical Lead Manager Innovent Integrated Solutions
8 years ago

what are the main factors in sql server queries optimization? ‎

Answers:
3
Followers:
Views:
873
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Server Architecture
SQL Server 2000 2008
T SQL
Computer Skills
Microsoft SQL Server
Shahnawaz Alam Shahnawaz's image
Question added by Shahnawaz Alam Shahnawaz Database Specialist Intigral
9 years ago

Please anyone tell me about sql server dba job opportunity in saudia arabia and top it company‎

Answers:
2
Followers:
Views:
176
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Databases
T SQL
IT
Shahnawaz Alam Shahnawaz's image
Question added by Shahnawaz Alam Shahnawaz Database Specialist Intigral
10 years ago

What is all phases of Software Development Life Cycle (SDLC)? ‎

Answers:
4
Followers:
Views:
690
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.
Web Development
Programming
Computer Science
T SQL
C#
Javed Ahmad's image
Question added by Javed Ahmad Senior Developer HCL Technologies Ltd
7 years ago

Why Passing simple DateTime parameter from C# To Sql Store Procedure (without Converting in String Format) not always give desired Result..? ‎

It gives exact result if we pass DataTime in fallowing format var sqlDateFrom = dt_From.Date.ToString("yyyy-MM-dd HH:mm:ss") But it gives Diffrent Ouptput whe‎ ... See More

Answers:
1
Followers:
Views:
6
Vote Count:
0
Report Inappropriate
Answer should contain a minimum of 25 characters.