how can i query my sql server to only get the size of database? I used this : use “MY_DB” exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several column that i don’t need, maybe there is a trick to select database_size column from this … Read more
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 of work. We need to find all places that uses [10.10.100.50] to change it. In SQL Server Management Studio Express, I didn’t find a feature like “find in whole database” in Visual … Read more
This question already has answers here: Find a value anywhere in a database (19 answers) Closed 9 years ago. I have a specific value, let’s say string ‘comments’. I need to find all instances of this in the database as I need to do an update on the format to change it to (*) Comments. … Read more
I need to ALTER the data types of several columns in a table. For a single column, the following works fine: ALTER TABLE tblcommodityOHLC ALTER COLUMN CC_CommodityContractID NUMERIC(18,0) But how do I alter multiple columns in one statement? The following does not work: ALTER TABLE tblcommodityOHLC ALTER COLUMN CC_CommodityContractID NUMERIC(18,0), CM_CommodityID NUMERIC(18,0) 13 Answers 13
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 from the enumeration should be passed for user-defined table types? N’U’ like for user defined table doesn’t work, i.e. IF OBJECT_ID(N’MyType’, N’U’) IS NOT NULL 5 Answers 5
I want to do a case sensitive search in my SQL query. But by default, SQL Server does not consider the case of the strings. Any idea on how to do a case sensitive search in SQL query? 11 Answers 11
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 table1 values(’21-02-2012 6:10:00 PM’,’01-01-2001 12:00:00 AM’); It has given error saying, Cannot convert varchar to datetime Then I tried below format as one of the post suggested by our stackoverflow, insert into … Read more
In SQL Server, I have a new column on a table: ALTER TABLE t_tableName ADD newColumn NOT NULL This fails because I specify NOT NULL without specifying a default constraint. The table should not have a default constraint. To get around this, I could create the table with the default constraint and then remove it. … Read more
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 select * into table1 from table2 where 1=1 which creates table1 with the same schema as well as data as in table2. Is there any short query like this to only copy … Read more
What’s the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. If a Schema is deleted, then are all the tables contained in that schema also deleted automatically or are they deleted when the Database is deleted? 5 Answers 5