A while back, I wrote an article calledCreating a date dimension or calendar table in SQL Server. I have used this pattern repeatedly and, based on the questions I get from the community, many of you are using it, too. Some of the questions I get are along the lines of “how do I...
In the "Report Data" pane, Right-click on the "Datasets" folder to bring up a context menu. We select "Add Dataset…" to open the "Dataset Properties" dialog from the context menu. We select the "Use a shared dataset" option. A list of shared datasets should show in the list box....
ExecContext(ctx, "create table #mytemp ( x int )") // #mytemp is now available even if you pass parameters _, err := conn.ExecContext(ctx, "insert into #mytemp (x) values (@p1)", 1) Return Status To get the procedure return status, pass into the parameters a *mssql.Return...
The first part of the email contains a table with the list of selected databases, the status (“OK” or message of an exception), the name of the generated file or archive, and the sizes of the .bak and .zip files. The second part contains the script’s transcript (i.e. the origin...
Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause. Cannot use the ROLLBACK statement within an INSERT-EXEC statement. Cant Drop Table capitalise the first letter of each word in a string in SQL Server. Capturing the results from exec ...
To list all contained database users, use the following query: SELECT DP.name, DP.type_desc FROM sys.database_principals AS DP WHERE DP.authentication_type_desc = 'DATABASE'; USER ROLES AND PRIVILEGES The review of user roles and privileges is a critical aspect of any MSSQL audit proce...
DataGridView to DataTable DataGridView: Dynamically add column and set column type at runtime (Unbound) Datareader.Read() IS SLOWER THAN EVER DataSource.Error: ODBC: ERROR [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support this parameter DataTable Column to List(of Integer) ...
Configure the Database Table or View settings Configure the Lansweeper settings Configure the Microsoft SMS/SCCM settings Configure the NCM, NPM, and SAM settings Configure the Discovery Engine (WMI) settings Install the MySQL JDBC Driver Install the OpenBase JDBC driver Sync and discover assets Manua...
Select an existing database or input a new database name (click the 'Refresh' button to list all databases). If the target database does not exist, this tool will automatically create it during the migration process. In "Select source Tables(s) & View(s)" dialog; Select the tables or...
For a list of reserved words in Oracle, see the Oracle9i SQL Reference, Release 1 (9.0.1). Table Design Considerations This section discusses the many table design issues that you need to consider when converting Microsoft SQL Server and Sybase Adaptive Server databases to Oracle. These issues ...