Hello Will
I have a vb.net site and I would like to show a div when someone hovers over an element using CSS (not javaScript). Can you help me?
Earl Walker from Washington DC
Using .Net Programming what is the best string concatenation method?
Hello Will
What’s the most efficient way to concatenate strings in .Net Programming
Mario from Germantown
How to script the data stored in a SQL SERVER database table?
I need to find a way to create the schema and data from the tables in the database as sql scripts. The purpose of the scripts is to be able to recreate the database from the scripts.
Do you know of any tools to accomplish this?
How would you hide a SQL SERVER database in the Management studio?
Is it possible to show only the database that a user has rights to when the log in to SQL Server 2008? As the system is set up currently the user can see all the database on the server and have to search through the list of database to find their database.
In Sql Server how can you Truncate decimal places
We are trying to find a way to truncate (i.e. drop all the extra decimal places) in SQL Server. We do not want to have the number rounded at all just truncated as is.
For example:
declare @variable decimal(18,2)
set @variable = 123.456
This will cause the value stored in @variable to be 123.46 (the rounded variable). However this is not what we want. We want the value to be stored as 123.45. Is there an efficient way to remove the decimal places that I do not need in SQL SERVER?
Can sql server injections be prevented using Parameters?
I’m wondering if using parameters in SQL Server queries is enough to prevent SQL injection. Is there any way a parameterized query be used to cause a SQL Server Injection?