tsql Archives - Page 10 of 17

How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5) 10 Answers 10

I would like to write a single SQL command to drop multiple columns from a single table in one ALTER TABLE statement. From ...

Inspired by this question where there are differing views on SET NOCOUNT… Should we use SET NOCOUNT ON for SQL Server? If not, ...

In Microsoft SQL Server how can I get a query execution plan for a query / stored procedure? 13 Answers 13

What is the general guidance on when you should use CAST versus CONVERT? Is there any performance issues related to choosing one versus ...

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, ...

I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name. ...

I have a start_date and end_date. I want to get the list of dates in between these two dates. Can anyone help me ...

I need a different random number for each row in my table. The following seemingly obvious code uses the same random value for ...

What query can return the names of all the stored procedures in a SQL Server database If the query could exclude system stored ...