大约有 3,549 项符合查询结果（耗时：0.0118秒） [XML]
Import CSV file into SQL Server
I am looking for help to import a .csv file into SQL Server using BULK INSERT and I have few basic questions.
12 Answer...
How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
Let's just suppose I have a valid need for directly executing a sql command in Entity Framework. I am having trouble figuring out how to use parameters in my sql statement. The following example (not my real example) doesn't work.
...
How do I see active SQL Server connections?
I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, connect to which database or something.
...
Best way to test SQL queries [closed]
I have run into a problem wherein we keep having complex SQL queries go out with errors. Essentially this results in sending mail to the incorrect customers and other 'problems' like that.
...
Calculate a Running Total in SQL Server
...
Update, if you are running SQL Server 2012 see: https://stackoverflow.com/a/10309947
The problem is that the SQL Server implementation of the Over clause is somewhat limited.
Oracle (and ANSI-SQL) allow you to do things like:
SELECT somedate, som...
Run a PostgreSQL .sql file using command line arguments
I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to open them and copy the INSERT statements into an editor window and run them there. I found on ...
What is the advantage of using heredoc in PHP? [closed]
... avoiding quoting issues. Back in the day I used to use them to construct SQL queries:
$sql = <<<SQL
select *
from $tablename
where id in [$order_ids_list]
and product_name = "widgets"
SQL;
To me this has a lower probability of introducing a syntax error than using quotes:
$sql =...
How can I run just the statement my cursor is on in SQL Server Management Studio?
...is not possible."
Edit:
Here is how I was able to do this:
1 - Download SQL Developer
2 - Download the jTDS driver
3 - Follow these instructions to add that driver to SQL Developer
4 - Connect to SQL Server using SQL Developer (cool!)
5 - Run it and life is good
...
Import SQL dump into PostgreSQL database
We are switching hosts and the old one provided a SQL dump of the PostgreSQL database of our site.
15 Answers
...
How to get script of SQL Server data? [duplicate]
I'm looking for a way to do something analogous to the MySQL dump from SQL Server. I need to be able to pick the tables and export the schema and the data (or I can export the schema via SQL Server Management Studio and export the data separately somehow).
...