SQL Server is a relational database management system from Microsoft.
-5
votes
0answers
23 views
Regardig Vb.net [closed]
hi everyone i am making a project for school management and manage all the record of student so I'm using VB.net 2008 and sql server 2008. i have a problem when i enter student date of birth in text ...
1
vote
3answers
75 views
Is it more difficult to upgrade your certification from SQL Server 2008 to 2012 than to get it from scratch? [closed]
I was wondering about the new MCSA certification on SQL 2012 and how it seems to be more difficult to upgrade your certification from 2008 to 2012 than to get the 2012 from scratch.
Reason I think ...
1
vote
0answers
64 views
Calling MSSQL stored procedure from Zend Controller ? Any other approaches?
MSSQL and DB, Zend as PHP Framework,
I am using this way to call SP with I/P Parameters and to get O/p Parameters.
It seems I am writing SQL code in PHP.
Any other good approaches?
$str1 = ...
2
votes
1answer
119 views
Does the deprecation of mysql_* functions in PHP carry over to other Databases(MSSQL)?
I'm not talking about MySQL, I'm talking about Microsoft SQL Server
I've been aware of PDO for quite some time now, standard mysql functions are dangerous and should be avoided.
...
2
votes
4answers
171 views
We are moving an Access based corporate front-end into a Web-based App
We have an enterprise application with a front end written in Microsoft Access 2003 that has evolved over the past 6 years. The back end data, and a fair amount of back-end logic is contained within ...
0
votes
4answers
225 views
SQL Server Management Studio Show last executed query
I am looking for a way for SQL Server Management studio to show me the last SQL query that was run. For example, when I make modifications to a table in the designer mode, I will eventually want to ...
2
votes
2answers
230 views
SQL Server 2000 vs 2008 Express? [closed]
Due to not wanting to pay licenses my company is still using SQL Server 2000 for new projects.
This is very limiting for multiple reasons.
I'm wondering what are the limitations of using SQL Server ...
5
votes
2answers
136 views
Best method to implement a filtered search
I would like to ask you, your opinion when it comes to implement a filtered search form. Let's imagine the following case:
1 Big table with lots of columns
It might be important to say that this SQL ...
3
votes
3answers
195 views
Why should I add CHECK CONSTRAINT?
Following is a table creating script created by Entity Framework using the model shown in http://codereview.stackexchange.com/questions/14077/is-it-proper-tpt-inheritance.
In this script, there are ...
1
vote
2answers
406 views
Best practices: Ajax and server side scripting with stored procedures
I need to rebuild an old huge website and probably to port everyting to ASP.NET and jQuery and I would like to ask for some suggestion and tips. Actually the website uses:
Ajax (client site with ...
4
votes
2answers
90 views
Are there tools that do automated validation of database standards?
I'm looking for something akin to FxCop, but for databases. Basically, I want to have a tool where I configure my database standards (naming conventions, field types, or more complex custom rules). ...
1
vote
3answers
233 views
Is an API in C++ a better alternative to computing directly in SQL?
I need to perform large amounts of computations on data storerd in a busy Microsoft SQL server. Would it be faster if I retrieve the data from the server, perform the computations locally in C++, and ...
5
votes
4answers
357 views
How do you keep track of the meaning of your SQL fields?
The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data.
I use SQL ...
9
votes
3answers
711 views
Why do we need to put N before strings in Microsoft SQL Server?
I'm learning T-SQL. From the examples I've seen, to insert text in a varchar() cell, I can write just the string to insert, but for nvarchar() cells, every example prefix the strings with the letter ...
0
votes
3answers
282 views
Is this overkill? Using MDX queries and cubes instead of SQL stored procedures
I am new to Microsoft's SQL Server Analysis Services Cubes and MDX queries. Where I work we have a daily sales table in SQL Server 2005 that already contains an aggregate of sale information per ...
