search
Login

Categories


C Books Guide and List
C++ Books Guide and List
Best Java Books

3.8k questions

4k answers

117 comments

10.7k users

Recent questions tagged sql-server

0 votes
1 answer 15 views
asked felin Advisor 8.4k points 10 15 18
0 votes
1 answer 23 views
asked sunny Expert 11.4k points 14 22 28
0 votes
1 answer 19 views
asked kelly johnes Advisor 6.3k points 5 21 31
0 votes
1 answer 16 views
0 votes
1 answer 23 views
0 votes
1 answer 24 views
0 votes
1 answer 19 views
0 votes
1 answer 44 views
0 votes
1 answer 104 views
When and Why does some one decide that they need to create a View in their database? Why not just run a normal stored procedure or select?
asked anonymous
0 votes
1 answer 74 views
I do not want to create manually and maintain truncate table statements for each table.
asked anonymous
0 votes
1 answer 46 views
How do you connect Visual Basic with SQL server database?
asked om Sr Member 1.3k points 7 16 31
0 votes
1 answer 42 views
Can someone explain the implications of using "with (nolock)" on queries, when you should/shouldn't use it?
asked om Sr Member 1.3k points 7 16 31
0 votes
1 answer 34 views
asked om Sr Member 1.3k points 7 16 31
0 votes
1 answer 1.3K views
Convention has it that table names should be the singular of the entity that they store attributes of. I dislike any T-SQL that requires square brackets around names, but I have renamed a Users table to the singular, forever sentencing those using the table to sometimes have to use brackets. What Should I use?
asked om Sr Member 1.3k points 7 16 31
0 votes
1 answer 57 views
Consider a table holding names, with three rows: Simi Khushi Akshay Is there an easy way to turn this into a single string of Simi, Khushi,Akshay?
asked aryan Jr Member 840 points 1 2 12
0 votes
1 answer 1.4K views
See this query containing number of arguments: select * from Tags where Name in ('ruby','rails','scruffy','rubyonrails') order by Count desc In this query, the number of arguments could be anywhere from 1 to 5. I would prefer not to use a dedicated stored procedure for this (or XML), but if there is some fancy SQL Server 2008 specific way of doing it.
asked om Sr Member 1.3k points 7 16 31
0 votes
1 answer 3.8K views
0 votes
1 answer 47 views
asked dhaval Sr Member 1.9k points 1 2 6
...