The problem with the former is that what you’re doing is USE ‘myDB’ rather than USE myDB. you’re passing a string; but USE is looking for an explicit reference. The latter example works for me. DECLARE @sql varchar(20) SELECT @sql=”USE myDb” EXEC sp_sqlexec @Sql — Also works SELECT @sql=”USE [myDb]” EXEC sp_sqlexec @Sql
You are trying to restore a SQL Server 2000 database on SQL Server 2012. This is not supported. You will need to restore your database on an instance of SQL Server 2005, 2008 or 2008 R2 first, then back it up from there, then restore the new backup on SQL Server 2012. Microsoft explains this … Read more
CONVERT takes the column name, not a string containing the column name; your current expression tries to convert the string A.my_NvarcharColumn to an integer instead of the column content. SELECT convert (int, N’A.my_NvarcharColumn’) FROM A; should instead be SELECT convert (int, A.my_NvarcharColumn) FROM A; Simple SQLfiddle here.
I ended up using a slightly modified version of VDR’s solution which waits for the sqlservr to start by checking the logs instead of sleeping 10 seconds: RUN ( /opt/mssql/bin/sqlservr –accept-eula & ) | grep -q “Service Broker manager has started” \ && /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ‘P@ssw0rd’ -i /opt/mssql-scripts/000_create_db.sql \ && pkill … Read more
exec msdb..sp_update_job @job_name=”Job Name”, @enabled = 0 –Disable exec msdb..sp_update_job @job_name=”Job Name”, @enabled = 1 –Enable
You can’t use a function directly as a stored procedure parameter. You can do the following: DECLARE @now DateTime SET @now = GETDATE() DECLARE @return_value int EXEC @return_value = my_stored_procedure @MyId = 1, @MyDateField = @now SELECT ‘Return Value’ = @return_value GO
you need to declare your cursor as scroll, like this declare c scroll cursor for (select statement); then at any time for locating to the first just use the following fetch first from c;
You can use a recursive CTE to build your list of 30 days, then join that to your data –test select cast(’05 jan 2011′ as datetime) as DT, 1 as val into #t union all select CAST(’05 jan 2011′ as datetime), 1 union all select CAST(’29 jan 2011′ as datetime), 1 declare @start datetime=”01 jan … Read more
It isn’t possible to do a bulk insert for this file, from MSDN: To be usable as a data file for bulk import, a CSV file must comply with the following restrictions: Data fields never contain the field terminator. Either none or all of the values in a data field are enclosed in quotation marks … Read more
If your production SQL server and test SQL server can talk, you could just do in with a SQL insert statement. first run the following on your test server: Execute sp_addlinkedserver PRODUCTION_SERVER_NAME Then just create the insert statement: INSERT INTO [PRODUCTION_SERVER_NAME].DATABASE_NAME.dbo.TABLE_NAME (Names_of_Columns_to_be_inserted) SELECT Names_of_Columns_to_be_inserted FROM TABLE_NAME