IT Nursery > News > sql-server

sql-server

Programming, sql

IT Nursery

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 ...

June 4, 2022
0 Comments

Programming, sql-server

IT Nursery

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:...

June 3, 2022
0 Comments

Programming, sql-server

IT Nursery

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 ...

June 3, 2022
0 Comments

Programming, sql-server

IT Nursery

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 ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

June 3, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

June 2, 2022
0 Comments

Programming, sql-server

IT Nursery

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 ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

June 2, 2022
0 Comments

Programming, sql-server

IT Nursery

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 ...

June 2, 2022
0 Comments