Select SQL Server database size
how can i query my sql server to only get the size of database? I used this : use “MY_DB” exec sp_spaceused I … Read more
sql-server
How to find a text inside SQL Server procedures / triggers?
I have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have triggers also doing this kind … Read more
Search all tables, all columns for a specific value SQL Server [duplicate]
This question already has answers here: Find a value anywhere in a database (19 answers) Closed 9 years ago. I have a specific … Read more
How to ALTER multiple columns at once in SQL Server
I need to ALTER the data types of several columns in a table. For a single column, the following works fine: ALTER TABLE … Read more
How to check existence of user-define table type in SQL Server 2008?
I have a user-defined table type. I want to check it’s existence before editing in a patch using OBJECT_ID(name, type) function. What type … Read more
How to do a case sensitive search in WHERE clause (I’m using SQL Server)?
I want to do a case sensitive search in my SQL query. But by default, SQL Server does not consider the case of … Read more
Conversion failed when converting date and/or time from character string while inserting datetime
I was trying to create a table as follows, create table table1(date1 datetime,date2 datetime); First I tried inserting values as below, insert into … Read more
Can I create a named default constraint in an add column statement in SQL Server?
In SQL Server, I have a new column on a table: ALTER TABLE t_tableName ADD newColumn NOT NULL This fails because I specify … Read more
Copy data into another table
How to copy/append data from one table into another table with same schema in SQL Server? Edit: let’s say there is a query … Read more
Difference between database and schema
What’s the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. If a Schema … Read more