IT Nursery
I have a linkedserver that will change. Some procedures call the linked server like this:...
This question already has answers here: Find a value anywhere in a database (19 answers) Closed 9 years ago. I have a specific ...
-
June 3, 2022
- 0 Comments
I need to ALTER the data types of several columns in a table. For a single column, the following works fine: ALTER TABLE ...
-
June 3, 2022
- 0 Comments
In SQL Server, I have a new column on a table: ALTER TABLE t_tableName ADD newColumn NOT NULL This fails because I specify ...
-
June 2, 2022
- 0 Comments
What’s the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. If a Schema ...
-
June 2, 2022
- 0 Comments
I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where ...
-
June 1, 2022
- 0 Comments
I need to check if a specific login already exists on the SQL Server, and if it doesn’t, then I need to add ...
-
June 1, 2022
- 0 Comments
How could you remove all characters that are not alphabetic from a string? What about non-alphanumeric? Does this have to be a custom ...
-
June 1, 2022
- 0 Comments
I have a table and one of the columns is “Date” of type datetime. We decided to add a default constraint to that ...
-
May 31, 2022
- 0 Comments