The tsql tag has no wiki summary.
0
votes
0answers
37 views
T-SQL Issues With Defining 'AS' [migrated]
I am creating a fully dynamic application but have ran into a bit of a hiccup. There are multiple 'undefined' fields that can be defined by the users. The only problem is redisplaying them. Currently ...
6
votes
4answers
428 views
Should I Do Calculations in T-SQL or Program?
I am creating a stored procedure that is logging some data. The data ultimately needs to end up in 2 tables. The incoming data is coming from a JSON string containing 15 parameters, and the data is ...
-2
votes
3answers
244 views
Passing parameters to a stored procedure for use in a data reader object [closed]
using (SqlConnection con = db.con(user.Authority))
{
string command = "[Dashboard_GetUserPTOAndIncidentTotals] ";
using (SqlCommand cmd = new SqlCommand(command, con))
{
...
-1
votes
1answer
613 views
How to create computed column in SQL Server 2008 R2 [closed]
I have a SQL Server 2008 R2 database. This database has two tables called Pictures and PictureUse.
Picture table has the following columns:
Id (int)
PictureName (nvarchar(max))
CreateDate ...
1
vote
7answers
209 views
What are the pros and cons for having a dedicated T-SQL developer on your team?
Our T-SQL developer just gave his two weeks notice. We have been asked if our team of four developers would like an additional developer.
We are offered to do our own T-SQL / Entitiy Framework ...
0
votes
2answers
207 views
Will TSQL become useless because of new ORMs? [closed]
By introducing LINQ to SQL, I found myself and my .NET developer colleagues gradually moving from TSQL to C# to create queries on the database. Entity Framework made that shift almost permanent.
Now ...
2
votes
5answers
835 views
I feel unprepared to start my first job out of college… how can I improve? [closed]
I just graduated from university with a degree in Computer Science/Engineering and was fortunate enough to land a job working in the pharmaceutical industry as a developer. My title is System ...
52
votes
24answers
6k views
How can I explain the difference between NULL and zero?
Working on a problem that uses the percent change formula:
percent change = 100 * [(new value - old value) / old value]
How would I explain the difference if new value or old value = NULL, rather ...
3
votes
1answer
121 views
Is there another name for Sql Azure's programming language?
According to this page on MSDN the sql language used on Sql Azure is called transact-sql (the same as on sql server). But is this the only way to refer to programming on Sql Azure?
The Sql Azure ...
3
votes
2answers
646 views
Bill of materials database design in EF codefirst?
I'm having trouble generating a proper database design for bill of materials in EF Code-first
I just need a general structure then ill add additional fields
So i need to have a Product that is ...
110
votes
19answers
13k views
Why is naming a table's Primary Key column “Id” considered bad practice? [closed]
My t-sql teacher told us that naming our PK column "Id" is considered bad practice without any further explanations.
Why is naming a table PK column "Id" is considered bad practice?
3
votes
3answers
622 views
How to reach to the advanced level in SQL?
I think I have a good grasp of SQL and the most features it has, but sometimes when I've done some more advanced Reporting Services a fellow developer has helped me with some stuff and when I open ...
1
vote
3answers
136 views
Using TSQL for the first time some basic instructions
I am writing an application that will use many tables and I've been told that I must not use stored procedures in this project because it will be too slow.
It has been suggested that I use TSQL. I ...
0
votes
5answers
492 views
Book Recommendation for SQL Server 2008 programmer, especially on index internal and usage
I cannot find an answer from other posts here.
I want to understand the basics of index, and how it affects the performance of SQL Server. I read Chapter 4: Query Tuning of the book below. But I feel ...
8
votes
3answers
364 views
How do you handle constantly changing database dimensions?
For the last two months or so I have been looking for solutions or practices to handle release management within databases. I'm looking for what people view as the best process for handling this.
We ...
0
votes
3answers
718 views
SQL problems and answers book for a functioning SQL programmer
It was pointed out to me yesterday that I need to get a book on SQL and learn about it properly. That is probably a fair assessment; I'm a functioning SQL programmer who can in general extract from ...
