sql-server Archives - Page 30 of 39

How do I query for all dates greater than a certain date in SQL Server?

I’m trying: SELECT * FROM dbo.March2010 A WHERE A.Date >= 2010-04-01; A.Date looks like: 2010-03-04 00:00:00.000 However, this is not working. Can anyone ...

May 6, 2022
0 Comments

Does a foreign key automatically create an index?

I’ve been told that if I foreign key two tables, that SQL Server will create something akin to an index in the child ...

May 6, 2022
0 Comments

SQL Server SELECT into existing table

I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is ...

May 6, 2022
0 Comments

Get list of databases from SQL Server

How can I get the list of available databases on a SQL Server instance? I’m planning to make a list of them in ...

May 6, 2022
0 Comments

What is the use of GO in SQL Server Management Studio & Transact SQL?

SQL Server Management Studio always inserts a GO command when I create a query using the right click “Script As” menu. Why? What ...

May 6, 2022
0 Comments

How to use GROUP BY to concatenate strings in SQL Server?

How do I get: id Name Value 1 A 4 1 B 8 2 C 9 to id Column 1 A:4, B:8 2 ...

May 6, 2022
0 Comments

How Stuff and ‘For Xml Path’ work in SQL Server?

Table is: Id Name 1 aaa 1 bbb 1 ccc 1 ddd 1 eee Required output: Id abc 1 aaa,bbb,ccc,ddd,eee Query: SELECT ID, ...

May 6, 2022
0 Comments

What is the meaning of the prefix N in T-SQL statements and when should I use it?

I have seen prefix N in some insert T-SQL queries. Many people have used N before inserting the value in a table. I ...

May 5, 2022
0 Comments

Efficiently convert rows to columns in sql server

I’m looking for an efficient way to convert rows to columns in SQL server, I heard that PIVOT is not very fast, and ...

May 5, 2022
0 Comments

Cannot Connect to Server – A network-related or instance-specific error

I get the following error when trying to connect to SQL Server: A network-related or instance-specific error occurred while establishing a connection to ...

May 5, 2022
0 Comments